Default Virtual Warehouse Is Temporarily Grayed Out for an Existing Snowflake Destination

Issue

When editing an existing Snowflake destination, the Default Virtual Warehouse field is grayed out and can't be changed.

Environment

Destination: Snowflake

Resolution

To make the Default Virtual Warehouse field available:

1. In Fivetran, go to your Snowflake destination page.
2. In the top right, click the more options menu and select Edit connection.
3. Click Save & Test or Test Connection.
4. After the connection test completes successfully, select the required warehouse from the Default Virtual Warehouse drop-down menu.
5. Click Save & Test again.

Alternatively, configure the Snowflake user's default warehouse directly in Snowflake:

1. Run the following command:

   ALTER USER <username> SET DEFAULT_WAREHOUSE = <warehouse_name>;
   

2. Ensure that the Snowflake user or role has the required USAGE privilege on the warehouse.
3. Return to the Snowflake destination in Fivetran and select Test Connection.

Cause

Fivetran retrieves the available Snowflake virtual warehouses only after successfully testing the connection. Until the connection test completes successfully, the Default Virtual Warehouse field may remain grayed out and unavailable for editing.