Announcement
- SQL Data Warehouse outperforms Amazon Redshift by 67 percent.*
- Read the Gigaom report
Turbocharge your analytics with SQL Data Warehouse
Unlock new insights from your data with Azure SQL Data Warehouse, a fully managed cloud data warehouse for enterprises of any size that combines lightning-fast query performance with industry-leading data security. Optimize workloads by elastically scaling your resources in minutes. Get unlimited storage, automated administration, and built-in auditing and threat detection. Integrate seamlessly with Azure Active Directory, Azure Data Factory, Azure Data Lake Storage, Azure Databricks, and Microsoft Power BI to provide a single holistic modern data warehouse solution for all your analytical workloads.
SQL Data Warehouse is supported by a broad ecosystem of partners, including data preparation, ingestion service, and visualization tool providers. Enjoy guaranteed 99.9 percent availability in 40 Azure regions worldwide.
*Based on query execution performance testing of 66 queries conducted by Gigaom in July 2018; testing commissioned by Microsoft.
Lighting-fast performance
Built on the Microsoft SQL engine, SQL Data Warehouse provides breakthrough query performance in the cloud for the most complex and critical workloads.
Highly elastic compute
Our separated compute and storage optimizes compute provisioning to suit your workload demands and saves money on your highly variable workloads.
Industry-leading security
Get end-to-end security and compliance features including Azure Active Directory virtual networks, auditing, threat detection, and data encryption.
Seamless integration
Consolidate data silos and unify structured, unstructured, and streaming data with our cloud data warehouse solution.
Trusted partner network
Accelerate your time to value with an enterprise data warehouse backed by one of our trusted partners.
Service capabilities
Massive query concurrency
Democratize data across your enterprise.
Integrated data processing
Ingest and query from multiple data types and sources within a single solution.
Quick and easy provisioning
Provision thousands of compute cores in less than five minutes, and scale to a petabyte in hours.
Elastic design
Independently scale for performance or memory with separate compute and storage.
Advanced security
Help protect your data with virtual network service endpoints, advanced threat detection, always-on encryption, auditing, and simplified secure access.
Fully managed infrastructure
Automate infrastructure allocation and workload optimization to focus on data analysis, and use the built-in advisor to optimize your cloud data warehouse.
Strong Ecosystem
Integrate with leading data preparation and visualization vendors and get support from our partners to accelerate time to value.
Powerful SQL engine
Take advantage of Microsoft SQL Server, the industry’s top-performing SQL engine, offering comprehensive support for SQL language.
Industry-leading compliance
Help ensure peace of mind with more than 50 government and industry compliance certifications, including HIPAA.
Global availability
Benefit from availability in 40 Azure regions, the most among all cloud-based data warehouse providers.
What can you build with Azure SQL Data Warehouse?
Modern data warehouse
Use SQL Data Warehouse with Azure Analysis Services to achieve the scale you want at the price and performance level you choose. This architecture also provides resource isolation and advanced security features.
Advanced analytics for big data
Easily integrate your on-premises and cloud data applications to your enterprise data warehouse using Azure Data Factory. Choose from the leading open source solutions, including Azure Databricks for Apache Spark and Azure HDInsight for Apache Hadoop, Spark, and Kafka. Process unstructured data and load terabytes of results to SQL Data Warehouse using PolyBase. Use Azure Machine Learning to write algorithms easily and run them on-premises, in the cloud, or at the edge.
Real-time analytics
Capture data continuously from any IoT device or from website clickstream logs using Apache Kafka for HDInsight or Azure IoT Hub. Process data in real time using the leading open source solutions, including Azure Databricks for Apache Spark and Azure HDInsight for Apache Hadoop, Spark, and Kafka. Easily adjust the frequency of your microbatching with Azure Event Grid, which sends an event to SQL Data Warehouse to load processed data using PolyBase.
Hub and Spoke Architecture for BI
Use hub-and-spoke architecture to achieve the scale you want at the price and performance level you choose. This architecture also provides resource isolation and advanced security features.
Data mart consolidation
Bring together multiple databases into an enterprise data warehouse to eliminate data silos and make the right insights accessible across your organization.
On-premises data warehouse migration
Migrate your traditional workloads to SQL Data Warehouse to optimize your data. Maintain legacy applications and create new use cases by bringing in unstructured data.
Related products and services
Data Factory
Hybrid data integration at enterprise scale, made easy
Azure Data Lake Storage
Massively scalable data lake storage
Azure Databricks
Fast, easy, and collaborative Apache Spark-based analytics platform
HDInsight
Provision cloud Hadoop, Spark, R Server, HBase, and Storm clusters
Azure Analysis Services
Enterprise-grade analytics engine as a service
Power BI
Improve business analytics