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.