What is a DWU in Azure Synapse?

A Data Warehouse Unit (DWU) is a bundled measure of compute performance for Synapse Dedicated SQL pools. Higher DWU levels increase query parallelism and performance. You are billed per DWU-hour, and you can pause the pool when not in use to stop compute charges while retaining your data.

How does Synapse Serverless SQL pricing work?

Synapse Serverless SQL charges per TB of data processed by your queries. There are no provisioned resources to manage. This pay-per-query model is excellent for ad-hoc exploration of data lake files but can become expensive for large recurring queries, which is when a Dedicated SQL pool may be more economical.

Azure Synapse Analytics Cost Estimator

StorageAzure

Estimate Azure Synapse costs for Dedicated SQL pools, Serverless SQL, Spark pools, and Data Integration pipelines.

Example Presets

Dedicated SQL Pool

Enable Dedicated SQL Pool

Provisioned data warehouse with reserved compute (DWU)

Serverless SQL Pool

Data Processed (TB/month)

Pay-per-query model at $5.00/TB processed. No charge when idle.

Apache Spark Pools

Enable Spark Pool

Big data processing, ML, and data engineering workloads

Data Integration

Pipeline Activity Runs/month

$1.00/1,000 runs + $1.00/1,000 orchestration

Data Movement (DIU-hours)

$0.25/DIU-hour

Data Flow (vCore-hours)

Data Flow Type

Azure Synapse Analytics Overview

Synapse Components

Azure Synapse Analytics is a unified analytics platform that brings together enterprise data warehousing (Dedicated SQL Pools), big data analytics (Spark Pools), serverless data exploration (Serverless SQL), and data integration pipelines into a single workspace.

Dedicated vs Serverless SQL

Dedicated SQL Pools provide provisioned compute capacity (DWU) for predictable, high-performance queries on large datasets. Serverless SQL is pay-per-query with no infrastructure to manage, ideal for ad-hoc exploration and infrequent queries. Use dedicated pools for production workloads and serverless for exploration.

When to Use Spark Pools

Spark Pools are best for big data processing, data engineering (ETL), machine learning model training, and complex transformations on large datasets. They support Python, Scala, SQL, R, and .NET. Auto-pause after idle time helps control costs.

Comparison with Standalone Services

Synapse replaces standalone Azure SQL Data Warehouse, HDInsight Spark, and Azure Data Factory with a unified platform. While individual services may be cheaper for single-purpose workloads, Synapse offers cost savings through shared metadata, unified security, and integrated pipelines.

Raw Output (JSON)

Output will appear here...

About This Tool

The Azure Synapse Analytics Cost Estimator models monthly costs across Synapse's major components: Dedicated SQL pools, Serverless SQL queries, Apache Spark pools, and Data Integration pipelines. For Dedicated SQL, specify your DWU level and operating hours. For Serverless, enter expected data volumes scanned per query. Spark pool costs are based on node size, count, and execution hours. Data Integration pricing covers pipeline activity runs and data movement. This holistic estimator helps data engineering teams understand the total cost of a Synapse workspace before committing to a particular architecture.

When to Use This Tool

•Estimating the total monthly cost of a Synapse workspace that uses Dedicated SQL for dashboards and Spark pools for ETL.
•Comparing Serverless SQL on-demand query costs versus a Dedicated SQL pool for ad-hoc data exploration.
•Modeling Spark pool costs for a nightly machine learning training pipeline with auto-pause enabled.
•Budgeting Data Integration pipeline costs for a data warehouse loading process with hundreds of daily activity runs.

Frequently Asked Questions

What is a DWU in Azure Synapse?: A Data Warehouse Unit (DWU) is a bundled measure of compute performance for Synapse Dedicated SQL pools. Higher DWU levels increase query parallelism and performance. You are billed per DWU-hour, and you can pause the pool when not in use to stop compute charges while retaining your data.
How does Synapse Serverless SQL pricing work?: Synapse Serverless SQL charges per TB of data processed by your queries. There are no provisioned resources to manage. This pay-per-query model is excellent for ad-hoc exploration of data lake files but can become expensive for large recurring queries, which is when a Dedicated SQL pool may be more economical.

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.