Share
Warehouse Suspended

Error

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.

      Select a Role

    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;

        Get a list of 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

        Alter warehouse

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

        Check column state

  • 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.

      ACCOUNTADMIN Role

    2. Click on Admin, and then click Billing.

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

      Verify billing details

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

      Add credit 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.

Last updated on Oct 26, 2022

Tell us what went wrong

Skip to the section