24 Dec 19 · KRISTIM · #Snowflake ·   Bookmark   ×

Update table definition in Snowflake

I have created a table in Snowflake... How do I update the name of a column, and then change the order of the columns? There are 3 total (for ex.  Good, Bad, Date)


posted on 24 Dec 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Once you have created a table, you can use the alter table commands to modify the table structures, refer to Snowflake alter table command

However, you will not be able to modify the order of the columns or change a column name. You will have to drop and recreate if you want to change the order

Community Software by Hittly