Snowflake Destination in Airbyte fails with error "No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command." How to resolve this error ?

This error usually occurs when the Snowflake warehouse is not properly configured in Airbyte. Here are some tips to resolve this issue: 1. Make sure you have granted the Snowflake role you use in Airbyte the necessary permissions for the warehouse. For example, if you are using the role

PRODUCTION_HM_AIRBYTE_DB_OWNER_ROLE

, it should have permission for the warehouse

PRODUCTION_HM_AIRBYTE_WH

. 2. Ensure that the warehouse name in your settings is correct and there are no typos. In this case, it should be

PRODUCTION_HM_AIRBYTE_WH

. 3. It might be helpful to set the Snowflake user's default warehouse and default role. For instance, if your user is

PRODUCTION_HM_AIRBYTE_DB_OWNER_USER

, the default warehouse could be

PRODUCTION_HM_AIRBYTE_WH

and the default role could be

PRODUCTION_HM_AIRBYTE_DB_OWNER_ROLE

. If the error persists, it might be due to a misleading error message. In such cases, it would be helpful if the error message could specify whether the role does not have the necessary permissions or if the warehouse does not exist. This issue has been raised in the Airbyte GitHub repository for further investigation ([source](https://github.com/airbytehq/airbyte/issues/40615)). Please note that these instructions are based on a specific example and the exact names of your roles, users, and warehouses may vary.