Azure Synapse Analytics pricing

Limitless analytics service with unmatched time to insight

Azure Synapse Analytics is a limitless analytics service 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 resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage, and serve data for immediate BI and machine learning needs.

If you have a need to deploy Azure Synapse Analytics, please submit a request by submitting a ticket (i.e. Azure Support Portal ). Please kindly include the following information in your application: Company Name, Contact Name, Contact Number, Contact Email, Estimated Size of Synapse DWU, Usage Actual Start Time, Data Region where Synapse will be deployed (East 2? North 2?), Azure Subscription ID Where Synapse Will be Deployed, Willing to Discuss Case Study Further?

Upon receiving the application, we will review the information combining with factors, such as datacenter operations etc., to decide whether or not to whitelist and activate the relevant Subscription ID for Azure Synapse Analytics access.

Pricing Details

Pricing details can be found below by scrolling to the desired section or navigating directly to them using the toggle bar. When using Azure Synapse, you will only pay for the capabilities you opt in to use. Beginning May 1, 2021 there will be a cost when enabling additional workspace features, such as a Managed Virtual Network. For customers that are already using an Azure Synapse workspace before May 1, 2021 and have enabled the Managed Virtual Network feature, a monthly cost will begin to incur at this time.

Learn more about Azure Synapse.

Existing Azure SQL Data Warehouse customers will not experience any price change. In the Azure portal, your existing data warehouse resource will be labeled as Dedicated SQL pool (formerly SQL DW) beginning December 3, 2020.

Data Integration

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 ¥10.176 per 1,000 runs ¥10.176 per 1,000 runs ¥15.264 per 1,000 runs
Data Movement ¥2.544/DIU-hour ¥2.544/DIU-hour ¥1.02/hour
Pipeline Activity Integration Runtime ¥10.176/hour (Up to 50 concurrent pipeline activities) ¥0.05088/hour ¥0.02034/hour
Pipeline Activity External Integration Runtime ¥10.176/hour (Up to 800 concurrent external pipeline activities) ¥0.002544/hour ¥0.00102/hour

Inactive data pipelines

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

*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.

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
Compute Optimized ¥1.235706 per vCore-hour
Basic ¥1.810884 per vCore-hour
Standard ¥2.508924 per vCore-hour

Operation charges

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

SQL Server Integration Services Standard A-series V2 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
A4 v2 4 8 GB 40 GB ¥5.341/hour
( about¥3,973.704/month )
¥2.86/hour
( about¥2,127.84/month )(~79%)
A8 v2 8 16 GB 80 GB ¥10.97/hour
( about¥8,161.68/month )
¥6.009/hour
( about¥4,470.696/month )(~79%)

SQL Server Integration Services Enterprise A-series V2 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
A4 v2 4 8 GB 40 GB ¥12.162/hour
( about¥9,048.528/month )
¥2.86/hour
( about¥2,127.84/month )(~93%)
A8 v2 8 16 GB 80 GB ¥24.612/hour
( about¥18,311.328/month )
¥6.006/hour
( about¥4,468.464/month )(~93%)

SQL Server Integration Services Standard D-series V2 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
D1 v2 1 3.5 GB 50 GB ¥3.763/hour
( about¥2,799.672/month )
¥1.282/hour
( about¥953.808/month )(~66%)
D2 v2 2 7 GB 100 GB ¥5.052/hour
( about¥3,758.688/month )
¥2.572/hour
( about¥1,913.568/month )(~66%)
D3 v2 4 14 GB 200 GB ¥7.624/hour
( about¥5,672.256/month )
¥5.144/hour
( about¥3,827.136/month )(~66%)
D4 v2 8 28 GB 400 GB ¥15.248/hour
( about¥11,344.512/month )
¥10.287/hour
( about¥7,653.528/month )(~66%)

SQL Server Integration Services Enterprise D-series V2 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
D1 v2 1 3.5 GB 50 GB ¥10.584/hour
( about¥7,874.496/month )
¥1.282/hour
( about¥953.808/month )(~88%)
D2 v2 2 7 GB 100 GB ¥11.874/hour
( about¥8,834.256/month )
¥2.572/hour
( about¥1,913.568/month )(~88%)
D3 v2 4 14 GB 200 GB ¥14.445/hour
( about¥10,747.08/month )
¥5.144/hour
( about¥3,827.136/month )(~88%)
D4 v2 8 28 GB 400 GB ¥28.89/hour
( about¥21,494.16/month )
¥10.287/hour
( about¥7,653.528/month )(~88%)

SQL Server Integration Services Standard D-series V3 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
D2 v3 2 8 GB 50 GB ¥4.325/hour
( about¥3,217.8/month )
¥1.845/hour
( about¥1,372.68/month )(~57%)
D4 v3 4 16 GB 100 GB ¥6.164/hour
( about¥4,586.016/month )
¥3.683/hour
( about¥2,740.152/month )(~57%)
D8 v3 8 32 GB 200 GB ¥12.326/hour
( about¥9,170.544/month )
¥7.365/hour
( about¥5,479.56/month )(~57%)
D16 v3 16 64 GB 400 GB ¥24.645/hour
( about¥18,335.88/month )
¥14.724/hour
( about¥10,954.656/month )(~57%)
D32 v3 32 128 GB 800 GB ¥49.297/hour
( about¥36,676.968/month )
¥29.454/hour
( about¥21,913.776/month )(~57%)
D64 v3 64 256 GB 1,600 GB ¥98.594/hour
( about¥73,353.936/month )
¥58.907/hour
( about¥43,826.808/month )(~57%)

SQL Server Integration Services Enterprise D-series V3 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
D2 v3 2 8 GB 50 GB ¥11.15/hour
( about¥8,295.6/month )
¥1.845/hour
( about¥1,372.68/month )(~83%)
D4 v3 4 16 GB 100 GB ¥12.987/hour
( about¥9,662.328/month )
¥3.683/hour
( about¥2,740.152/month )(~83%)
D8 v3 8 32 GB 200 GB ¥25.969/hour
( about¥19,320.936/month )
¥7.365/hour
( about¥5,479.56/month )(~83%)
D16 v3 16 64 GB 400 GB ¥51.93/hour
( about¥38,635.92/month )
¥14.724/hour
( about¥10,954.656/month )(~83%)
D32 v3 32 128 GB 800 GB ¥103.86/hour
( about¥77,271.84/month )
¥29.454/hour
( about¥21,913.776/month )(~83%)
D64 v3 64 256 GB 1,600 GB ¥207.73/hour
( about¥154,551.12/month )
¥58.907/hour
( about¥43,826.808/month )(~83%)

SQL Server Integration Services Standard E-series V3 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
E2 v3 2 16 GB 50 GB ¥5.006/hour
( about¥3,724.464/month )
¥2.525/hour
( about¥1,878.6/month )(~50%)
E4 v3 4 32 GB 100 GB ¥7.53/hour
( about¥5,602.32/month )
¥5.05/hour
( about¥3,757.2/month )(~50%)
E8 v3 8 64 GB 200 GB ¥15.061/hour
( about¥11,205.384/month )
¥10.1/hour
( about¥7,514.4/month )(~50%)
E16 v3 16 128 GB 400 GB ¥30.122/hour
( about¥22,410.768/month )
¥20.2/hour
( about¥15,028.8/month )(~50%)
E32 v3 32 256 GB 800 GB ¥60.236/hour
( about¥44,815.584/month )
¥40.393/hour
( about¥30,052.392/month )(~50%)
E64 v3 64 432 GB 1,600 GB ¥115.83/hour
( about¥86,177.52/month )
¥76.144/hour
( about¥56,651.136/month )(~50%)

SQL Server Integration Services Enterprise E-series V3 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
E2 v3 2 16 GB 50 GB ¥11.824/hour
( about¥8,797.056/month )
¥2.525/hour
( about¥1,878.6/month )(~79%)
E4 v3 4 32 GB 100 GB ¥14.349/hour
( about¥10,675.656/month )
¥5.05/hour
( about¥3,757.2/month )(~79%)
E8 v3 8 64 GB 200 GB ¥28.703/hour
( about¥21,355.032/month )
¥10.1/hour
( about¥7,514.4/month )(~79%)
E16 v3 16 128 GB 400 GB ¥57.406/hour
( about¥42,710.064/month )
¥20.2/hour
( about¥15,028.8/month )(~79%)
E32 v3 32 256 GB 800 GB ¥114.86/hour
( about¥85,455.84/month )
¥40.393/hour
( about¥30,052.392/month )(~79%)
E64 v3 64 432 GB 1,600 GB ¥224.97/hour
( about¥167,377.68/month )
¥76.144/hour
( about¥56,651.136/month )(~79%)

Azure Synapse SSIS Standard E series v4 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
E80ids v4 2 16 GB 50 GB ¥136.548/hour
( 约¥101,591.712/mouth )
¥87.006/hour
( 约¥64,732.464/mouth )(~79%)

Azure Synapse SSIS Enterprise E series v4 VM

*The following prices are tax-inclusive.

*Monthly price estimation is based on a usage of 31 days per month.
Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
E80ids v4 2 16 GB 50 GB ¥273.036/hour
( 约¥203,138.784/mouth )
¥87.006/hour
( 约¥64,732.464/mouth )(~79%)

Data Exploration & Data Warehousing

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 FREE QUANTITY
Serverless ¥36.4 per TB of data processed 10 TB of free queries per month until July 31, 2021*
*Free quantities apply only to the follow subscription types: Pay-in-Advance, China Azure Enterprise Agreement. These included free quantities aggregate at the enrollment level for enterprise agreements and at the subscription level for pay-in-advance subscriptions.

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 cDWU Pricing 1 year CPP 3 year CPP
DW100c 100 ¥ 8.05/hour (about¥ 5,989.2/month) ¥ 3,557.58 /month
~37% savings
¥1,976.44 /month
~65% savings
DW200c 200 ¥ 16.1/hour (about¥ 11,978.4/month) ¥7,115.16 /month
~37% savings
¥3,952.88 /month
~65% savings
DW300c 300 ¥ 24.15/hour (about¥ 17,967.6/month) ¥ 10,672.74 /month
~37% savings
¥5,929.32 /month
~65% savings
DW400c 400 ¥ 32.2/hour (about¥ 23,956.8/month) ¥14,230.32 /month
~37% savings
¥ 7,905.76 /month
~65% savings
DW500c 500 ¥ 40.25/hour (about¥ 29,946.0/month) ¥17,787.90 /month
~37% savings
¥9,882.20 /month
~65% savings
DW1000c 1000 ¥ 80.5/hour(about¥ 59,892/month) ¥35,575.80 /month
~37% savings
¥19,764.40 /month
~65% savings
DW1500c 1500 ¥ 120.75/hour(about¥ 89,838/month) ¥53,363.70 /month
~37% savings
¥29,646.60 /month
~65% savings
DW2000c 2000 ¥ 161/hour(about¥ 119,784/month) ¥71,151.60 /month
~37% savings
¥39,528.80 /month
~65% savings
DW2500c 2500 ¥ 201.25/hour(about¥ 149,730/month) ¥88,939.50 /month
~37% savings
¥49,411.00 /month
~65% savings
DW3000c 3000 ¥ 241.5/hour(about¥ 179,676/month) ¥106,727.40 /month
~37% savings
¥59,293.20 /month
~65% savings
DW5000c 5000 ¥ 402.5/hour(about¥ 299,460/month) ¥177,879.00 /month
~37% savings
¥98,822.00 /month
~65% savings
DW6000c 6000 ¥ 483/hour(about¥ 359,352/month) ¥213,454.80 /month
~37% savings
¥118,586.40 /month
~65% savings
DW7500c 7500 ¥ 603.75/hour(about¥ 449,190/month) ¥266,818.50 /month
~37% savings
¥148,233.00 /month
~65% savings
DW10000c 10000 ¥ 805/hour(about¥ 598,920/month) ¥355,758.00 /month
~37% savings
¥197,644.00 /month
~65% savings
DW15000c 15000 ¥ 1,207.5/hour(about¥ 898,380/month) ¥533,637.00 /month
~37% savings
¥ 296,466.00 /month
~65% savings
DW30000c 30000 ¥ 2,415/hour(about¥ 1,796,760/month) ¥1,067,274.00 /month
~37% savings
¥ 592,932.00 /month
~65% savings
SERVICE LEVEL cDWU Pricing
DW100c 100 ¥ 8.05/hour (about¥ 5,989.2/month)
DW200c 200 ¥ 16.1/hour (about¥ 11,978.4/month)
DW300c 300 ¥ 24.15/hour (about¥ 17,967.6/month)
DW400c 400 ¥ 32.2/hour (about¥ 23,956.8/month)
DW500c 500 ¥ 40.25/hour (about¥ 29,946.0/month)
DW1000c 1000 ¥ 80.5/hour(about¥ 59,892/month)
DW1500c 1500 ¥ 120.75/hour(about¥ 89,838/month)
DW2000c 2000 ¥ 161/hour(about¥ 119,784/month)
DW2500c 2500 ¥ 201.25/hour(about¥ 149,730/month)
DW3000c 3000 ¥ 241.5/hour(about¥ 179,676/month)
DW5000c 5000 ¥ 402.5/hour(about¥ 299,460/month)
DW6000c 6000 ¥ 483/hour(about¥ 359,352/month)
DW7500c 7500 ¥ 603.75/hour(about¥ 449,190/month)
DW10000c 10000 ¥ 805/hour(about¥ 598,920/month)
DW15000c 15000 ¥ 1,207.5/hour(about¥ 898,380/month)
DW30000c 30000 ¥ 2,415/hour(about¥ 1,796,760/month)

Data storage and snapshots

Data storage is charged at the rate of ¥169.638 per TB per month of data stored( ¥0.22 per TB per 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 ¥0.414/GB/month.

Price
Disaster recovery storage ¥0.414/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 Azure Security Center , and each protected SQL Database server will be billed at the same price as Azure Security Center Standard tier— $0.02/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.

Big Data Analytics with Apache Spark

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

TYPE PRICE FREE QUANTITY
Memory Optimized ¥0.974 per vCore-hour 120 free vCore-hours per month until July December 31, 2022*
*Free quantities apply only to the follow subscription types: Pay-in-Advance, China Azure Enterprise Agreement. These included free quantities aggregate at the enrollment level for enterprise agreements and at the subscription level for pay-in-advance subscriptions.

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

Log and Telemetry Analytics

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 optimize for price-performance.

Type Price
Azure Synapse data explorer compute 1.47 per vCore-hour
  • 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 Optimized (38 GB disk cache per vCore) and Storage Optimized (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 meter.
  • 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 meter.
  • 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.
  • 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 ¥10.176 per 1,000 runs ¥10.176 per 1,000 runs ¥15.264 per 1,000 runs
    Data Movement ¥2.544/DIU-hour ¥2.544/DIU-hour ¥1.02/hour
    Pipeline Activity Integration Runtime ¥10.176/hour (Up to 50 concurrent pipeline activities) ¥0.05088/hour ¥0.02034/hour
    Pipeline Activity External Integration Runtime ¥10.176/hour (Up to 800 concurrent external pipeline activities) ¥0.002544/hour ¥0.00102/hour

    Inactive data pipelines

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

    *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.

    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
    Compute Optimized ¥1.235706 per vCore-hour
    Basic ¥1.810884 per vCore-hour
    Standard ¥2.508924 per vCore-hour

    Operation charges

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

    SQL Server Integration Services Standard A-series V2 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    A4 v2 4 8 GB 40 GB ¥5.341/hour
    ( about¥3,973.704/month )
    ¥2.86/hour
    ( about¥2,127.84/month )(~79%)
    A8 v2 8 16 GB 80 GB ¥10.97/hour
    ( about¥8,161.68/month )
    ¥6.009/hour
    ( about¥4,470.696/month )(~79%)

    SQL Server Integration Services Enterprise A-series V2 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    A4 v2 4 8 GB 40 GB ¥12.162/hour
    ( about¥9,048.528/month )
    ¥2.86/hour
    ( about¥2,127.84/month )(~93%)
    A8 v2 8 16 GB 80 GB ¥24.612/hour
    ( about¥18,311.328/month )
    ¥6.006/hour
    ( about¥4,468.464/month )(~93%)

    SQL Server Integration Services Standard D-series V2 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    D1 v2 1 3.5 GB 50 GB ¥3.763/hour
    ( about¥2,799.672/month )
    ¥1.282/hour
    ( about¥953.808/month )(~66%)
    D2 v2 2 7 GB 100 GB ¥5.052/hour
    ( about¥3,758.688/month )
    ¥2.572/hour
    ( about¥1,913.568/month )(~66%)
    D3 v2 4 14 GB 200 GB ¥7.624/hour
    ( about¥5,672.256/month )
    ¥5.144/hour
    ( about¥3,827.136/month )(~66%)
    D4 v2 8 28 GB 400 GB ¥15.248/hour
    ( about¥11,344.512/month )
    ¥10.287/hour
    ( about¥7,653.528/month )(~66%)

    SQL Server Integration Services Enterprise D-series V2 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    D1 v2 1 3.5 GB 50 GB ¥10.584/hour
    ( about¥7,874.496/month )
    ¥1.282/hour
    ( about¥953.808/month )(~88%)
    D2 v2 2 7 GB 100 GB ¥11.874/hour
    ( about¥8,834.256/month )
    ¥2.572/hour
    ( about¥1,913.568/month )(~88%)
    D3 v2 4 14 GB 200 GB ¥14.445/hour
    ( about¥10,747.08/month )
    ¥5.144/hour
    ( about¥3,827.136/month )(~88%)
    D4 v2 8 28 GB 400 GB ¥28.89/hour
    ( about¥21,494.16/month )
    ¥10.287/hour
    ( about¥7,653.528/month )(~88%)

    SQL Server Integration Services Standard D-series V3 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    D2 v3 2 8 GB 50 GB ¥4.325/hour
    ( about¥3,217.8/month )
    ¥1.845/hour
    ( about¥1,372.68/month )(~57%)
    D4 v3 4 16 GB 100 GB ¥6.164/hour
    ( about¥4,586.016/month )
    ¥3.683/hour
    ( about¥2,740.152/month )(~57%)
    D8 v3 8 32 GB 200 GB ¥12.326/hour
    ( about¥9,170.544/month )
    ¥7.365/hour
    ( about¥5,479.56/month )(~57%)
    D16 v3 16 64 GB 400 GB ¥24.645/hour
    ( about¥18,335.88/month )
    ¥14.724/hour
    ( about¥10,954.656/month )(~57%)
    D32 v3 32 128 GB 800 GB ¥49.297/hour
    ( about¥36,676.968/month )
    ¥29.454/hour
    ( about¥21,913.776/month )(~57%)
    D64 v3 64 256 GB 1,600 GB ¥98.594/hour
    ( about¥73,353.936/month )
    ¥58.907/hour
    ( about¥43,826.808/month )(~57%)

    SQL Server Integration Services Enterprise D-series V3 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    D2 v3 2 8 GB 50 GB ¥11.15/hour
    ( about¥8,295.6/month )
    ¥1.845/hour
    ( about¥1,372.68/month )(~83%)
    D4 v3 4 16 GB 100 GB ¥12.987/hour
    ( about¥9,662.328/month )
    ¥3.683/hour
    ( about¥2,740.152/month )(~83%)
    D8 v3 8 32 GB 200 GB ¥25.969/hour
    ( about¥19,320.936/month )
    ¥7.365/hour
    ( about¥5,479.56/month )(~83%)
    D16 v3 16 64 GB 400 GB ¥51.93/hour
    ( about¥38,635.92/month )
    ¥14.724/hour
    ( about¥10,954.656/month )(~83%)
    D32 v3 32 128 GB 800 GB ¥103.86/hour
    ( about¥77,271.84/month )
    ¥29.454/hour
    ( about¥21,913.776/month )(~83%)
    D64 v3 64 256 GB 1,600 GB ¥207.73/hour
    ( about¥154,551.12/month )
    ¥58.907/hour
    ( about¥43,826.808/month )(~83%)

    SQL Server Integration Services Standard E-series V3 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    E2 v3 2 16 GB 50 GB ¥5.006/hour
    ( about¥3,724.464/month )
    ¥2.525/hour
    ( about¥1,878.6/month )(~50%)
    E4 v3 4 32 GB 100 GB ¥7.53/hour
    ( about¥5,602.32/month )
    ¥5.05/hour
    ( about¥3,757.2/month )(~50%)
    E8 v3 8 64 GB 200 GB ¥15.061/hour
    ( about¥11,205.384/month )
    ¥10.1/hour
    ( about¥7,514.4/month )(~50%)
    E16 v3 16 128 GB 400 GB ¥30.122/hour
    ( about¥22,410.768/month )
    ¥20.2/hour
    ( about¥15,028.8/month )(~50%)
    E32 v3 32 256 GB 800 GB ¥60.236/hour
    ( about¥44,815.584/month )
    ¥40.393/hour
    ( about¥30,052.392/month )(~50%)
    E64 v3 64 432 GB 1,600 GB ¥115.83/hour
    ( about¥86,177.52/month )
    ¥76.144/hour
    ( about¥56,651.136/month )(~50%)

    SQL Server Integration Services Enterprise E-series V3 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    E2 v3 2 16 GB 50 GB ¥11.824/hour
    ( about¥8,797.056/month )
    ¥2.525/hour
    ( about¥1,878.6/month )(~79%)
    E4 v3 4 32 GB 100 GB ¥14.349/hour
    ( about¥10,675.656/month )
    ¥5.05/hour
    ( about¥3,757.2/month )(~79%)
    E8 v3 8 64 GB 200 GB ¥28.703/hour
    ( about¥21,355.032/month )
    ¥10.1/hour
    ( about¥7,514.4/month )(~79%)
    E16 v3 16 128 GB 400 GB ¥57.406/hour
    ( about¥42,710.064/month )
    ¥20.2/hour
    ( about¥15,028.8/month )(~79%)
    E32 v3 32 256 GB 800 GB ¥114.86/hour
    ( about¥85,455.84/month )
    ¥40.393/hour
    ( about¥30,052.392/month )(~79%)
    E64 v3 64 432 GB 1,600 GB ¥224.97/hour
    ( about¥167,377.68/month )
    ¥76.144/hour
    ( about¥56,651.136/month )(~79%)

    Azure Synapse SSIS Standard E series v4 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    E80ids v4 2 16 GB 50 GB ¥136.548/hour
    ( 约¥101,591.712/mouth )
    ¥87.006/hour
    ( 约¥64,732.464/mouth )(~79%)

    Azure Synapse SSIS Enterprise E series v4 VM

    *The following prices are tax-inclusive.

    *Monthly price estimation is based on a usage of 31 days per month.
    Instance vCore RAM(GB) Temporary Storage License Included Price Azure Hybrid Benefit 1 Price (% Savings)
    E80ids v4 2 16 GB 50 GB ¥273.036/hour
    ( 约¥203,138.784/mouth )
    ¥87.006/hour
    ( 约¥64,732.464/mouth )(~79%)

    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 FREE QUANTITY
    Serverless ¥36.4 per TB of data processed 10 TB of free queries per month until July 31, 2021*
    *Free quantities apply only to the follow subscription types: Pay-in-Advance, China Azure Enterprise Agreement. These included free quantities aggregate at the enrollment level for enterprise agreements and at the subscription level for pay-in-advance subscriptions.

    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 cDWU Pricing 1 year CPP 3 year CPP
    DW100c 100 ¥ 8.05/hour (about¥ 5,989.2/month) ¥ 3,557.58 /month
    ~37% savings
    ¥1,976.44 /month
    ~65% savings
    DW200c 200 ¥ 16.1/hour (about¥ 11,978.4/month) ¥7,115.16 /month
    ~37% savings
    ¥3,952.88 /month
    ~65% savings
    DW300c 300 ¥ 24.15/hour (about¥ 17,967.6/month) ¥ 10,672.74 /month
    ~37% savings
    ¥5,929.32 /month
    ~65% savings
    DW400c 400 ¥ 32.2/hour (about¥ 23,956.8/month) ¥14,230.32 /month
    ~37% savings
    ¥ 7,905.76 /month
    ~65% savings
    DW500c 500 ¥ 40.25/hour (about¥ 29,946.0/month) ¥17,787.90 /month
    ~37% savings
    ¥9,882.20 /month
    ~65% savings
    DW1000c 1000 ¥ 80.5/hour(about¥ 59,892/month) ¥35,575.80 /month
    ~37% savings
    ¥19,764.40 /month
    ~65% savings
    DW1500c 1500 ¥ 120.75/hour(about¥ 89,838/month) ¥53,363.70 /month
    ~37% savings
    ¥29,646.60 /month
    ~65% savings
    DW2000c 2000 ¥ 161/hour(about¥ 119,784/month) ¥71,151.60 /month
    ~37% savings
    ¥39,528.80 /month
    ~65% savings
    DW2500c 2500 ¥ 201.25/hour(about¥ 149,730/month) ¥88,939.50 /month
    ~37% savings
    ¥49,411.00 /month
    ~65% savings
    DW3000c 3000 ¥ 241.5/hour(about¥ 179,676/month) ¥106,727.40 /month
    ~37% savings
    ¥59,293.20 /month
    ~65% savings
    DW5000c 5000 ¥ 402.5/hour(about¥ 299,460/month) ¥177,879.00 /month
    ~37% savings
    ¥98,822.00 /month
    ~65% savings
    DW6000c 6000 ¥ 483/hour(about¥ 359,352/month) ¥213,454.80 /month
    ~37% savings
    ¥118,586.40 /month
    ~65% savings
    DW7500c 7500 ¥ 603.75/hour(about¥ 449,190/month) ¥266,818.50 /month
    ~37% savings
    ¥148,233.00 /month
    ~65% savings
    DW10000c 10000 ¥ 805/hour(about¥ 598,920/month) ¥355,758.00 /month
    ~37% savings
    ¥197,644.00 /month
    ~65% savings
    DW15000c 15000 ¥ 1,207.5/hour(about¥ 898,380/month) ¥533,637.00 /month
    ~37% savings
    ¥ 296,466.00 /month
    ~65% savings
    DW30000c 30000 ¥ 2,415/hour(about¥ 1,796,760/month) ¥1,067,274.00 /month
    ~37% savings
    ¥ 592,932.00 /month
    ~65% savings
    SERVICE LEVEL cDWU Pricing
    DW100c 100 ¥ 8.05/hour (about¥ 5,989.2/month)
    DW200c 200 ¥ 16.1/hour (about¥ 11,978.4/month)
    DW300c 300 ¥ 24.15/hour (about¥ 17,967.6/month)
    DW400c 400 ¥ 32.2/hour (about¥ 23,956.8/month)
    DW500c 500 ¥ 40.25/hour (about¥ 29,946.0/month)
    DW1000c 1000 ¥ 80.5/hour(about¥ 59,892/month)
    DW1500c 1500 ¥ 120.75/hour(about¥ 89,838/month)
    DW2000c 2000 ¥ 161/hour(about¥ 119,784/month)
    DW2500c 2500 ¥ 201.25/hour(about¥ 149,730/month)
    DW3000c 3000 ¥ 241.5/hour(about¥ 179,676/month)
    DW5000c 5000 ¥ 402.5/hour(about¥ 299,460/month)
    DW6000c 6000 ¥ 483/hour(about¥ 359,352/month)
    DW7500c 7500 ¥ 603.75/hour(about¥ 449,190/month)
    DW10000c 10000 ¥ 805/hour(about¥ 598,920/month)
    DW15000c 15000 ¥ 1,207.5/hour(about¥ 898,380/month)
    DW30000c 30000 ¥ 2,415/hour(about¥ 1,796,760/month)

    Data storage and snapshots

    Data storage is charged at the rate of ¥169.638 per TB per month of data stored( ¥0. 22 per TB per 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 ¥0.414/GB/month.

    Price
    Disaster recovery storage ¥0.414/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 Azure Security Center , and each protected SQL Database server will be billed at the same price as Azure Security Center Standard tier— $0.02/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.

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

    TYPE PRICE FREE QUANTITY
    Memory Optimized ¥0.974 per vCore-hour 120 free vCore-hours per month until December 31, 2022*
    *Free quantities apply only to the follow subscription types: Pay-in-Advance, China Azure Enterprise Agreement. These included free quantities aggregate at the enrollment level for enterprise agreements and at the subscription level for pay-in-advance subscriptions.

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

    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 optimize for price-performance.

    Type Price
    Azure Synapse data explorer compute 1.47 per vCore-hour
  • 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 Optimized (38 GB disk cache per vCore) and Storage Optimized (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 meter.
  • 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 meter.
  • 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.
  • FAQ

    Expand all
    • When I create a data warehouse, am I charged immediately?

      Yes, once the data warehouse is created, you will be billed hourly for compute and storage. Compute is billed at ¥ 5,989.2/100 DWUs/month, unless the data warehouse is paused. Storage is billed at ¥169.638/1 TB/month.

    • When I pause my data warehouse, what am I charged for?

      ausing 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 .

    • How are compute and data storage billed?

      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.

    • What does my data storage bill look like?

      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 ¥169.638/1 TB/month.

    • What do I do if I need more than 1 TB of storage?

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

    • Can I opt-out of snapshots?

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

    Support & SLA

    If you have any questions or need help, please visit Azure Support and select self-help service or any other method to contact us for support.

    We promise client-side operations performed in SQL Data Warehouse will be successful at least 99.9% of time. To learn more about the details of our Service Level Agreement, please visit the Service Level Agreements page.