Question
When configuring a Snowflake destination, the following error appears:
Default Warehouse Test: You must specify the correct warehouse name which you created
for fivetran user in the script (check if it's in uppercase)
Environment
Destination: Snowflake
Answer
Please run the following queries in your Snowflake warehouse:
DESC USER "FIVETRAN_USER"
SHOW WAREHOUSES
Make sure that the Fivetran user's default_warehouse reflects the warehouse_name as defined in the script that is executed from the Snowflake setup guide.
Cause
This error is referencing the script we provide for you to run within Snowflake to set up the Fivetran user. For more information, please visit our Documentation.