Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

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;

Ready for a modern SQL editor?