SQL Data Warehouse

Fast, familiar, and flexible analytics platform for enterprise

Quickly implement a high-performance, secure, and compliant cloud data warehouse. Azure SQL Data Warehouse is the SQL analytics platform that lets you scale compute and storage elastically and independently, with a massively parallel processing architecture. Seamlessly integrate SQL Data Warehouse with big data stores, and create a hub for your data marts and cubes—to drive highly tailored, enterprise-grade performance, while leveraging your existing SQL and BI skills.

SQL Data Warehouse offers guaranteed 99.9 percent availability, regulatory compliance, advanced security features, and tight integration with upstream and downstream services so you can build a data warehouse that fits your needs. SQL Data Warehouse is the first service enabling enterprises to replicate data virtually anywhere around the globe.

Make your data go further. SQL Data Warehouse gives you a highly elastic data warehouse solution to remove limits to scale and performance.

Unlimited scale

Make your data go further. SQL Data Warehouse gives you a highly elastic data warehouse solution to remove limits to scale and performance.

Optimize data warehouse performance and lower costs by scaling compute and storage independently.

Elastic and extensible

Optimize data warehouse performance and lower costs by scaling compute and storage independently.

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is Health Insurance Portability and Accountability Act of 1996 (HIPPA)-compliant.

Trusted and secure

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is Health Insurance Portability and Accountability Act of 1996 (HIPPA)-compliant.

Continue using other valuable technologies. SQL Data Warehouse is compatible across Microsoft and leading data integration and visualization vendors such as Tableau and Informatica.

Seamless integration

Continue using other valuable technologies. SQL Data Warehouse is compatible across Microsoft and leading data integration and visualization vendors such as Tableau and Informatica.

Customers using Azure SQL Data Warehouse

  • Jet.com
  • Adobe
  • Toshiba
  • LG CNS
  • Kansas State University
  • Carnival Cruises

Trusted partner network

Accelerate your time to value with a cloud data warehouse backed by our trusted partner ecosystem.

Informatica
MicroStrategy
Talend
Tableau
Qlik
Datometry

Get started with Azure SQL Data Warehouse

Learn common patterns of SQL Data Warehouse, understand successful loading patterns and strategies, and see how to migrate data to Azure SQL Data Warehouse. If you need workload isolation, or unlimited concurrency for serving your customers or suppliers in data, read about common partner application patterns.

Provision and scale compute to thousands of cores in under five minutes, for incredibly fast performance.

Lightning-fast provisioning

Provision and scale compute to thousands of cores in under five minutes, for incredibly fast performance.

SQL Data Warehouse can handle the most demanding big-data analytics tasks. PolyBase gives you rapid data intake from multiple data sources using the same query tooling experience.

Cloud-scale data processing

SQL Data Warehouse can handle the most demanding big-data analytics tasks. PolyBase gives you rapid data intake from multiple data sources using the same query tooling experience.

SQL Data Warehouse allows you to independently scale compute and storage to adjust to your unique business needs.

Elastic compute and storage

SQL Data Warehouse allows you to independently scale compute and storage to adjust to your unique business needs.

SQL Data Warehouse automatically handles infrastructure, optimization, and more, so that you can focus on driving value from your data.

Fully managed infrastructure

SQL Data Warehouse automatically handles infrastructure, optimization, and more, so that you can focus on driving value from your data.

Integration with leading data management and business intelligence vendors, as well as Microsoft services, to accelerate your time to value for a finished solution.

Ecosystem integration

Integration with leading data management and business intelligence vendors, as well as Microsoft services, to accelerate your time to value for a finished solution.

SQL Data Warehouse is built on SQL Server, the industry’s top performing SQL engine, with the most comprehensive support for SQL language.

SQL Server foundation

SQL Data Warehouse is built on SQL Server, the industry’s top performing SQL engine, with the most comprehensive support for SQL language.

By integrating with Azure SQL Database and Azure Analysis Services, there is no limit to how many users can interact with your data warehouse.

Limitless concurrency

By integrating with Azure SQL Database and Azure Analysis Services, there is no limit to how many users can interact with your data warehouse.

Available in more than 30 regions, SQL Data Warehouse is the most geographically available data warehouse service in the cloud. Keep your data where your users are.

Global availability

Available in more than 30 regions, SQL Data Warehouse is the most geographically available data warehouse service in the cloud. Keep your data where your users are.

Built-in features include VNET service endpoints, advanced threat detection, always-on encryption, audit, and managed access through Azure Active Directory.

Advanced security

Built-in features include VNET service endpoints, advanced threat detection, always-on encryption, audit, and managed access through Azure Active Directory.

SQL Data Warehouse has more than 20 government and industry certifications, including HIPPA, to protect your data and keep it sovereign.

Industry-leading compliance

SQL Data Warehouse has more than 20 government and industry certifications, including HIPPA, to protect your data and keep it sovereign.

What can you build with Azure SQL Data Warehouse?

Hub and spokes for thousands of BI users

Use the hub and spoke architecture to achieve the scale you want, at the price and performance level you decide. This architecture also provides resource isolation and advanced security features.

Use the hub and spoke architecture to achieve the scale you want, at the price and performance level you decide. This architecture also provides resource isolation and advanced security features.

Auto-scale SQL Data Warehouse for optimized usage

With Azure Functions, you can take full advantage of the elasticity of Azure SQL Data Warehouse by auto-scaling, and optimize your cost.

Big-data integration for batch processing of unstructured data

With Azure Data Factory, users can easily integrate your on-premises and cloud data applications to your data warehouse. Customers can choose between the leading open source solution (HDInsight) or .Net (Azure Data Lake) to process unstructured data and load terabytes of results to Azure SQL Data Warehouse using PolyBase.

Process unstructured data near real-time

With Kafka (HDInsight) or Event Hubs, you can capture data continuously from any IoT devices or logs from website clickstream. This data can be processed in real-time with the leading open source solution (HDInsight Storm or Spark) or a familiar SQL language streaming tool like Azure Stream Analytics. Finally you can easily adjust the frequency of your micro-batching with Azure Event Grid that sends an event to SQL Data Warehouse to load processed data with Polybase.

Related products and services

Power BI

Improve business analytics

Azure Analysis Services

Enterprise grade analytics engine as a service

HDInsight

Provision cloud Hadoop, Spark, R Server, HBase, and Storm clusters

Try SQL Data Warehouse with a free Azure account