Azure Synapse Serverless SQL Pool – Building Logical Data Warehouses by Ferenc Csonika

A logical data warehouse enables access to multiple, diverse data sources, allows querying data from these data sources using SQL language, while displays itself as one logical data source for users. The recently released Azure Synapse Analytics brings together database, data warehouse, and data lake technologies in a single Azure service.

One of its key components is Azure Synapse Serverless SQL Pool (a.k.a. Azure Synapse On-Demand SQL Pool), which provides T-SQL queries over high-scale data in various formats (CSV, Parquet, JSON) stored in Azure Data Lake Storage Gen2. Furthermore, these T-SQL queries could get data not just from data lakes, but also from different kinds of databases (e.g. Azure Cosmos DB, Azure SQL, Synapse Dedicated SQL Pool).

Thus Azure Synapse Serverless SQL Pool ensures building logical data warehouses in a serverless manner, i.e. without implementing infrastructural details and dedicated data pipelines, while the users have to pay only for query execution costs.

In this session, we will present how to build logical data warehouses in a Serverless SQL Pool to combine diverse data coming from Azure Data Lake Storage Gen2, Azure Cosmos DB, and other databases and how to use these logical data warehouses for ad-hoc reporting, proof-of-concepts, and BI sandboxes.

Speaker’s Profile: Ferenc Csonika

• Follow us on Twitter & LinkedIn to stay updated on the latest live shows and conferences.

👉 Organiser of Cloud Summit 2021

C# Corner, headquartered in Philadelphia, PA, is an online global community of 3 million software developers. C# Corner serves 5+ million visitors with 9 million page views each month. We publish the latest news and articles on cutting-edge software development topics. Developers share their knowledge and connect via content, forums, and chapters. Thousands of members benefit from our monthly events, webinars, and conferences. We also provide tools for career growth such as career advice, resume writing, training, certifications, books and whitepapers, and videos.

🔗 Join C# Corner today for free

👉 Title Sponsor – Stratis Platform

Stratis is a company which operates worldwide. Our strong, distributed team of blockchain developers, consultants, and marketing experts combines a solid corporate structure, for best business practices, with the flexibility required for rapid prototyping and deployment. Stratis is headquartered in the U.K. and incorporated as Stratis Group Ltd.

Other Sponsors

Applied Information Sciences (AIS)

Rundeck by PagerDuty


NiCE IT Management Solutions


O3H Consulting

Data Works







MCN Solutions