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

1 vote184 views2 answers
Mysql show views
SQL
9 votes185 views3 answers
Oracle undo usage by session
SQL
6 votes179 views1 answer
Postgresql get year
SQL
11 votes199 views3 answers
How to get last row of table in sql
SQL
0 vote176 views1 answer
Contraint default SQL
SQL
1 vote192 views1 answer
Apex ORA-20999
SQL
0 vote179 views1 answer
Sql delete caracter list
SQL
0 vote166 views1 answer
Postgres get running query
SQL
1 vote210 views1 answer
Oracle show execution plan
SQL
0 vote206 views1 answer
Create synonym for dblink in oracle
SQL