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

3 votes313 views1 answer
Sql timestamp to date
SQL
0 vote323 views1 answer
Start stop mysql linux
SQL
2 votes343 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
3 votes319 views3 answers
Sql last week
SQL
0 vote321 views1 answer
Guid string to binary better
SQL
1 vote309 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote328 views1 answer
Psotgres multiple values
SQL
18 votes318 views3 answers
Mysql query add column with default string value
SQL
6 votes293 views1 answer
Oracle trigger after connect
SQL
0 vote319 views1 answer
Sql select most frequent value in column
SQL