How to Rename a Snowflake Database
Question
How do I rename the destination database within my Snowflake warehouse and change its username?
Environment
Destination: Snowflake
Answer
- In your Fivetran dashboard, pause all connectors that sync to the destination database that you want to rename.
- In Snowflake, rename the database.
- Create a new user/role and grant permissions to the renamed database.
- Disable the old user/role.
- In Fivetran, update the destination setup page with the new database name, username, and password.
- Unpause your connectors.