Azure Synapse Pipelines (Azure Data Factory) can run SQL on demand jobs to achieve serverless data preparation for your data pipelines.
This video walks through the process of building a serverless data prep pipeline. It shows how to take advantage of the TDS endpoint of SQL on demand to leverage the built-in Synapse Pipelines copy activity. It also points out a couple of existing gotchas that may catch you out along the way.
You can also subscribe to our YouTube and Vimeo channels