© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
R. C. L'EsteveThe Definitive Guide to Azure Data Engineeringhttps://doi.org/10.1007/978-1-4842-7182-7_5

5. Use COPY INTO to Load a Synapse Analytics Dedicated SQL Pool

Ron C. L’Esteve1  
(1)
Chicago, IL, USA
 

In Chapter 4, I showed you how to load snappy compressed parquet files into Data Lake Storage Gen2 from an on-premises SQL Server. This chapter will introduce you to the fundamental mechanisms and technologies that will be used to fully load the parquet files from ADLS Gen2 into a Synapse Analytics dedicated SQL pool table. Also, this chapter will take a closer look at the COPY INTO command that offers numerous benefits including eliminating multiple steps ...

Get The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial