Breaking News: Grepper is joining You.com. Read the official announcement!

change column type snowflake

Danny Mor answered on September 17, 2020 Popularity 9/10 Helpfulness 4/10

answer change column type snowflake

related snowflake alter column data type

change column type snowflake

Comment

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

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: Grepper

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Sep 17 2020

Danny Mor

0 Answers Avg Quality 2/10

Closely Related Answers

snowflake alter column data type

Comment

alter table t1 alter c4 set data type varchar(50)

Popularity 9/10 Helpfulness 7/10 Language sql

Source: docs.snowflake.com

Tags: sql alter-column alter-co

Link to this answer
Share Copy Link

Contributed on Feb 24 2021

Garo_Gorille

0 Answers Avg Quality 2/10

change column type snowflake

Contents

More Related Answers

change column type snowflake

Closely Related Answers

snowflake alter column data type

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.