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

15 votes200 views2 answers
How to know the username of postgresql
SQL
0 vote302 views1 answer
Get statis values sql
SQL
2 votes213 views1 answer
Install postgresql centos 5
SQL
0 vote214 views1 answer
Systems sql
SQL
6 votes190 views1 answer
Phpmyadmin reset root password
SQL
3 votes217 views3 answers
Start postgresql ubuntu
SQL
15 votes233 views4 answers
Sql update from select
SQL
-1 vote194 views3 answers
Update mongodb version ubuntu
SQL
0 vote196 views1 answer
Docker export psql sql
SQL
0 vote196 views1 answer
How to count null values in sql
SQL