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 vote320 views2 answers
Oracle chain rules
SQL
2 votes317 views2 answers
Get all tables using like
SQL
1 vote330 views3 answers
Reseed sql table primary key
SQL
0 vote331 views1 answer
Get last inserted primary key
SQL
0 vote313 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
1 vote276 views1 answer
How to delete record sql delphi
SQL
0 vote300 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote281 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote304 views2 answers
Athena drop partition
SQL
5 votes312 views1 answer
How to get all table names in sql query
SQL