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