Skip navigation

SQL Data Warehouse

Fast, flexible and secure analytics platform for the enterprise

Quickly implement a high-performance, globally available and lower-cost 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 visualisation services, all while using your existing SQL and BI skills.

With SQL Data Warehouse, companies can improve data analytics and reduce associated costs. It offers guaranteed 99.9 per cent 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 and helps you reduce costs. SQL Data Warehouse adapts to your workload. It uses intelligent caching to accelerate data access and query performance to handle the most demanding data warehousing workload.

A new update to SQL Data Warehouse is now available. It brings lightning-fast performance made possible by software breakthroughs, and by using the latest hardware innovations in Azure data centres. SQL Data Warehouse customers can now expect significant query performance improvements, including the ability to run 128 concurrent queries, and to store an unlimited amount of columnar data, empowering you to run your largest and most complex analytics workloads.

Make data go further. SQL Data Warehouse gives you a cloud solution that removes limits to scale and performance. With tight Azure Databricks integration, bring together any data type at any scale.

Scale and performance

Make data go further. SQL Data Warehouse gives you a cloud solution that removes limits to scale and performance. With tight Azure Databricks integration, bring together any data type at any scale.

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

Elastic and extensible

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

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is compliant across more than 50 certifications, and available across global regions.

Trusted and secure

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is compliant across more than 50 certifications, and available across global regions.

Combine with leading data integration and BI solutions. SQL Data Warehouse is compatible across Microsoft and leading data integration and visualisation 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 visualisation vendors such as Tableau and Informatica.

Customers using Azure SQL Data Warehouse

  • Jet.com
  • Adobe
  • Carnival Cruises
  • 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.

  • Datometry
  • Informatica Cloud
  • MicroStrategy
  • Qlik
  • Talend
  • Tableau

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 app patterns.

Service capabilities

Unleash the power of data with 128 concurrent queries and scale to unlimited queries with Azure Analysis Services integration.

Limitless concurrency

Unleash the power of data with 128 concurrent queries and scale to unlimited queries with Azure Analysis Services integration.

Coupled with <a href="/en-gb/blog/unlock-your-data-s-potential-with-azure-sql-data-warehouse-and-azure-databricks/">Azure Databricks</a> and Azure HDInsight, easily connect and integrate your curated data into your data warehouse with PolyBase, giving you rapid intake from multiple data sources using the same query tooling experience.

Process any kind of data

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

Provision thousands of compute cores in under five minutes and scale to petabyte in hours.

Lightning-fast provisioning

Provision thousands of compute cores in under five minutes and scale to petabyte in hours.

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.

Built-in features include Virtual Network service endpoints, advanced threat detection, always-on encryption, audit and simplified secure access through Azure Active Directory.

Advanced security

Built-in features include Virtual Network service endpoints, advanced threat detection, always-on encryption, audit and simplified secure access through Azure Active Directory.

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

Fully managed infrastructure

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

Integration with leading data integration and visualisation vendors and support from a large system integrator ecosystem to accelerate your time to value.

Strong ecosystem

Integration with leading data integration and visualisation vendors and support from a large system integrator ecosystem to accelerate your time to value.

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.

Industry-leading SQL engine

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

Protect and secure your data with 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

Protect and secure your data with 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-gb/regions/services/">33 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 33 regions. Keep your data where your users are.

What can you build with Azure SQL Data Warehouse?

Modern data warehouse

  1. Overview
  2. Flow

A modern data warehouse lets you bring together all your data at any scale easily, and means you can get insights through analytical dashboards, operational reports or advanced analytics for all your users.

  1. 1 Combine all your structured, unstructured and semi-structured data (logs, files and media) using Azure Data Factory to Azure Blob Storage.
  2. 2 Leverage data in Azure Blob Storage to perform scalable analytics with Azure Databricks and achieve cleansed and transformed data.
  3. 3 Cleansed and transformed data can be moved to Azure SQL Data Warehouse to combine with existing structured data, creating one hub for all your data. Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  4. 4 Build operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data, and use Azure Analysis Services to serve thousands of end users.
  5. 5 Run ad hoc queries directly on data within Azure Databricks.

Advanced analytics on big data

  1. Overview
  2. Flow

Transform your data into actionable insights using the best-in-class machine learning tools. This architecture allows you to combine any data at any scale, and to build and deploy custom machine-learning models at scale.

  1. 1 Bring together all your structured, unstructured and semi-structured data (logs, files and media) using Azure Data Factory to Azure Blob Storage.
  2. 2 Use Azure Databricks to clean and transform the structureless datasets and combine them with structured data from operational databases or data warehouses.
  3. 3 Use scalable machine learning/deep learning techniques to derive deeper insights from this data using Python, R or Scala, with inbuilt notebook experiences in Azure Databricks.
  4. 4 Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  5. 5 Power users take advantage of the inbuilt capabilities of Azure Databricks to perform root cause determination and raw data analysis.
  6. 6 Run ad hoc queries directly on data within Azure Databricks.
  7. 7 Take the insights from Azure Databricks to Cosmos DB to make them accessible through web and mobile apps.

Real-time analytics

  1. Overview
  2. Flow

Get insights from live streaming data with ease. Capture data continuously from any IoT device, or logs from website clickstreams, and process it in near-real time.

  1. 1 Easily ingest live streaming data for an application using Apache Kafka cluster in Azure HDInsight.
  2. 2 Bring together all your structured data using Azure Data Factory to Azure Blob Storage.
  3. 3 Take advantage of Azure Databricks to clean, transform and analyse the streaming data, and combine it with structured data from operational databases or data warehouses.
  4. 4 Use scalable machine learning/deep learning techniques to derive deeper insights from this data using Python, R or Scala, with inbuilt notebook experiences in Azure Databricks.
  5. 5 Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  6. 6 Build analytical dashboards and embedded reports on top of Azure Data Warehouse to share insights within your organisation and use Azure Analysis Services to serve this data to thousands of users.
  7. 7 Power users take advantage of the inbuilt capabilities of Azure Databricks and Azure HDInsight to perform root cause determination and raw data analysis.
  8. 8 Take the insights from Azure Databricks to Cosmos DB to make them accessible through real-time apps.

Hub and Spoke Architecture for BI

OVERVIEW

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-scaling cloud data warehouse

OVERVIEW

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

On-premises Data Warehouse appliance migration

OVERVIEW

Unleash the power of cloud on your data. Migrate your traditional data warehouse workloads to Azure SQL Data Warehouse while maintaining legacy application, and enable new use cases by bringing in unstructured data.

Data mart consolidation

OVERVIEW

Bring together multiple databases in an enterprise data warehouse to break data silos and make the right insights accessible across your organisation.

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

Download these free white papers

Try SQL Data Warehouse with a free Azure account