Query data in the lake using Azure Synapse serverless SQL pools

Beginner
Data Engineer
Synapse Analytics

Learn how you can query the different file types that can be stored in a data lake.

Learning objectives

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

  • Query a CSV file using Azure Synapse serverless SQL pools
  • Query a Parquet file using Azure Synapse serverless SQL pools
  • Query a JSON file using Azure Synapse serverless SQL pools
  • Query multiple files and folders using Azure Synapse serverless SQL pools
  • Understand storage considerations when using Azure Synapse serverless SQL pools

Prerequisites

  • It is recommended that students have completed Data Fundamentals before starting this learning path.