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 vote196 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote182 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
1 vote188 views1 answer
Mysql strict_trans_tables
SQL
11 votes173 views2 answers
Oracle source code
SQL
20 votes175 views1 answer
Sql change column types
SQL
0 vote174 views1 answer
Postgresql update to unique
SQL
4 votes215 views2 answers
DB::transaction
SQL
0 vote163 views1 answer
Check if table exists oracle
SQL
1 vote177 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote184 views1 answer
Oserror mysql_config not found virtualenv
SQL