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 vote192 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote188 views1 answer
How to output a different column name in mysql
SQL
3 votes203 views3 answers
Mysql order by list
SQL
2 votes218 views2 answers
Spring where to put the data sql
SQL
1 vote236 views1 answer
Does insert into overwrite sql
SQL
0 vote264 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote206 views1 answer
Sql into vs insert into
SQL
0 vote193 views1 answer
Hive batch drop table
SQL
0 vote200 views1 answer
Mysql 8 geo to json
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL