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

3 votes237 views2 answers
Wp do sql query from function
SQL
0 vote244 views1 answer
How to rename a database in tsql
SQL
1 vote232 views2 answers
Limit sqlserver
SQL
0 vote344 views1 answer
Mysql delete entire row on condition
SQL
0 vote185 views1 answer
What is between keyword used for
SQL
0 vote215 views1 answer
Calculer pourcentage mysql
SQL
0 vote238 views1 answer
Double in sql server example
SQL
1 vote225 views2 answers
Sql now - 1 day
SQL
0 vote270 views1 answer
Run docker container with database as rds metabase
SQL
0 vote269 views1 answer
Delet all record statment sql
SQL