How to Rename a Column in Snowflake in Snowflake

Renaming a column in Snowflake involves using the ALTER TABLE .. RENAME COLUMN command.

-- syntax
alter table table_name rename column old_name to new_name;

-- rename product_category column in products table
alter table products rename column products_category to products;

Better SQL for the people

Get more done with PopSQL and Snowflake