CODEWITHSUNDEEP
snowflake-cloud-data-platform
Kannan Ramamoorthy
Kannan Ramamoorthy

Reputation: 4180

Ordinal of a new column in snowflake table

I am trying to add a new column to an existing Table in snowflake, how to specify where to add the column. I tried the below query,

ALTER TABLE MY_DB.MY_SCHEMA.MY_TABLE 
ADD COLUMN MY_NEW_COLUMN NUMBER(38,0) AFTER MY_OLD_COLUMN1;

AFTER keyword doesn't works with Snowflake. Any suggestions on this would be helpful.

Upvotes: 8

Views: 7260

Answers (1)

Marcin Zukowski
Marcin Zukowski

Reputation: 4729

Today Snowflake does not have the ability to specify the position of the added column. It is in the list of future improvements, but we don't have an ETA on this yet.

Of course there are various solutions that might help, e.g. views, but I agree we'd ideally add this ability.

Let us know if we can help with anything else.

Upvotes: 6

Related Questions