Snowflake alter column data type

Change column type snowflake

alter table TABLE_NAME add column TEMP_COLUMN TIMESTAMP_LTZ(9);

update TABLE_NAME t1
  set t1.TEMP_COLUMN = TO_TIMESTAMP_LTZ(t2.TIMESTAMP_NTZ_COLUMN_NAME)
  from TABLE_NAME t2
  where t1.TEMP_COLUMN = t2.TIMESTAMP_NTZ_COLUMN_NAME

// if you don't want troubles create a new copy of table and use SWAP WITH instead
alter table aws_config rename column TIMESTAMP_NTZ_COLUMN_NAME to TIMESTAMP_NTZ_COLUMN_NAME_OLD;
alter table aws_config rename column TEMP_COLUMN to TIMESTAMP_NTZ_COLUMN_NAME;

alter table aws_config drop column TIMESTAMP_NTZ_COLUMN_NAME_OLD

Snowflake alter column data type

alter table t1 alter c4 set data type varchar(50)

Source: docs.snowflake.com

Similar codes

1 vote180 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote199 views1 answer
Delete specific row in sql
SQL
3 votes146 views1 answer
V$session not found in oracle
SQL
1 vote208 views1 answer
Tsql update datetime
SQL
2 votes192 views1 answer
Delete all value query
SQL
0 vote194 views1 answer
Conda install pymysql "windows"
SQL
1 vote181 views2 answers
Mysql spring boot application.properties
SQL
0 vote201 views1 answer
Alter table add check constraint oracle
SQL
0 vote235 views1 answer
Creating sqeuence in oracle database
SQL
48 votes294 views3 answers
Psql create database
SQL