Need guidelines for adding a new field to a “real time” table to be fed to a Data Lake
Summary:
Need guidelines or steps to understand adding of a new field to a real time table
Content (please ensure you mask any confidential information):
Per our business team needs, there is a request to add "Auto Routed First Date" column to Activity table and populate it with the data using a Message Scenario step when Activity is created, so that it can be ingested in our AZURE Data Lake for reporting and analysis.
Can I freely add new columns to the Autonomous Database feed to our DL table "APPT" from OFS without impacting the real time status? In other words, the data that exists remains in the APPT table and the new column is added and populated without requiring any changes to the real time status of the feed?