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

38 votes178 views6 answers
Alter table mysql
SQL
0 vote230 views1 answer
Php insert null mysql
SQL
0 vote172 views1 answer
Mysql count by month
SQL
2 votes183 views1 answer
Sql server find columns list in tables
SQL
0 vote194 views1 answer
Nuget sqllite-net-pcl
SQL
2 votes128 views4 answers
Mysql change database character set to utf8mb4
SQL
22 votes166 views2 answers
Mysql show all tables
SQL
10 votes164 views1 answer
All_dependencies
SQL
0 vote176 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote156 views2 answers
How to drop a unique constraint in sql
SQL