Azure Synapse Analytics - Automating Serverless SQL Views

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/azure/synapse-analytics/sql/develop-stored-procedures

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!