Summary
User seeks a method to truncate an Oracle DB table instead of dropping and recreating it during data refresh from Snowflake using Airbyte, due to issues with grants being removed.
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.