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

How to Rename a Table in Snowflake in Snowflake

Renaming a table in Snowflake is performed by using ALTER TABLE .. RENAME TO statement:

--the syntax
alter table old_table_name rename to new_table_name;

--rename users_marketing to users table
alter table sessions_db1 rename to sessions_db_1;

Ready for a modern SQL editor?