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 vote226 views1 answer
Sqlcmd no headers
SQL
1 vote223 views1 answer
Oracle grant on all tables in schema
SQL
0 vote223 views2 answers
Sql 2 way of select unique
SQL
12 votes226 views4 answers
Import mysql database command line linux
SQL
0 vote249 views1 answer
Mariadb cast to int
SQL
4 votes245 views2 answers
Dbms output
SQL
0 vote215 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote237 views1 answer
SELECT statement to find the specific cell in database table
SQL
3 votes241 views2 answers
See mysql users ubuntu
SQL
0 vote185 views1 answer
How to see the content of tables in pgadmin
SQL