Working with serverless SQL pool

Azure Synapse Analytics has serverless SQL pool endpoints that are primarily used to query data in Azure Data Lake (Parquet, Delta Lake, delimited text formats), Azure Cosmos DB, and Dataverse.

We can access the data using T-SQL queries without the need to copy and load data in a SQL store through serverless SQL pool. Serverless SQL pool is ideally a wrapper service for interactive querying and distributed data processing for large-scale analysis of big data systems. It is a completely serverless and managed service offering from Microsoft Azure, built with fault tolerance, high reliability, and high performance for larger datasets.

Serverless SQL pool is suitable for the following scenarios:

• Basic exploration and discovery where data in Azure Data Lake Storage (ADLS)with different formats such as Parquet, CSV, Delta, and JSON can be used to derive insights.
• A relational abstraction layer on top of raw data without transformation,...