Error: You Must Specify AUTO_RESUME = TRUE

Issue

Destination setup tests fail. The following error appears:

Default Warehouse Test: You must specify AUTO_RESUME = TRUE

Environment

Destination: Snowflake

Resolution

To resolve this issue, set the AUTO_RESUME parameter to TRUE in your Snowflake warehouse, then re-run the setup tests in Fivetran. For more information on configuring your warehouse parameters, see our Snowflake warehouse script documentation.

To learn more about the AUTO_RESUME parameter, see Snowflake's ALTER WAREHOUSE documentation.

Cause

This issue occurs when your Snowflake warehouse is suspended and the AUTO_RESUME parameter is not enabled. When this happens, we can't automatically resume the warehouse to run setup tests or sync queries, causing the setup test to fail.