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 vote279 views1 answer
What logs are available on RDS MySQL?
SQL
3 votes261 views2 answers
Create schema postgres
SQL
9 votes253 views1 answer
Oracle get table schema
SQL
0 vote260 views1 answer
Postgresql comandos basicos
SQL
0 vote264 views1 answer
Oracle cpu metric
SQL
0 vote247 views1 answer
Sql server 2012 create or alter procedure
SQL
7 votes262 views1 answer
Sql limit decimal places
SQL
0 vote234 views1 answer
Mysql events not work
SQL
7 votes265 views3 answers
SQL create a new table
SQL
0 vote255 views1 answer
Vbscript clean up ADODB.Recordset
SQL