Skip to main content
Azure

Azure Synapse Analytics pricing

Limitless analytics with unmatched time to insight

Azure Synapse Analytics is a unified analytics platform that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated options—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, transform, manage, and serve data for immediate BI and machine learning needs.

Explore pricing options

Apply filters to customise pricing options to your needs.

Prices are estimates only and are not intended as actual price quotes. Actual pricing may vary depending on the type of agreement entered with Microsoft, date of purchase, and the currency exchange rate. Prices are calculated based on US dollars and converted using London closing spot rates that are captured in the two business days prior to the last business day of the previous month end. If the two business days prior to the end of the month autumn on a bank holiday in major markets, the rate setting day is generally the day immediately preceding the two business days. This rate applies to all transactions during the forthcoming month. Sign in to the Azure pricing calculator to see pricing based on your current programme/offer with Microsoft. Contact an Azure sales specialist for more information on pricing or to request a price quote. See frequently asked questions about Azure pricing.

You can get up to 28% savings over pay-as-you-go prices when you pre-purchase Azure Synapse Analytics Commit Units (SCUs), to be used on any publicly available product under Azure Synapse except storage over the subsequent 12 months. Your Azure Synapse usage will draw from your pre-purchased SCUs at the individual product's retail price until they are exhausted, or until the end of the 12-month period.

The purchase tiers and discounts for pre-purchase plan Synapse Commit Units are shown below:

Tier Synapse Commit Units (SCUs) Discount % Price
1 5,000 6% $4700
2 10,000 8% $9200
3 24,000 11% $21360
4 60,000 16% $50400
5 150,000 22% $117000
6 360,000 28% $259200

Pricing for the hybrid data integration capabilities in Azure Synapse is calculated based on:

  • Data Pipelines activities and integration runtime hours
  • Data Flows cluster size and execution
  • Operation charges

Data pipelines are control flows of discrete steps referred to as activities. Data pipelines can be cloud-hosted or self-hosted. You pay for data pipeline orchestration by activity run and activity execution by integration runtime hours. The integration runtime, which is serverless in Azure and self-hosted in hybrid scenarios, provides the compute resources used to execute the activities in a pipeline. Execution is prorated by the minute and rounded up.

Data Pipelines

Type Azure Hosted Managed VNET Price Azure Hosted Price Self Hosted Price
Orchestration Activity Run $- per 1,000 runs $- per 1,000 runs $- per 1,000 runs
Data Movement $-/DIU-hour $-/DIU-hour $-/hour
Pipeline Activity Integration Runtime $-/hour
(Up to 50 concurrent pipeline activities)
$-/hour $-/hour
Pipeline Activity External Integration Runtime $-/hour
(Up to 800 concurrent external pipeline activities)
$-/hour $-/hour
Use of the copy activity to egress data out of an Azure datacentre will incur additional network bandwidth charges, which will show up as a separate outbound data transfer line item on your note. Learn more about outbound data transfer pricing.

Pipeline activities execute on integration runtime. Pipeline activities include Lookup, Get Metadata, Delete, and schema operations during authoring (test connection, browse folder list and table list, get schema, and preview data).

External pipeline activities are managed on integration runtime but execute on linked services. External activities include Databricks, stored procedure, HDInsight activities, and many more. Please refer here for a complete list of external activities. For Mapping Data Flow activity please refer to the “Data Factory Data Flow Execution and Debugging” section below.

Pricing for SQL Server Integration Services within Azure Synapse Analytics is the same as in Azure Data Factory. See pricing details.

Data Flows

Data Flows are visually-designed components that enable data transformations at scale. You pay for the Data Flow cluster execution and debugging time per vCore-hour. The minimum cluster size to run a Data Flow is 8 vCores. Execution and debugging charges are prorated by the minute and rounded up.

Type Price
Basic $- per vCore-hour
Standard $- per vCore-hour

Operation charges

Data Pipeline operations such as create, read, update, delete, and monitoring operations will be charged starting on February 1, 2021. Your first 1 million operations per month are free. After 1 million operations, you will be charged at $- per 50,000 operations.

Perform interactive, batch, streaming, and predictive analytics with a rich T-SQL experience. Users have the flexibility of choosing to use serverless and dedicated resources. This enables customers to use familiar SQL for data exploration across their data lake and run demanding and predictable workloads, such as data warehousing, all from the same service.

The pricing details for both serverless and dedicated consumption models can be found below.

Serverless

This functionality allows you use T-SQL to query data from your data lake in Azure rather than provision resources ahead of time. You only pay for executed queries and the pricing is based on the amount of data processed by each query. Metadata-only queries (DDL statements) do not incur a cost. Queries will incur a minimum charge of 10 MB and each query will be rounded up to the nearest 1 MB of data processed.

Price
Serverless $- per TB of data processed

This pricing is specific to querying data from your data lake. For storage pricing, see the Azure Data Lake Storage pricing page.

For more details, visit the cost management for serverless SQL pool documentation page.

Dedicated

Includes adaptive caching to deliver enhanced performance for workloads with consistent compute requirements, such as data warehousing. Designed for intensive workloads with higher query performance and compute scalability needs.

Service Level DWU Pay as you go 1 year reserved 3 year reserved
DW100c 100 $- $-
$-
DW200c 200 $- $-
$-
DW300c 300 $- $-
$-
DW400c 400 $- $-
$-
DW500c 500 $- $-
$-
DW1000c 1000 $- $-
$-
DW1500c 1500 $- $-
$-
DW2000c 2000 $- $-
$-
DW2500c 2500 $- $-
$-
DW3000c 3000 $- $-
$-
DW5000c 5000 $- $-
$-
DW6000c 6000 $- $-
$-
DW7500c 7500 $- $-
$-
DW10000c 10000 $- $-
$-
DW15000c 15000 $- $-
$-
DW30000c 30000 $- $-
$-

You can purchase reserved capacity for your Dedicated SQL pool resource created and managed from the new unified workspace experience. Save up to 65 percent compared to pay-as-you-go rates with reserved capacity pricing for your data warehousing workloads running on Azure.

Data storage and snapshots

Data storage is charged at the rate of $- per TB per month of data stored ($-/1 TB/hour). Data storage includes the size of your data warehouse and 7-days of incremental snapshot storage.

Note—Storage transactions are not billed. You only pay for stored data and not storage transactions.

Geo-redundant disaster recovery

Your data warehouse is copied to geo-redundant storage for disaster recovery. Disaster recovery storage is billed starting at $-/GB/month.

Threat detection

Azure Defender for SQL provides an additional layer of security intelligence built into the service. It works around the clock to learn, profile, and detect anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. Dedicated SQL pools in a Synapse workspace can seamlessly be protected with Azure Defender for SQL.

Azure Defender for SQL integrates alerts with Microsoft Defender for Cloud, and each protected SQL Database server will be billed at the same price as Azure Security Center Standard tier— $-/node/month, where each protected SQL Database server is counted as one node. We invite you to try it out for 60 days for free. Please see Microsoft Defender for Cloud pricing page for more details.

Perform big data processing tasks such as data engineering, data preparation, and machine learning directly in Azure Synapse using memory optimised or hardware-accelerated Apache Spark pools. Usage of Spark pools is billed by rounding up to the nearest minute.

Type Price
Memory Optimised $- per vCore-hour
GPU accelerated (public preview) $- per vCore-hour

For more information on using Apache Spark pools including guidance on when to use memory optimised versus hardware-accelerated pools in Azure Synapse, read the documentation.

Dedicated SQL pool (formerly SQL DW) provides a rich T-SQL experience for interactive, batch, streaming, and predictive analytics. It leverages a scale out architecture to distribute computational processing of data across multiple nodes. Compute is separate from storage, which enables you to scale compute independently of the data in your system.

The pricing details for implementing an enterprise data warehouse using the Dedicated SQL pool (formerly SQL DW) resource can be found below.

Includes adaptive caching to deliver enhanced performance for workloads with consistent compute requirements, such as data warehousing. Designed for intensive workloads with higher query performance and compute scalability needs.

Service Level DWU Pay as you go 1 year reserved 3 year reserved
DW100c 100 $- $-
$-
DW200c 200 $- $-
$-
DW300c 300 $- $-
$-
DW400c 400 $- $-
$-
DW500c 500 $- $-
$-
DW1000c 1000 $- $-
$-
DW1500c 1500 $- $-
$-
DW2000c 2000 $- $-
$-
DW2500c 2500 $- $-
$-
DW3000c 3000 $- $-
$-
DW5000c 5000 $- $-
$-
DW6000c 6000 $- $-
$-
DW7500c 7500 $- $-
$-
DW10000c 10000 $- $-
$-
DW15000c 15000 $- $-
$-
DW30000c 30000 $- $-
$-

You can purchase reserved capacity for your Dedicated SQL pool (formerly SQL DW) resource, which is generally available today.

Save up to 65 percent compared to pay-as-you-go rates with reserved capacity pricing for your data warehousing workloads running on Azure.

Data storage and snapshots

Data storage is charged at the rate of $- per TB per month of data stored ($-/1 TB/hour). Data storage includes the size of your data warehouse and 7-days of incremental snapshot storage.

Note—Storage transactions are not billed. You only pay for stored data and not storage transactions.

Geo-redundant disaster recovery

Your data warehouse is copied to geo-redundant storage for disaster recovery. Disaster recovery storage is billed starting at $-/GB/month.

Threat detection

Azure Defender for SQL provides an additional layer of security intelligence built into the service. It works around the clock to learn, profile, and detect anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases. Dedicated SQL pools in a Synapse workspace can seamlessly be protected with Azure Defender for SQL.

Azure Defender for SQL integrates alerts with Microsoft Defender for Cloud, and each protected SQL Database server will be billed at the same price as Azure Security Center Standard tier— $-/node/month, where each protected SQL Database server is counted as one node. We invite you to try it out for 60 days for free. Please see Microsoft Defender for Cloud pricing page for more details.

Azure Synapse data explorer enables customers to unlock insights from time series, log, and telemetry data using interactive queries. This powerful distributed query engine made available in every Synapse workspace provides best-in-class text indexing technology for efficient free-text and regex search, parsing on traces and text data, and comprehensive JSON parsing capabilities. Customers can quickly query unstructured, semi-structured, and structured data including arrays and nested structures, as well as native and advanced time series support for creation, manipulation, and analysis of multiple time series with in-engine Python execution support for model scoring.

When using Azure Synapse data explorer, compute and storage are decoupled allowing you to scale independently and optimise for price-performance.

Type Price
Azure Synapse data explorer compute $- per vCore-hour
Standard ZRS data stored $- per TB/month
Standard LRS data stored $- per TB/month
  • Note: Compute for a Data Explorer pool in Azure Synapse will only require one of the above-mentioned standard data stores. Whether the ZRS or LRS data storage is used depends on Availability Zones where the Data Explorer pool is provisioned.
  • Compute for running the Azure Synapse data explorer engine service responsible for indexing, caching data on local SSDs and premium storage as managed disks, and serving queries requires a minimum of two compute instances. Azure Synapse data explorer offers Compute Optimised (38 GB disk cache per vCore) and Storage Optimised (Medium - 128 GB disk cache per vCore, Large – 192 GB disk cache per vCore) workload types. You can change the workload type (keeping the same pool size) after the initial deployment with no impact on cost. Both workload types are billed on the Azure Synapse data explorer metre.
  • Compute for running the data management (DM) service responsible for data ingestion from managed data pipelines such as Azure Data Lake Storage, Event Hub, and IoT Hub requires a minimum of two compute instances. The size and scale for the DM service instance is automatically managed based on the engine instance size and usage and is billed as 0.5 units of the Azure Synapse data explorer metre.
  • Azure Synapse data explorer uses storage under the hood as the persistent layer where all the data is stored compressed and is billed as Standard LRS Data Stored or as Standard ZRS Data Stored where Availability Zones are available. Compute for a Data Explorer pool in Azure Synapse will only require one of the above-mentioned standard data stores. Whether the ZRS or LRS data storage is used depends on Availability Zones where the Data Explorer pool is provisioned.
  • Other resources such as Network I/O and Bandwidth cost may be charged separately based on your cross-region usage.
  • Azure Synapse data explorer is billed by rounding up usage to the nearest minute.

Azure Synapse Link for SQL

With Azure Synapse Link for SQL, automatically move data from your SQL databases without time-consuming extract, transform, and load (ETL) processes. Gain an end-to-end view of your business by easily connecting separate systems and enable BI reporting on operational data without impacting your operational store.

Price
Azure Synapse Link for SQL $- per vCore-hour

Azure Synapse Link for Cosmos DB

Use Azure Synapse Link for Azure Cosmos DB to implement a simple, low-cost, cloud-native HTAP solution that enables near-real-time analytics. Empower data teams to use Apache Spark or serverless SQL pools on Azure Synapse to gain insights through business intelligence, big data analytics, built-in AI and machine learning options, and more.

Pricing details for Azure Synapse Link for Cosmos DB are detailed as analytical storage transactions on the Azure Cosmos DB pricing page.

Azure Synapse Link for Dataverse

Use Azure Synapse Link for Dataverse to run advanced analytics tasks on data from Dynamics 365 and Power Platform. Link your Dataverse environments with Azure Synapse for near real-time data access for data integration pipelines, big data processing with Apache Spark, data enrichment with built-in AI and ML capabilities, and serverless data lake exploration for ad-hoc analysis.

Azure Synapse Link for Dataverse is included with Microsoft Power Platform and certain Microsoft 365 licences. See the licensing overview for more details.

Azure pricing and purchasing options

Connect with us directly

Get a walkthrough of Azure pricing. Understand pricing for your cloud solution, learn about cost optimisation and request a customised proposal.

Talk to a sales specialist

See ways to purchase

Purchase Azure services through the Azure website, a Microsoft representative or an Azure partner.

Explore your options

Additional resources

Azure Synapse Analytics

Learn more about Azure Synapse Analytics features and capabilities.

Pricing calculator

Estimate your expected monthly costs for using any combination of Azure products.

SLA

Review the Service Level Agreement for Azure Synapse Analytics.

Documentation

Review technical tutorials, videos, and more Azure Synapse Analytics resources.

  • Yes, once the data warehouse is created, you will be billed hourly for compute and storage. Compute is billed at $-/100 DWUs/month, unless the data warehouse is paused. Storage is billed at $- per TB per month of data stored.

  • Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour. If your data warehouse was active and then changed to pause during the hour, then you will be charged for that hour of compute. When your data warehouse is paused, you will be charged for storage that includes data warehouse files, 7-days' worth of incremental backups, and geo redundant copy, if opted in. To learn more, please refer to the documentation.

  • Compute and storage are billed separately to make it easier for you to see the level of compute resources consumed. Compute usage is charged on an hourly basis. For example, if your data warehouse is active for 12 hours in a month, you will only be billed for those 12 hours, with billing starting from the top of each hour (00:00:01 onwards). If your data warehouse exists for only 30 minutes in a month, you will be billed for 1 hour.
  • Your data storage charge is inclusive of the size of your primary database, plus 7 days of incremental snapshots. Charges are rounded to the nearest TB. For example, if your data warehouse is 1.5 TB and you have 100 GB of snapshots, you will be billed for 2 TB of data at a rate of $- per TB per month of data stored.

  • Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.

  • You cannot opt out of snapshots, as this capability provides your data warehouse with data loss and corruption protection.

  • DWUs are billed for each hour a pool exists using the highest compute size (DWU) that applied during that hour, regardless the number of minutes used during that hour.

Azure Synapse reserved capacity pricing

  • Reserved capacity enables you to save up to 65% on your data warehousing resources compared to pay as you go pricing by pre-paying for your compute capacity on a one or three-year term.

  • You can purchase one-year or three-year term reserved capacity with a single, upfront payment. Reservations are available for purchase through the Azure portal. The reservations menu will appear on the left pane in the Azure portal.

  • Reserved capacity has a scope of either a Single subscription or Shared. This scope controls how many subscriptions can leverage the billing benefit associated with the reservation, and it controls how the reservation is applied to specific subscriptions.

    A reservation scoped to a single subscription means that the reserved capacity discount will apply only to data warehousing resources on Synapse Analytics within the selected subscription.

    A reservation with the scope of Shared means that the billing benefit for it can be shared across any subscription in the enrolment (Enterprise Agreement customers) or account (Pay as you go customers).

  • The reservation start and end dates are based on the purchase date and duration of the reservation. The benefit will apply immediately to any existing running deployments that match the terms of the reservation based on where the reservation is made available, i.e. scoped to a single subscription or shared across the entire Azure account/enrolment. Otherwise, the reservation benefit will apply when you have new deployments that match the terms of the reservation.

  • For EA customers, reserved capacity purchases will always be deducted from any available Azure Prepayment first; this deduction will happen in the month the reserved capacity was purchased. In the event you do not have enough Azure Prepayment, or do not have any Azure Prepayment, all reserved capacity purchases will show on your next overage invoice.

    For web direct customers, all reserved capacity charges will appear on the credit card on file, or on the next invoice if you have invoice terms established on your account.

  • You can view reserved capacity usage on the “Usage Summary” page under the “Reports” menu on the EA Portal. There, you will see a “Reservation” section that will show reserved capacity usage. In addition to this, you can find reserved capacity usage details in the detailed usage file (CSV) that you can download from the EA Portal. The “Additional Info” field will help you to identify the usage against reserved capacity.

  • Your deployments will continue running and will be billed at an on-demand rate once the reserved capacity benefit expires. You will no longer receive the price benefit for reserved capacity.

  • Yes, you will receive email notifications at least 30 days prior to expiration. Additionally, you can view reservation details in the Azure portal.

Talk to a sales specialist for a walk-through of Azure pricing. Understand pricing for your cloud solution.

Get free cloud services and a $200 credit to explore Azure for 30 days.

Added to estimate. Press 'v' to view on calculator
Can we help you?