Summary
When trying to copy test data into the Snowflake Stage in Airbyte, encountering error ‘No active warehouse selected’. Default warehouse name is defined in connection parameters and JDBC URL.
Question
Hello Team
I’m trying to configure Snowflake Destination in Airbyte. I’m using the latest Snowflake destination version 3.11.3.
I can see that the connection is created successfully and Airbyte is able to create the tables and Stages in Airbyte Internal schema.
However, while trying to copy test data into Stage, it fails with error “No active warehouse selected in the current session. Select an active warehouse with the ‘use warehouse’ command.”
I’ve defined the default warehouse name in the Connection parameters and also in JDBC URL. But still it is faiing at this step.
Any ideas how to resolve this error ?
Thanks.
<#C021JANJ6TY|ask-community-for-troubleshooting>
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.