© 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_7

7. Create and Load Synapse Analytics Dedicated SQL Pool Tables Dynamically

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

In Chapter 6, you learned how to load data lake files into a Synapse Analytics dedicated SQL pool using Data Factory by using the COPY INTO command as one such load option. Now that you have designed and developed a dynamic process to auto-create and load the ETL schema tables into a Synapse Analytics dedicated SQL pool with snappy compressed parquet files, let’s explore options for creating and loading tables into a curated schema, where you ...

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