Warehouse Suspended

Potential Causes

• The warehouse is in suspended state.

• Billing details have not been added to the Snowflake account.

Suggested Action(s)

To resolve this error, do the following:

• Verify that the warehouse is not suspended. To do this:

  1. Log in to the Snowflake instance.

  2. Click the Expand chevron (drop-down icon) at the top left.

  3. From the Switch Roles list, select the role which you want to use.

     

  4. In the left navigation pane, click Worksheets, and then click + Worksheet.

  5. Follow the steps below to verify, and change the state of your warehouse if required:

     1. Run the following command to get a list of your warehouses, and check the value of the state column of your warehouse.
        SHOW warehouses;

        

     2. If the warehouse is suspended, run the following command to resume the warehouse.
        ALTER warehouse <Your Warehouse name> resume; ## replace with the name of your warehouse

        

     3. Run the command, SHOW warehouses; again to verify that the value of state column is STARTED.

        

• Verify that the billing details are added to the account. To do this:

  1. Log in to the Snowflake account, and switch to the ACCOUNTADMIN role.

     

  2. Click on Admin, and then click Billing.

  3. Verify that a valid credit card has been provided, otherwise, click + Credit Card.

     

  4. Provide the required information, and click Add Card.

     

  5. You can either wait for Hevo to run the Pipeline as per schedule, or click Run Now in the Pipeline Overview page to run the Pipeline now.

Revision History