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 vote309 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote316 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote333 views1 answer
Incorrect string value: mysql
SQL
0 vote360 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes323 views1 answer
Get hour from date sql
SQL
7 votes340 views5 answers
Sql remove spaces
SQL
0 vote338 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote335 views1 answer
Sql ignore
SQL
1 vote298 views4 answers
Fatal database postgres does not exist
SQL
0 vote347 views4 answers
Sql rownum
SQL