File /Analytics/DataverseLink/EDL_To_SynapseLinkDV_DBSetup/Step1_EDL_To_SynapseLinkDV_CreateUpdate_SetupScript.sql is using getdate() for declaration of the newdatetimemarker which can cause an issue by transferring data between environments with different time zones.
My example is: Synapse link uses UTC time, but destination server was set up with Paris/Berlin... time zone.
I mean this piece of code:
declare @newdatetimemarker datetime2 = getdate();
I would use getutcdate() instead.
File /Analytics/DataverseLink/EDL_To_SynapseLinkDV_DBSetup/Step1_EDL_To_SynapseLinkDV_CreateUpdate_SetupScript.sql is using getdate() for declaration of the newdatetimemarker which can cause an issue by transferring data between environments with different time zones.
My example is: Synapse link uses UTC time, but destination server was set up with Paris/Berlin... time zone.
I mean this piece of code:
declare @newdatetimemarker datetime2 = getdate();
I would use getutcdate() instead.