Skip to main content

Community

Connector Improvement: SQL Connector and Views

Answered

Please sign in to leave a comment.

Comments

1 comment

  • Official comment

    Hi Hermod,

    Thanks for reaching out about replicating views from SQL Server to Snowflake.

    Currently, the SQL Server connector 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