I have simple task at hand. I have close to 200 unique million records seating in a staging table on Azure Synapse. The task is to run an insert statement to insert data into final table. Sounds simple, but here is the problem I am running into for which I am scratching my head. Every time I execute insert random rows are duplicated in final table. I have checked multiple times that staging table has all unique values based on combination of composite key of 3 columns.
Has anyone ran into this weird issue before? Any help would be highly appreciated.