SQL Data Warehouse

The enterprise cloud data warehouse

An SQL-based, fully managed, petabyte-scale cloud data warehouse, Azure SQL Data Warehouse is highly elastic and enables you to set up in minutes and scale capacity in seconds. Scale compute and storage independently, which allows you to burst compute for complex analytical workloads or scale down your warehouse for archival scenarios; pay based on what you’re using instead of being locked into predefined cluster configurations; and get more cost-efficiency compared to traditional data warehouse solutions.

Provision fast and scale even faster

Get true cloud elasticity, provision a data warehouse in under five minutes and scale compute in a few seconds, meaning you don’t have to over-provision. Simply scale up when you need to, then scale down to keep costs under control.

Toshiba
"We are using Azure SQL Data Warehouse’s elasticity and scaling capabilities to scale up our systems when we need to do analytics on all the data we are collecting from thousands of devices, and then scale down, thus optimizing on cost without compromising performance."

Roger Shih, Senior Technical Product Manager, Toshiba America Business Solutions

Only pay for what you use

Pay for what you use instead of being locked into the predefined cluster configurations of traditional data warehouse solutions. Because compute and storage are separated, you can bring in all of your data, with no trade-offs in terms of which data to ingest, and run compute only on the data sets that matter. Also, SQL Data Warehouse gives you the unique option to pause compute, which means more freedom to better manage your cloud costs.

Integral Analytics
"We switched from AWS Redshift to Azure SQL Data Warehouse, migrating over 7 TB of uncompressed data over a week for the simple reasons of saving money and enabling a more straightforward implementation for advanced analytics."

Bill Sabo, Managing Director of Information Technology, Integral Analytics

Automatic threat detection built in

Manage, detect and mitigate security threats with automatic threat detection and Azure authentication features. Built-in auditing and threat detection use machine learning to understand the patterns of your workload and serve as an alarm system to alert you of a potential breach.

ASEBA
"Threat Detection is an incredible feature, super simple to use, empowering our small engineering team to protect our company data without the need to be security experts...Knowing that Microsoft is using its vast security expertise to protect my data gives me incredible peace of mind."

Manrique Logan, architect and technical lead, ASEBA

Mission-critical planning

Plan for reliability with a market-leading Service Level Agreement (SLA) that gives you 99.9 per cent uptime in regions available to the public. Broad compliance certifications and a data centre network that has the most coverage worldwide allow you to lead your growth strategy with Microsoft as a partner.

Adcorp
"Our vision is to expand Adcorp …. throughout Africa, the Middle East, and the Asia Pacific region, Azure is well-positioned to support our aggressive growth strategy and we have confidence in the partnership that has been established with Microsoft."

Peter Wilmot, General Manager of IT Infrastructure at Adcorp.

Get insights from big data and advanced analytics

Built into SQL Data Warehouse, PolyBase simplifies and enables distributed analytics and allows you to run a single Transact-SQL query over multiple data sources, including Azure Data Lake Store. PolyBase also gives you rapid data ingestion from within the same query tooling experience. Plus, compatibility with other services such as Azure Machine Learning and products from Looker Data Sciences allows you to run analytics across your data and transform your business.

Jet.com
"With Azure SQL Data Warehouse, we use PolyBase to ingest data from Azure HDInsight then run thousands of analytical queries per day over tens of billions of records—about 20 TB of data. This enables us to monitor price history and market dynamics to adjust pricing and ensure we’re offering our customers the best price."

Christoph Leinemann, Senior Director Data Engineering, Jet.com

Build on the familiar SQL Server platform

Use the familiar SQL language and develop with ease in a rich programming environment. Incorporating the innovations of SQL Server, SQL Data Warehouse gives you capabilities, such as the industry-leading SQL Server columnstore columnar storage for faster analytics queries.

MediaBrix
"It’s not Hive, it’s not uSQL, it’s not another language that you have to pick up, SQL is a language that all DBAs know like the back of their hand."

Christopher Beach, Senior Vice President of Engineering, MediaBrix

SQL Data Warehouse blog

 Pinned post

SQL Data Warehouse now supports seamless integration with Azure Data Lake Store

03 Jun 2017

Azure SQL Data Warehouse is a SQL-based fully managed, petabyte-scale cloud solution for data warehousing. SQL Data Warehouse is highly elastic, enabling you to provision in minutes and scale…

September 2017 Leaderboard of Database Systems contributors on MSDN

11 Oct 2017

Congratulations to our September top-10 contributors! Alberto Morillo maintains his first position in the cloud ranking while Olaf Helper climbs to the top in the All Databases ranking.This…

August 2017 Leaderboard of Database Systems contributors on MSDN

05 Sep 2017

Congratulations to our August top-10 contributors! Alberto Morillo maintain his first position in the cloud ranking while Erland Sommarskog climbs to the top in the All Databases ranking. This…

Preview: SQL Transparent Data Encryption (TDE) with Bring Your Own Key support

28 Aug 2017

The preview of Transparent Data Encryption with Bring Your Own Key support using Azure Key Vault is now available.

Get started

Not sure how to begin?

See a step-by-step guide to get started with SQL Data Warehouse, then learn common SQL Data Warehouse best practices.

Developer? Right this way.

Drive insights through a single SQL-based view across all of your data sources. Use Transact-SQL queries across relational and non-relational data. Dig deeper into authentication and connections, Dynamic SQL, stored procedures, user-defined schemas and views.

Data Platform Studio

Get started with automatic data migration from SQL Server

Import data to SQL Data Warehouse

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