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 vote247 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote199 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote212 views1 answer
Sql developer connect to sql server
SQL
8 votes206 views1 answer
How to check mysql version in xampp
SQL
2 votes201 views1 answer
Columns Present in a table
SQL
7 votes210 views4 answers
Index in mysql
SQL
4 votes214 views2 answers
What is table in sql
SQL
4 votes235 views2 answers
Oracle unliock account
SQL
0 vote311 views1 answer
Sql server query all database objects
SQL
1 vote226 views1 answer
Incompatible sql_mode=only_full_group_by
SQL