# Azure Synapse Analytics

> An older Azure cloud tool. It puts SQL, Spark and pipelines in one place.

**Field:** Data Engineering  
**Category:** Platforms  
**Also known as:** Azure Synapse, Synapse Analytics, Azure SQL Data Warehouse, Synapse Dedicated SQL Pool

## Think of it like

It is like a big toolbox from one shop. It holds a SQL tool, a Spark tool and a pipe tool.

## Definition

Azure Synapse is an older Azure service that puts a SQL warehouse, Spark and data pipelines in one place. Its SQL comes in two kinds. A dedicated pool has fixed power. A serverless one is ready for odd queries. Its pipelines run on the same engine as Azure Data Factory. For a new warehouse, the Azure docs now point to Fabric.

## Example

A shop runs its nightly loads in a Synapse dedicated SQL pool. It now plans to move them to a Fabric warehouse with Microsoft's own tool.

## Why it matters

Many Azure firms built their warehouse on it. Data jobs still ask for it, and moving off it is common work.

## Common mistake

Leaving a dedicated pool on all weekend with no queries. It bills for compute while it runs. Pause it, and you pay for storage only.

## Three principles

- **SQL and Spark.** Both work on the same lake files.
- **Dedicated or serverless.** Set power, or always ready.
- **Fabric is next.** New warehouses start in Fabric.

## Related terms

- [Data Platform](https://learn.benibix.com/term/data/data-platform)
- [Microsoft Fabric](https://learn.benibix.com/term/data/microsoft-fabric)
- [Fabric Data Warehouse](https://learn.benibix.com/term/data/fabric-data-warehouse)
- [Azure Data Factory (ADF)](https://learn.benibix.com/term/data/azure-data-factory)
- [Apache Spark](https://learn.benibix.com/term/data/apache-spark)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Microsoft Azure](https://learn.benibix.com/term/infrastructure/microsoft-azure)

## Told apart from

- [Microsoft Fabric vs Azure Synapse Analytics](https://learn.benibix.com/compare/microsoft-fabric-vs-azure-synapse-analytics): People think Microsoft Fabric is Azure Synapse with a new name, and it is not. Synapse is an Azure service where you set up SQL and Spark pools one by one. Fabric is sold as one product. Every tool keeps its data in one shared lake and draws on one capacity. For a new warehouse, Microsoft now points people to Fabric.

![Two boxes side by side. On the left, Azure Synapse Analytics holds SQL pools, Spark pools and pipelines, all inside one Azure cloud. On the right, Cloudera runs the same platform in a company data centre and in two public clouds, with one band of shared access rules across all three.](https://learn.benibix.com/diagrams/dat3-cloud-vs-hybrid.svg)

---

Source: https://learn.benibix.com/term/data/azure-synapse-analytics
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
