Skip to content
BENIBIX Learn

Azure Synapse Analytics

Data🧰 PlatformsData Platforms

Also known as Azure Synapse, Synapse Analytics, Azure SQL Data Warehouse, Synapse Dedicated SQL Pool

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

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.

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.

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.
Synapse is the box on the left. Its SQL, Spark and pipelines all live in Azure.

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.

Key takeaways

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

Compare