Copying Snowflake table to Oracle DB in AWS with Airbyte

Summary

When using Airbyte to copy a table from Snowflake to Oracle DB in AWS, the Full refresh + Overwrite option drops and re-creates the table in the target, impacting grants. Is there a way to truncate the table or delete data in Oracle without dropping & re-creating the table?


Question

Hello team, I am trying to copy a table from Snowflake to Oracle DB in AWS using Airbyte. My requirement is to truncate the table in Oracle and refresh the data but the Full refresh + Overwrite option in Airbyte is dropping the table in the target (Oracle DB) and re-creating it followed by the data refresh. Is there a way to truncate the table or just delete the data in Oracle instead of dropping & re-creating the table. This is causing an impact on the grants as everytime the table is dropped the grants also gets removed from the target table



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.

Join the conversation on Slack

["snowflake", "oracle-db", "aws", "airbyte", "full-refresh", "overwrite", "truncate", "grants"]