Yeah. I knew that, but removing them afterwards seems "a big chunk of work" and never being a satisfactory solution, eg: [1] https://community.snowflake.com/s/

Yeah. I knew that, but removing them afterwards seems "a big chunk of work" and never being a satisfactory solution, eg: [1] https://community.snowflake.com/s/question/0D50Z00007Ft37mSAB/how-can-i-delete-duplicate-records-from-snowflake-tablegiven-that-a-column-name-is-unique-but-does-not-have-the-constraint-as-cte-is-not-fully-supported https://community.snowflake.com/s/question/0D50Z00007Ft37mSA... [2] https://stackoverflow.com/questions/35372889/a-simpler-more-efficient-way-to-remove-duplicate-rows-from-an-sql-server-table https://stackoverflow.com/questions/35372889/a-simpler-more-...