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 votes287 views1 answer
Force using index plsql
SQL
0 vote332 views1 answer
Postgres list all triggers
SQL
1 vote297 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote239 views2 answers
How to combine two sql queries in one result
SQL
0 vote234 views1 answer
Mysql insert with foreign key
SQL
3 votes269 views1 answer
Oracle nextval
SQL
0 vote294 views2 answers
Import .sql into postgres db command
SQL
0 vote237 views1 answer
Calculate discount from original price sql
SQL
0 vote280 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
10 votes294 views2 answers
Rtrim sql
SQL