Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Is there a way to change how the tables are created in Snowflake? I have a role that is only allowed access to a few tables in my schema and I’m using Full Refresh | Overwrite. I suspect it’s using `CREATE OR REPLACE` because every time the data syncs I have to re-grant the `SELECT ON TABLE` . Is there a way to change this or update the create to add `COPY GRANTS`

Kyle, sorry it took me some time to get back to you.

Yes we are creating the tables - <https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/destination-snowflake/src/main/java/io/airbyte/integrations/destination/snowflake/SnowflakeSqlOperations.java#L45|https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/d[…]/integrations/destination/snowflake/SnowflakeSqlOperations.java>

So the issue here is the the Airbyte user creating the table in Snowflake is different from the user reading the created table and thus you have to re-grant the user each time?

Hey Davin, yup i'm using `FULL REFRESH | OVERWRITE`! And exactly, it's creating the table so I have to re-grant select access for the downstream users