Azure Synapse Analytics Workspace Source Control with SQL Pools Databases

preview_player
Показать описание
In this video I'll be showing you how to integrate an Azure Synapse Analytics workspace into Azure DevOps source control, and then use Azure Data Studio to create a database project from a Serverless SQL Pools database. This database can then be added to the same DevOps repo that the Synapse workspace is connected to. This then allows branching/merging across both the workspace and the database project.

License code: MIXSZEEOIZLTHSPR
Рекомендации по теме
Комментарии
Автор

Great video thanks!
There are still some bugs with serverless sql pools though..
Also, how will it go during deployment of external tables ? It requires a valid path on the data lake to create the external table. So if it's a new external table not yet available on the target environment, the deploy will fail.

Sunabe
Автор

Will this work when we have views dependent on views in other databases? In our setup we have logical data warehouse, dims and facts view depend on views in other database that have views over delta lake files.

BaijuThakkar