Error: No Active Warehouse Selected in the Current Session
Issue
In Fivetran, the following error appears:
No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
Environment
Connector: Snowflake
Resolution
To resolve this issue, do the following:
- Log in to the Snowflake account that contains the target warehouse.
- Verify that the warehouse is active by running the following command:Find the applicable warehouse and confirm that the
SHOW WAREHOUSES;STATEisRUNNING. - Confirm the Fivetran user's default warehouse by running:Check the warehouse listed in the
show users like '<fivetran_user>';DEFAULT_WAREHOUSEcolumn. - If the default warehouse is incorrect or the case doesn’t match, set the correct default warehouse by running the following commands:
USE ROLE SECURITYADMIN; ALTER USER <fivetran_user> SET DEFAULT_WAREHOUSE = <UPPERCASE_WAREHOUSE_NAME>;Snowflake stores unquoted names in uppercase. Ensure the warehouse name matches this case.
Cause
This issue occurs when the default warehouse is suspended, misconfigured, or its name doesn't match the Snowflake case conventions.