search

microsoft / Dynamics-365-FastTrack-Implementation-Assets

Dynamics 365 FastTrack Implementation guides
MIT License
284 stars 188 forks source link

Added pipelinerunid param to manage count of CUD rows #311

Closed marcoscotoni closed 3 months ago

marcoscotoni commented 4 months ago

This modification affects the pipeline template "Analytics/DataverseLink/DataIntegration/DVLinkToSQL_IncrementalCopy.zip" and the "Step1_EDL_To_SynapseLinkDV_CreateUpdate_SetupScript.sql"

Adding a new parameter "pipelinerunid" for dedup and merge script to keep the "datalaketosql" table updated with counts of created, updated, and deleted rows.

Plus added a parameter and an update query on the stored procedure.