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

6 votes293 views2 answers
Mysql execute file
SQL
0 vote260 views1 answer
How to find database collation in postgres
SQL
1 vote283 views1 answer
Mysql event last execution
SQL
2 votes255 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote279 views1 answer
Check if database exists sql
SQL
0 vote288 views1 answer
Remove binlog mysql
SQL
0 vote282 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote254 views1 answer
Mysql select row with max value group by
SQL
1 vote250 views1 answer
Update from select join
SQL
53 votes439 views6 answers
Sql server alter column
SQL