SQL Data Warehouse pricing

A fully-managed, highly-scalable, data warehouse service.

Azure SQL Data Warehouse lets you quickly implement a high-performance, globally available, and secure cloud data warehouse. You can independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

SQL Data Warehouse offers guaranteed 99.9 percent availability, regulatory compliance, built-in advanced security features, and data sovereignty across more than 30 regions so you can build a data warehouse that meets your business needs. SQL Data Warehouse adapts to your workload using intelligent caching to accelerate data access and query performance to handle the most demanding data warehousing workloads. Azure SQL Data Warehouse is available in 2 Compute Optimized SKUs: Gen1 and Gen2.

Pricing details

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

Compute Optimized Gen2

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 $- $- $-

Service Levels DW100c, DW200c, DW300c and DW400c currently have limited regional availability. View our documentation for details.

Learn more about Azure reservations and Azure SQL Data Warehouse reserved capacity pricing.


Effective November 1, 2018, there will be name changes to Azure SQL Data Warehouse storage on Azure. There won’t be a pricing impact, but you may need to modify billing routines that rely on names. Learn more on this page.

Data storage and snapshots

Data storage is charged at the rate of $-/1 TB/month ($-/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 SQL Data Warehouse (excluding Preview regions). Read the SLA.


  • 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 $-/1 TB/month.

  • 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 $-/1 TB/month.

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

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

SQL Data Warehouse reserved capacity

  • SQL Data Warehouse reserved capacity enables you to save up to 65% compared to Pay as you go pricing by pre-paying for your compute capacity on a one or three-year term.

  • SQL Data Warehouse reserved capacity is currently available in East US, East US 2, West US 2, South Central US, West Europe, North Europe, Japan East, South East Asia, and Australia East. More regions will be added in the future.

  • You can purchase one-year or three-year term SQL Data Warehouse 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.

  • SQL Data Warehouse 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 SQL Data Warehouse resources 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.


Estimate your monthly costs for Azure services

Review Azure pricing frequently asked questions

Learn more about SQL Data Warehouse

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