Troubleshooting Snowflake "No warehouse specified" error

Last updated: August 18, 2025

If you're encountering a "No warehouse specified" error when connecting to Snowflake, this could be an indicator of a few issues.

Setting a Default Warehouse in Snowflake

You may need to set a default warehouse for the user that's being used to connect to Explo. See our documentation here to learn more.

If you are still encountering this error, this error message may be masking underlying permission issues.

Missing Warehouse Usage Permissions

Even if your Snowflake user has a default warehouse configured, you may still see this error if the user's role doesn't have the proper permissions to use that warehouse.

To resolve this issue:

  1. Check that your Snowflake role has USAGE permissions granted for the warehouse

  2. Even though the warehouse may be set as the "default" warehouse for your user, the role still needs explicit usage permissions

  3. Grant the necessary permissions using a command like:

    GRANT USAGE ON WAREHOUSE your_warehouse_name TO ROLE your_role_name;

Additional Troubleshooting Steps

If you're still experiencing issues after checking warehouse permissions:

  • Verify that your Snowflake user can access the required tables and schemas

  • Check the Snowflake connection documentation for additional configuration requirements

  • Test your connection directly in Snowflake to ensure all permissions are properly configured

If you continue to experience issues after verifying these permissions, please contact support for further assistance.