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

9 votes108 views1 answer
Sql server get utc date
SQL
0 vote116 views1 answer
Postgresql create table with boolean column
SQL
0 vote118 views1 answer
Mysql sql.gz
SQL
7 votes130 views3 answers
Sql server reset auto increment
SQL
0 vote99 views1 answer
How to create an SQL save method in ruby
SQL
0 vote106 views1 answer
Calculate date and convert to yearsmysql
SQL
16 votes136 views6 answers
Python sqlite
SQL
6 votes130 views2 answers
WHERE value IS sql
SQL
0 vote147 views1 answer
Sqlalchemy query return only n results
SQL
0 vote134 views2 answers
Update query with between in mysql
SQL