Error: Warehouse Is Suspended

Issue

The following error appears:

Unknown failure. Error: Warehouse <warehouse_name> is suspended.

Environment

Connector: Snowflake

Resolution

To resolve this issue, you must resume your warehouse in Snowflake. For more information, see Snowflake's documentation on resuming warehouses.

Alternatively, run the following SQL command using a Snowflake SQL editor or any command-line interface (CLI) connected to your Snowflake account. Replace warehouse_name with the name of your warehouse:

ALTER WAREHOUSE <warehouse_name> RESUME;

If the issue persists after resuming your warehouse, verify that the authenticating user has the necessary permissions to access and use the affected warehouse. To learn more, see our Snowflake Prerequisites. You can also consider increasing the size of the warehouse if it frequently becomes a bottleneck during large data loads.

Cause

This error occurs when the target Snowflake warehouse is suspended and we can't process queries.