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 vote387 views1 answer
Sqlite unique multiple columns
SQL
2 votes336 views1 answer
Oracle trace session
SQL
2 votes341 views1 answer
Enum in SQL Server
SQL
79 votes625 views6 answers
Grepper code
SQL
0 vote347 views1 answer
Mysqldump ignore table
SQL
0 vote392 views1 answer
Sqlcl format
SQL
0 vote356 views1 answer
Mysql select smaller of two values
SQL
0 vote345 views2 answers
Close external port 3306 with iptables
SQL
0 vote365 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
62 votes480 views8 answers
Mysql add column
SQL