Can I change a column to be an identity column in Snowflake if it already exists?
There is no easy way to alter a table and change a column to an identity column if there is data in the table. If there is no data in the table then its actually easiest to add a new column which does the autoincrement and drop (remove) the existing column you wanted to alter if that is better for your table. [SIMILAR Question]