Azure SQL Data Warehouse Documentation

Overview

Azure SQL Data Warehouse (now part of Azure Synapse Analytics) is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It provides a massively parallel processing (MPP) architecture that enables high‑performance queries across petabytes of data.

Key Features

Scalable compute and storage that can be independently resized
Seamless integration with Azure Data Factory, Power BI, and Azure Machine Learning
Built‑in security with encryption at rest and in transit
PolyBase for querying external data sources such as Azure Blob Storage

Quick Start

Deploy a SQL Data Warehouse in a few clicks and start loading data.

az synapse workspace create \
  --name MyWorkspace \
  --resource-group MyResourceGroup \
  --location eastus \
  --sql-admin-login-user adminuser \
  --sql-admin-login-password MyP@ssw0rd

az synapse sql pool create \
  --name MyWarehouse \
  --workspace-name MyWorkspace \
  --performance-level DW1000c

Sample Query

SELECT TOP 10
    CustomerID,
    SUM(SalesAmount) AS TotalSales
FROM   dbo.FactSales
WHERE  SalesDate >= '2024-01-01'
GROUP BY CustomerID
ORDER BY TotalSales DESC;