I want to fix up some naming in our destination warehouse (Snowflake). In particular, I want to rename the destination database within the warehouse and change the username being used.
Is there anything special I need to know so that I don't unintentionally start resyncing all of my data?
Please follow the steps below:
- Pause connectors.
- Rename the database in Snowflake.
- Create a new user/role in Snowflake and grant permissions to the renamed DB (and disable the old user).
- Update the Fivetran destination setup page with the new destination database name and credentials.
- Unpause connectors.
Changing the name of your snowflake database and then reconnecting the destination in the setup form in the dashboard will not be a problem.