Connector Improvement: SQL Connector and Views
AnsweredWe need a connector that can read the Views in a SQL server and convert to Snowflake views in the same job as loading of table.
Or extract the definition of the view in SQL and make it available for DBT to create the View in Snowflake.
-
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
Please sign in to leave a comment.
Comments
1 comment