Warehouse Suspended

Error Code 3001
Applies To Snowflake Destination
Error Message Text(s) Hevo is unable to create tables in your Snowflake Destination, as your warehouse {warehouse name} is suspended. Please validate that your Snowflake account is active. Hevo will retry after some time.

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.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jun-21-2022 1.91 New document.
Last updated on 21 Jun 2022