Data Automation
Enhancements
- ELT Insert-Select, ELT Merge Into, and ELT SCD2 Snaps show the following statistics on execution as illustrated in the figure below:
- Records Added
- Records Updated
- Records Deleted
Note: The statistics are also available in the output view of the child ELT Pipeline.
Known Issues
- If the last Snap in the Pipeline takes 2 to 5 seconds to update the runtime, the ELT Pipeline statistics are not displayed even after the Pipeline is completed. The UI does not autorefresh to display the statistics after the runtime.
Workaround: Close the Pipeline statistics window and reopen it to see the ELT Pipeline statistics.
- In the ELT Merge IntoSnap, the Records Updated parameter in the Snap Statistics tab (on Pipeline execution) displays the combined count of records that were inserted, updated, and deleted for target CDWs: Azure Synapse, Amazon Redshift, and DLP. However, in Snowflake target instances this issue is fixed in the patch release [build number] to display the individual record counts.
- When you return to the Snap Statistics tab from the Extra Details tab in the Pipeline Execution Statistics pane, it contains the status bar (Pipeline execution status) instead of the Download Query Details hyperlink and the individual counts of Records Added, Records Updated, and Records Deleted.