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

0 vote294 views1 answer
MySql Modify Increment
SQL
1 vote290 views1 answer
Mysql pretty date format
SQL
11 votes325 views4 answers
MYSQL LOGIN
SQL
-1 vote314 views2 answers
Postgresql user permissions to database
SQL
0 vote288 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes313 views1 answer
Mysql clear screen
SQL
17 votes310 views2 answers
Mysql date to string
SQL
0 vote330 views1 answer
Gcloud sql instance list
SQL
0 vote314 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote318 views1 answer
Sql reverse order of results
SQL