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 vote141 views1 answer
Sql add calculated column
SQL
0 vote159 views1 answer
Reset postgres table index to next max value
SQL
34 votes132 views6 answers
Sql change data type
SQL
0 vote141 views1 answer
Mysql terminal list table
SQL
1 vote145 views1 answer
Postgresql escape single quote
SQL
1 vote133 views1 answer
Add constraint sql
SQL
2 votes148 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote157 views1 answer
Increase existing date in sql oracle
SQL
0 vote161 views1 answer
Sql basic commands
SQL
0 vote176 views1 answer
How to make sure two tables have same exact data in sql
SQL