How to Rename a Column 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;
Cta

SQL editing that just rocks

PopSQL and Snowflake, better together