Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Oracle adding partitions does not cause a resync

Francis Tremain User

Fivetran currently triggers a resync when a ddl statement is executed, but creating partitions should not trigger a resync as it is unnecessary and creates issues in downstream processes.

The connector should be smart enough to see that it is an addition of a partition and not worry about triggering a resync.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Francis,

    Thanks for your question in this portal! I agree that partitioning an existing table should not cause a re-sync, as there should be no impact to the data downstream. There may be some metadata that changes within Oracle that causes this to be required, however, let me double check this with our engineering team.

    In the meantime, could you help share what is your specific DDL statement you are using to partition your Oracle table, and could you help describe what the desired outcome would look like in your destination?

    Thanks for your feedback and I will be sure to discuss this with engineering internally!