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

21 votes163 views6 answers
Update sql
SQL
0 vote134 views1 answer
Mysql in clausule string array
SQL
0 vote139 views1 answer
Databricks install odbc driver connect to sql server
SQL
-1 vote142 views2 answers
Create temporary table sql
SQL
0 vote150 views2 answers
Sql stored procedure for access frontend
SQL
0 vote127 views1 answer
Timestamp(0) postgresql
SQL
5 votes156 views2 answers
Mysql where in array
SQL
0 vote161 views2 answers
Clauses in mysql
SQL
0 vote131 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote102 views1 answer
Sqlalchemy existing database
SQL