Connector Improvement: Can we import Views from SQL server or Azure MySQL
AnsweredIs there any way to import views from SQL server or Azure MySQL? Can be considered as another object and imported using Fivetran connector.
-
Official comment
Hi Divyansh,
Thanks for reaching out about replicating views from SQL Server and Azure MySQL.
Currently, these connectors replicates the underlying tables but do 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 -
Also need this feature
Please sign in to leave a comment.
Comments
2 comments