🧰Azure Synapse Analytics
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
Common mistake
Key takeaways
- 1SQL and Spark. Both work on the same lake files.
- 2Dedicated or serverless. Set power, or always ready.
- 3Fabric is next. New warehouses start in Fabric.