Troubleshooting Snowflake "No Active Warehouse Selected" Error

Last updated: September 8, 2025

If you're experiencing connection issues between Explo and Snowflake despite allowing all IP addresses, the problem may be related to your Snowflake service user's warehouse configuration.

Common Cause

Connection failures often occur when the Snowflake service user that Explo uses doesn't have a default warehouse properly configured or lacks the necessary permissions on that warehouse.

Resolution Steps

To resolve this issue, please complete the following steps:

  1. Verify Default Warehouse Assignment: Confirm that the service user Explo connects with has a default warehouse assigned in Snowflake.

  2. Check Role Permissions: Ensure that the assigned role has both USAGE and OPERATE permissions on the warehouse.

  3. Test Warehouse Binding: Log into Snowflake as the Explo service user and run the following query:

    SELECT CURRENT_WAREHOUSE();

    If this query returns NULL, it means the user does not have a warehouse bound to their account.

Additional Resources

For detailed instructions on configuring default warehouses in Snowflake, refer to Snowflake's documentation on setting default warehouses.

Once you've completed these configuration steps, try reconnecting Explo to your Snowflake instance.