Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In this article, you'll learn how to ingest data from an Azure Data Lake Gen 2 storage account into a dedicated SQL pool in Azure Synapse Analytics.
In Azure Synapse Analytics, a linked service is where you define your connection information to other services. In this section, you'll add an Azure Synapse Analytics and Azure Data Lake Storage Gen2 linked service.
A pipeline contains the logical flow for an execution of a set of activities. In this section, you'll create a pipeline containing a copy activity that ingests data from ADLS Gen2 into a dedicated SQL pool.
Once you've finished configuring your pipeline, you can execute a debug run before you publish your artifacts to verify everything is correct.
In this step, you manually trigger the pipeline published in the previous step.
For more information on data integration for Azure Synapse Analytics, see the Ingesting data into Azure Data Lake Storage Gen2 article.
Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Use Azure Synapse serverless SQL pools to transform data in a data lake - Training
Use Azure Synapse serverless SQL pools to transform data in a data lake
Certification
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.
Documentation
Quickstart: to load data into dedicated SQL pool using the copy activity - Azure Synapse Analytics
Use the pipeline copy activity in Azure Synapse Analytics to load data into dedicated SQL pool.
Tutorial load data from Azure Data Lake Storage - Azure Synapse Analytics
Use the COPY statement to load data from Azure Data Lake Storage for dedicated SQL pools.
Access lake databases using serverless SQL pool - Azure Synapse Analytics
Learn how Azure Synapse Analytics provides a shared metadata model where creating a lake database in an Apache Spark pool makes it accessible from its serverless SQL pool engine.