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. Optimise 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 of your analytical workloads.
SQL Data Warehouse is supported by a broad ecosystem of partners, including data preparation, ingestion service and visualisation tool providers. Enjoy guaranteed 99.9 per cent 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.
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 optimises compute provisioning to suit your workload demands and saves money on your highly variable workloads.
Get end-to-end security and compliance features including Azure Active Directory virtual networks, auditing, threat detection and data encryption.
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.
Massive query concurrency
Democratise 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.
Independently scale for performance or memory with separate compute and storage.
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 optimisation to focus on data analysis, and use the built-in advisor to optimise your cloud data warehouse.
Integrate with leading data preparation and visualisation 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.
Help ensure peace of mind with more than 50 government and industry compliance certifications, including HIPAA.
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.
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 organisation.
On-premises data warehouse migration
Migrate your traditional workloads to SQL Data Warehouse to optimise your data. Maintain legacy applications and create new use cases by bringing in unstructured data.
Related products and services
Hybrid data integration at enterprise scale, made easy
Azure Data Lake Storage
Massively scalable data lake storage
Fast, easy and collaborative Apache Spark-based analytics platform