Monster Data Loading with Synapse

So we need to load data at scale into Synapse SQL Pools. What should we be thinking about.
There are a few options for loading : COPY and Polybase does it matter which one to use. What difference does the file format make Parquet or Delta or CSV ? What above performance ? How quickly can we load a TB of data? 2TB? what about 10TB? Or more????
So lets see how much data we can load in 20 minutes...

Feedback link:

Starts: 11:20 12th Mar 2022
Ends: 12:10 12th Mar 2022


Short Description
- Get to grips with data loading in Synapse.


Mark Pryce-Maher


AzureIntelligence and AnalyticsOptimisingSynapse AnalyticsIntermediateHow

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.