Predictive Hacks

How to Rename Columns in Snowflake

We can easily rename columns in Snowflake using the alter table ... raname column command. For example:

alter table  "DB_NAME"."SCHEMA_NAME"."TABLE_NAME" rename column old_column_name to new_column_name

Bear in mind that we can rename a single column per command. Thus, if we want to rename three columns, we have to run:

alter table my_table rename column col_old_1 to col_new_1 ;
alter table my_table rename column col_old_2 to col_new_2 ;
alter table my_table rename column col_old_3 to col_new_3 ;

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Python

Image Captioning with HuggingFace

Image captioning with AI is a fascinating application of artificial intelligence (AI) that involves generating textual descriptions for images automatically.