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 votes373 views2 answers
Postgresql remove not null constraint
SQL
0 vote388 views1 answer
Rename constraint postgresql
SQL
6 votes359 views3 answers
Commit in sql
SQL
3 votes336 views2 answers
Oracle sql drop sequence
SQL
0 vote384 views1 answer
Rails sql query converstion
SQL
7 votes377 views1 answer
Alter sequence set current value oracle
SQL
8 votes339 views1 answer
Sql remove characters from string right
SQL
7 votes348 views3 answers
Postgre describe table
SQL
5 votes381 views2 answers
Get number of columns sql
SQL
0 vote370 views3 answers
Select random sql
SQL