Azure Synapse Analytics - Automating Serverless SQL Views
Автор: Advancing Analytics
Загружено: 2021-09-03
Просмотров: 12475
We're seeing a common pattern emerging of people creating views over openrowset queries so they can then query files in a lake directly from BI Tools like Power BI, using Synapse Serverless Pools - it's a great pattern but people are hand-cranking the view creation... and that's no good.
In this video Simon talks through how you would go about creating views programmatically, using Serverless SQL Stored Procs & Dynamic SQL to build up the functionality you need to automate this arduous task.
Details around Serverless Stored Procs can be found here: https://docs.microsoft.com/en-us/azur...
If you're getting started with Azure Synapse Analytics, check out advancinganalytics.co.uk/training to see how we can help you on your journey!
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
