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.
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
|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)|
|DW6,000c||6,000||￥ 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)|
|DW30,000c||30,000||￥ 2,415/hour (about ¥1,796,760/month)|
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.
Compute Optimized Gen1
|DW 100||100||¥8.05/hour (about ¥5,989.2/month)|
|DW 200||200||¥16.1/hour (about ¥11,978.4/month)|
|DW 300||300||¥24.15/hour (about ¥17,967.6/month)|
|DW 400||400||¥32.2/hour (about ¥23,956.8/month)|
|DW 500||500||¥40.25/hour (about ¥29,946.0/month)|
|DW 600||600||¥48.3/hour (about ¥35,935.2/month)|
|DW 1,000||1,000||¥80.5/hour (about ¥59,892.0/month)|
|DW 1200||1200||¥96.6/hour (about ¥71,870.4/month)|
|DW 1500||1500||¥120.75/hour (about ¥89,838.0/month)|
|DW 2000||2000||¥161/hour (about ¥119,784.0/month)|
|DW 3000||3000||¥241.5/hour (about ¥179,676.0/month)|
|DW 6000||6000||¥483/hour (about ¥359,352.0/month)|
Storage pricing below reflects general availability pricing.
Data Storage and Snapshots
Data storage service is charged at the rate of Azure Premium Storage i.e. ¥906.29/1TB/month (¥1.22/1TB/hour). Data storage service covers data warehouse storage and 7 days of incremental snapshot storage.
Note: Storage transactions are free of charge. In other words, you only need to pay for the data storage service, and no transaction fees are needed.
Geo-Redundant Disaster Recovery
Data warehouse can be copied into Geo-Redundant Storage (GRS) for disaster recovery. Storage for Geo-Redundant copies will be charged based on the rate of the Azure standard disk RA-GRS rate of ¥1.056/GB/month.
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 ￥906.29/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 ￥906.29/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.
What does my storage bill look like if I opt into geo-redundant disaster recovery?
Your data warehouse is copied to geo-redundant storage for disaster recovery. Storage for geo-redundant copies is billed at Azure Standard Disk read-access geo-redundant storage of ¥1.056/GB/month.
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.