SQL Data Warehouse

Fast, flexible, and secure analytics platform for the enterprise

Quickly implement a high-performance, globally available, and secure cloud data warehouse. Azure SQL Data Warehouse lets you 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.

Make your data go further. SQL Data Warehouse gives you a cloud solution that removes limits to scale and performance.

Unlimited scale

Make your data go further. SQL Data Warehouse gives you a cloud solution that removes limits to scale and performance.

Optimize data warehouse performance and lower costs by scaling compute and storage independently. Pause your data warehouse to ensure you are only paying for the resources you need.

Elastic and extensible

Optimize data warehouse performance and lower costs by scaling compute and storage independently. Pause your data warehouse to ensure you are only paying for the resources you need.

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is compliant across many industries, in many regions, with global availability.

Trusted and secure

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is compliant across many industries, in many regions, with global availability.

Combine with leading data integration and BI solutions. SQL Data Warehouse is compatible across Microsoft and leading data integration and visualization vendors such as Tableau and Informatica.

Seamless integration

Combine with leading data integration and BI solutions. 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

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

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, see common partner application patterns.

Service capabilities

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.

Independently and elastically scale compute and storage to adjust to your unique business needs.

Truly elastic by design

Independently and elastically scale compute and storage to adjust to your unique business needs.

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.

Coupled with Azure HDInsight and Azure Databricks, easily connect and integrate your curate data into your Data Warehouse PolyBase, giving you rapid intake from multiple data sources using the same query tooling experience.

Process any data at any scale

Coupled with Azure HDInsight and Azure Databricks, easily connect and integrate your curate data into your Data Warehouse PolyBase, giving you rapid intake from multiple data sources using the same query tooling experience.

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.

Automatically provision infrastructure, optimization, and more, so that you can focus on driving value from your data.

Fully managed infrastructure

Automatically provision infrastructure, optimization, and more, so that you can focus on driving value from your data.

Integration with leading data integration and visualization vendors, as well as Microsoft services, to accelerate your time to value for a finished solution. Backed by trained resources at leading system integrators.

Strong Ecosystem

Integration with leading data integration and visualization vendors, as well as Microsoft services, to accelerate your time to value for a finished solution. Backed by trained resources at leading system integrators.

SQL Data Warehouse is built on SQL Server, the industry’s <a href="http://www.tpc.org/tpch/results/tpch_perf_results.asp">top performing SQL engine</a>, 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.

More <a href="https://www.microsoft.com/en-us/trustcenter/compliance/complianceofferings">than 20 government and industry certifications</a>, including HIPPA, to protect your data and keep it sovereign.

Industry-leading compliance

More than 20 government and industry certifications, including HIPPA, to protect your data and keep it sovereign.

The most geographically available data warehouse service in the cloud, available in more than <a href="/en-us/regions/services/">30 regions</a>. Keep your data where your users are.

Global availability

The most geographically available data warehouse service in the cloud, available in more than 30 regions. Keep your data where your users are.

What can you build with Azure SQL Data Warehouse?

Serve unlimited number of BI users with Hub and Spokes

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

With Azure Functions, 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

Easily integrate your on-premises and cloud data applications to your data warehouse with Azure Data Factory. 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, 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

Azure Databricks

Fast, easy, and collaborative Apache Spark-based analytics platform

Try SQL Data Warehouse with a free Azure account