ROWID equivalent in Snowflake to delete duplicate lines

Question

I have a database with duplicate lines. I usally use the rowid, but it doesn't exist in Snowflake. How can I remove duplicate lines in Snowflake without this ? I try severals solution for the moment but without sucess ! Tanks

Answer 1

It seems that there is no equivalent to the ROWID in Snowflake.A Workaround is to do a select distinct and then insert the result in the same table.

insert overwrite into some_table
select distinct * from some_table;