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 vote182 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
38 votes247 views6 answers
Alter table mysql
SQL
0 vote221 views1 answer
Select 1 from orders
SQL
4 votes190 views3 answers
Mysql modify foreign key
SQL
0 vote192 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote187 views1 answer
Create column that already exists mysql
SQL
2 votes176 views1 answer
How to select first row of database sql
SQL
0 vote188 views1 answer
Delete hangfire retries list
SQL
10 votes184 views3 answers
Join multiple tables sql
SQL
31 votes189 views4 answers
How to get duplicate records with multiple field in sql
SQL