Snowflake duplicates

Hi there,

There seems to have been a similar question on the Snowflake community fourm here:

https://community.snowflake.com/s/question/0D50Z00008EJgemSAD/how-to-delete-duplicate-records-

I could suggest trying out the instructions from the accepted answer on how to handle deleting duplicate records, eg:

• If all columns are duplicated, then the only solution that I am aware of is to do a SELECT DISTINCT from the table into a new table (and then rename/swap table names).
• If only the key is duplicated, and within each key there are one or more other columns that can be used to form a composite key, then you can build a temp result that contains the composite key that you want to maintain.

Hope that this helps!

Best,

Bobby