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:

1. Log in to the Snowflake account that contains the target warehouse.
2. Verify that the warehouse is active by running the following command:

   SHOW WAREHOUSES;
   

   Find the applicable warehouse and confirm that the STATE is RUNNING.
3. Confirm the Fivetran user's default warehouse by running:

   show users like '<fivetran_user>;
   

   Check the warehouse listed in the DEFAULT_WAREHOUSE column.
4. If the default warehouse is incorrect, set it by running:

   USE ROLE SECURITYADMIN;
   ALTER USER <fivetran_user> SET DEFAULT_WAREHOUSE = <warehouse_name>;
   

Cause

This issue occurs when the default warehouse is suspended or configured incorrectly.