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

11 votes203 views1 answer
Oracle view source
SQL
8 votes206 views2 answers
Grant all privileges database postgres to user
SQL
-2 votes187 views1 answer
Modify column name in tsql
SQL
1 vote145 views1 answer
Oracle compile schema
SQL
0 vote182 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote203 views1 answer
Mysql trigger to delete old data
SQL
8 votes227 views2 answers
Default sql server port
SQL
0 vote190 views1 answer
Components/Fields of Internal Table
SQL
-2 votes188 views1 answer
Create trigger syntax
SQL
0 vote200 views1 answer
Mysql regex select
SQL