Allow Airbyte to write to a Snowflake Schema without database ownership

[autronix]

Tell us about the problem you're trying to solve

Trying to set the destination to a custom schema in an existing table in order to keep data lake data within the same database.

Currently, Airbyte doesn't seem to allow doing that with Snowflake, even though permissions allow the user and role full ownership of a given schema.

We're currently getting the following error: Could not connect with provided configuration. SQL access control error: Insufficient privileges to operate on database 'DATABASE'

Describe the solution you’d like

I would like to be able to use an existing database without having to grant ownership to the Airbyte role, and only allow Airbyte to operate within the context of the Schema/Table instead of the database scope.

Describe the alternative you’ve considered or used

• Fivetran
• Direct ETL development

Additional context

Here are screenshots about role permissions to import data from a MariaDB database to Snowflake: