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

Community

Connector Improvement: Views/MVs ingestion from Azure SQL DB, Oracle Cloud

Answered
NARSIMHA Mudiya User

Currently, we can't ingest Views or Materialized Views with from source database in Fivetran. Not sure if it is available on any connectors or not.  Because of this reason, currently we are using a secondary tool like ADF to ingest Views/MVs into the destination while keeping Fivetran as a primary service to ingest only tables. With this we have to maintain 2 pipelines, one for Fivetran and another service like ADF/other integration tool.

It would be great if you can add this feature to the connectors. 

Thanks,

Narsimha

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Rean Fivetranner

    Hi Narimha,

    Thanks for reaching out about replicating views from your source database in Fivetran

    Currently, our connectors replicates the underlying tables but does not replicate the view objects themselves. This is because changes to the data in the underlying tables make it hard to accurately track incremental updates to the view itself.

    To preserve equivalent logic in your destination, we recommend manually re-creating the views. You can refer to this guide for best practices on replicating views in your target environment.

    Let us know if you need help or have any additional questions.

    Best, 
    Rean

  • Priyank Doshi User

    @FivetranSupport is there any update on this one?