Can I Assign Different Snowflake Warehouses to Individual Connections?

Question

Can I assign different Snowflake virtual warehouses to connections that share the same Snowflake destination?

Environment

Destination: Snowflake

Answer

Yes, you can assign different Snowflake virtual warehouses to individual connections that share the same Snowflake destination by overriding the destination's default warehouse for each connection.

To assign a warehouse to a connection:

1. In Fivetran, go to your connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. In the Snowflake Destination Virtual Warehouse drop-down menu, select the warehouse you want that connector to use.
5. Click Save & Test.

If you don't see the Snowflake Destination Virtual Warehouse drop-down menu, contact our support team for help enabling this feature.

For more information, see the Snowflake destination setup guide.