Serverless data prep using SQL on demand and Synapse Pipelines
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.