The Dream Team: Synapse Analytics Serverless SQL Pools and Pipelines

Synapse Analytics is Microsoft's flagship limitless data analytics service. In this session we'll look at how Serverless SQL Pools and Pipelines are the ultimate dream team, working together to ingest, transform, and serve data stored in Azure Data Lake Gen2.

Within Synapse Analytics, Serverless SQL Pools allows the reading and writing of data stored externally in Azure Storage, Data Lake, Cosmos DB, and the Dataverse. Pipelines allow the transformation of data between data services at scale including Azure Storage and Data Lake.

1. Discuss the architecture of Synapse Analytics with Serverless SQL Pools, Pipelines, and Data Lake Gen2
2. Use Synapse Analytics Pipelines to transform raw CSV data into enriched Parquet data in the Data Lake
3. Connect Synapse Analytics Serverless SQL Pools to the enriched Parquet data for analysis

After this session you'll have an understanding of the benefits that Synapse Analytics Serverless SQL Pools and Pipelines have when working with data stored in Azure Data Lake Gen2

Feedback Link -

Starts: 13:40 10th Mar 2022
Ends: 14:00 10th Mar 2022


Short Description
- Synapse Analytics Serverless SQL Pools and Pipelines are the dream team when it comes to managing big data in Azure Data Lake, this session will take you through the process!

Slidedeck Link

SQLBits The Dream Team Synapse Analytics Serverless SQL Pols and Pipelines - Andy Cutler.pdf


Andy Cutler


AzureIntelligence and AnalyticsManaging Big DataDevelopingBig Data AnalyticsData LakeSynapse AnalyticsIntermediate

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.