MEAPSA

Use Azure Synapse serverless SQL pool to query files in a data lake

With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database.

Data Engineer

Synapse Analytics

Module Objectives

After the completion of this module, you will be able to:

Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
Query CSV, JSON, and Parquet files using a serverless SQL pool
Create external database objects in a serverless SQL pool

Units

Introduction min
Understand Azure Synapse serverless SQL pool capabilities and use cases min
Query files using a serverless SQL pool min
Create external database objects min
Exercise - Query files using a serverless SQL pool min
Knowledge check min
Summary min

Prerequisites

Consider completing the Explore data analytics in Azure and Get started querying with Transact-SQL learning paths before starting this module. You will need knowledge of:

Analytical data workloads in Microsoft Azure
Querying data with Transact-SQL