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 vote152 views1 answer
Psql no such file or directory
SQL
0 vote148 views1 answer
Psql check table fields
SQL
0 vote142 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote130 views1 answer
List all permissions on a table in postgres
SQL
0 vote154 views1 answer
Mariadb change column type
SQL
0 vote142 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote156 views3 answers
Convert sql query to python pandas
SQL
1 vote148 views1 answer
Query for all indexes in table postgres
SQL
1 vote139 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote137 views1 answer
Find most frequent value in SQL column
SQL