Question

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?

Environment

Destination: Snowflake

Answer

Please follow the steps below:

1. Pause connectors.
2. Rename the database in Snowflake.
3. Create a new user/role in Snowflake and grant permissions to the renamed DB (and disable the old user).
4. Update the Fivetran destination setup page with the new destination database name and credentials.
5. Unpause connectors.

Cause

Changing the name of your snowflake database and then reconnecting the destination in the setup form in the dashboard will not be a problem.