Massively parallel warehouse in Synapse, previously named SQL Data Warehouse, which spreads data across 60 distributions and runs no more than 128 queries at once.
Also called formerly SQL Data Warehouse, SQL Data Warehouse.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Dedicated SQL pool in context, with comparison tables and the common traps.
Terms in this definition
- Warehouse
Fabric item offering complete T-SQL support (DML, DDL, multi-table transactions) over Delta tables held in OneLake; lakehouse SQL analytics endpoints, by contrast, are read-only.
- Agents (classic) API
First-generation Foundry Agent Service API, based on threads, messages and runs. It is deprecated, replaced by conversations and responses, and retires on 31 March 2027.
Related terms
- COPY statement
The quickest and recommended method of loading a Synapse dedicated SQL pool; it doesn't need external tables or file formats.
- MPP
Massively parallel processing, in which a query is split across numerous compute nodes; the Synapse dedicated SQL pool is built this way.