Aug 20, 2022 12:00 AM

Azure Synapse Analytics: Serverless Pools [Introduction to Azure Synapse Analytics Series - Ep. 5]

External YouTube Channel

In this episode Mitchell introduces the concept of SQL Pools, talks about the differences with Dedicated and Serverless pools and then performs a demo leveraging the Serverless SQL On-Demand functionality in Azure Synapse Analytics.

Serverless SQL pool in Azure Synapse Analytics

Every Azure Synapse Analytics workspace comes with serverless SQL pool endpoints that you can use to query data in the Azure Data Lake (Parquet, Delta Lake, delimited text formats), Cosmos DB, or Dataverse.

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/on-demand-workspace-overview

Quickstart: Use serverless SQL pool

Synapse serverless SQL pool is a serverless query service that enables you to run SQL queries on files placed in Azure Storage. In this quickstart, you'll learn how to query various types of files using serverless SQL pool. Supported formats are listed in OPENROWSET.

https://docs.microsoft.com/en-us/azure/synapse-analytics/quickstart-serverless-sql-pool