Azure Synapse Analytics pricing

Limitless analytics service with unmatched time to insight

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

Azure Synapse pricing

The pricing details for implementing an enterprise data warehouse using Azure Synapse (formerly Azure SQL Data Warehouse) can be found below. For existing SQL Data Warehouse customers, there will be no price change to your data warehousing workloads.

For the new public preview features accessible in the Azure Synapse Studio, pricing can be found by scrolling to sections with (preview) in the title or navigating directly to them using the toggle bar below. When using Azure Synapse, you will only pay for the capabilities you opt in to use. During public preview, there will not be a cost for provisioning an Azure Synapse workspace. Enabling a managed VNET and Customer Managed Keys may incur a workspace fee after public preview. Pricing of workspaces with additional capabilities will be announced at a future date.

Learn more about Azure Synapse (workspaces preview).

Azure Synapse SQL (Generally Available)

Enterprise data warehousing features that are generally available today (formerly Azure SQL Data Warehouse).

Azure Synapse SQL (Generally Available) 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 Azure Synapse (formerly Azure SQL Data Warehouse) can be found below.

When using Azure Synapse, you will only pay for the capabilities you opt in to use.

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. This pricing is for provisioning resources from the Azure Synapse generally available resource center (formerly SQL Data Warehouse).

Service Level DWU Pay as you go 1 year reserved
(% savings)
3 year reserved
(% savings)
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 $- $- $-

Learn more about Azure reservations and reserved capacity pricing for enterprise data warehousing resources with Azure Synapse Analytics.

Separates compute and storage for independent, elastic sizing of resources. Designed for frequent scaling operations to manage compute spend and cloud “burst” scenarios. Offers lowest starting scale point.

Service Level DWU Price
DW100 100 $-
DW200 200 $-
DW300 300 $-
DW400 400 $-
DW500 500 $-
DW600 600 $-
DW1000 1000 $-
DW1200 1200 $-
DW1500 1500 $-
DW2000 2000 $-
DW3000 3000 $-
DW6000 6000 $-

Standard egress charges apply.

Data storage and snapshots

Data storage is charged at the rate of $- per TB of data processed ($-/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 SQL Database Threat Detection 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.

SQL Database Threat Detection integrates alerts with Azure Security Center, 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 Azure Security Center pricing page for more details.

Support & SLA

  • Free billing and subscription management support.
  • Flexible support plans starting at $29/month. Find a plan.
  • Guaranteed 99.9% uptime for Azure Synapse Analytics (excluding Preview regions). Read the SLA.

Azure Synapse SQL (Preview)

Query and analyze data from your data lake and data warehouse with T-SQL using both serverless and provisioned consumption models.

Azure Synapse SQL (Preview) provides a rich T-SQL experience for interactive, batch, streaming, and predictive analytics. Users have the flexibility of choosing to use provisioned and serverless resources. This enables customers to use familiar SQL for demanding and predictable workloads, such as data warehousing, and across their data lake for exploratory analytics—all from the same service.

The pricing details for both provisioned and serverless resources can be found below.

For existing SQL Data Warehouse customers, there will be no price change to your data warehousing workloads. When using Azure Synapse, you will only pay for the capabilities you opt in to use.

Serverless

This functionality allows you to pay per query and use T-SQL to query data from your data lake in Azure rather than provision resources ahead of time.

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.

Provisioned Resources with Compute Optimized Gen2

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. This pricing is for provisioning resources from the Azure Synapse preview workspace.

Service Level DWU Price
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 $-

Learn more about Azure reservations and reserved capacity pricing for enterprise data warehousing resources with Azure Synapse Analytics.

Data storage and snapshots

Data storage is charged at the rate of $- per TB of data processed ($-/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 SQL Database Threat Detection 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.

SQL Database Threat Detection integrates alerts with Azure Security Center, 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 Azure Security Center pricing page for more details.

SLA

SLA is not applicable for services in the preview period. Learn more.

Apache Spark Integration (Preview)

Easily create and configure Apache Spark Pools for Azure Synapse.

Perform big data processing tasks with integrated Apache Spark directly in Azure Synapse.

When using Azure Synapse, you will only pay for the capabilities you opt in to use.

Type Price
Memory Optimized $- per vCore-hour

For more information on Apache Spark integration in Azure Synapse, read the documentation.

SLA

SLA is not applicable for services in the preview period. Learn more.

Azure Synapse Pipelines (Preview)

Easily construct ETL and ELT processes code-free within the intuitive visual environment or write your own code.

Pricing for Azure Synapse Pipelines is calculated based on:

  • Pipeline orchestration and execution
  • Data flow execution and debugging
  • Number of Data Factory operations such as create pipelines and pipeline monitoring

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.

When using Azure Synapse, you will only pay for the capabilities you opt in to use.

Data Pipelines (Preview)

Type Azure Hosted Price Azure Hosted Managed VNET 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 Activities $-/hour $-/hour
(Up to 50 concurrent pipeline activities)
$-/hour
External Pipeline Activities $-/hour $-/hour
(Up to 800 concurrent external pipeline activities)
$-/hour
Read Write Operations $- per 50,000 operations $- per 50,000 operations $- per 50,000 operations
Monitoring Operations $- per 50,000 operations $- per 50,000 operations $- per 50,000 operations

Data Flows

Data Flows are visually-designed components that enable data transformations at scale. Data Flows are currently in public preview. 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
Compute Optimized $- per vCore-hour
General Purpose $- per vCore-hour
Memory Optimized $- per vCore-hour

*Use of the copy activity to egress data out of an Azure datacenter will incur additional network bandwidth charges, which will show up as a separate outbound data transfer line item on your bill. 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.

Inactive pipelines

A pipeline is considered inactive if it has no associated trigger or any runs within the month. An inactive pipeline is charged at (~$-/month).

SLA

SLA is not applicable for services in the preview period. Learn more.

FAQ

  • 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 of data processed.

  • 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 the 12 hours that your data warehouse existed. 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 of data processed.

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

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 enrollment (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/enrollment. 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 monetary commitment first; this deduction will happen in the month the reserved capacity was purchased. In the event you do not have enough monetary commitment, or do not have any monetary commitment, 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.

Resources

Estimate your monthly costs for Azure services

Review Azure pricing frequently asked questions

Learn more about Azure Synapse Analytics

Review technical tutorials, videos, and more resources

Added to estimate. Press 'v' to view on calculator

Learn and build with $200 in credit, and keep going for free