SQLBits Session – The Dream Team: Synapse Analytics Serverless SQL Pools and PipelinesJanuary 13, 2022
SQLBits is back this year and is running from Tuesday 8th to Sunday 12th March at the ExCel in London. Register for the event and see the schedule here. I’m speaking on the Thursday in Room 11 at 1:40PM to 2PM. I’ll be talking about Azure Synapse Serverless SQL Pools and Pipelines working together to enhance your Data Lake workloads. I will hopefully see you there. There are a huge variety of sessions available at SQLBits, it’s sure to be a fantastic event.
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.
- Discuss the architecture of Synapse Analytics with Serverless SQL Pools, Pipelines, and Data Lake Gen2
- Use Synapse Analytics Pipelines to transform raw CSV data into enriched Parquet data in the Data Lake
- 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