Error: Default Warehouse Test: You Must Specify the Correct Warehouse Name

Issue

The Snowflake destination setup tests fail with the following error:

Default Warehouse Test: You must specify the correct warehouse name which you created for Fivetran user in the script.

Environment

Destination: Snowflake

Resolution

To resolve this issue:

1. Identify the username and warehouse name used in the SQL script you ran while setting up your Snowflake destination. To review the script, see our Snowflake destination setup guide.
2. In Snowflake, execute the following command, replacing <user_name> and <warehouse_name> with the relevant values.

   ALTER USER '<user_name>' SET DEFAULT_WAREHOUSE = '<warehouse_name>';
   

3. In Fivetran, test the destination connection.

Cause

This issue occurs when the warehouse provided in the SQL script you ran while setting up your destination isn't set as the user's default warehouse. You can verify this by doing the following:

1. Run the following command, replacing <user_name> with the relevant value:

   DESC USER '<user_name>';
   

2. In the results, locate the DEFAULT_WAREHOUSE property and check the value in the default column.