Skip to content

Serverless data prep with SQL on Demand and Synapse

· 8 min watch
Jess Panni By Jess Panni Principal I

Explore building serverless data prep pipelines with Azure Synapse Pipelines. Learn to use TDS endpoints, copy activity, and avoid common pitfalls.

About this talk

Tutorial

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.

About the presenter

Jess Panni

Principal I

Jess Panni

Jess has over 25 years' experience helping companies succeed through the smart use of technology. He spent most of his career working for leading Microsoft partners across the UK and Australia and was Principal at endjin, working with clients to envision and execute disciplined innovation programmes.

Jess worked at endjin between 2015-2020.

Load ?

See our privacy statement for how we handle your data.

Manage cookie preferences

Third-party widgets you have consented to appear below. Revoking stops the widget right away and prevents it from loading on future visits — you'll be asked to consent again next time you click its button.