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 vote329 views1 answer
Formatting code with SQL Developer
SQL
0 vote348 views1 answer
Selecting duplicates
SQL
0 vote310 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes370 views1 answer
Creating a view SQL
SQL
5 votes352 views2 answers
Oracle list columns
SQL
0 vote326 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote354 views1 answer
Show specific events on mysql
SQL
0 vote317 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote318 views1 answer
How to install mysql without admin rights
SQL
11 votes328 views5 answers
How to install sqlite3 python
SQL