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 vote106 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote99 views1 answer
Sql create text column limited values
SQL
1 vote100 views1 answer
Tsql create unique index composite
SQL
20 votes100 views1 answer
Get all table name in sql through php
SQL
0 vote99 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
8 votes174 views1 answer
Oracle search code in packages
SQL
7 votes110 views6 answers
Mysql group concat
SQL
0 vote123 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
11 votes169 views1 answer
Oracle insert from select
SQL
1 vote103 views1 answer
Postgres convert date to string
SQL