Questions? Feedback? powered by Olark live chat software
Skip Navigation

SQL Data Warehouse

True cloud elasticity brought to data warehousing

Your go to SQL-based data warehouse and big data solution that enables advanced analytics and delivers more freedom to scale and control budget. Pay for the storage you use and the compute you need, when you need it.

Fastest provisioning and scaling experience

Unlike other cloud services which can require hours to scale up, SQL Data Warehouse truly delivers the promise of cloud elasticity ideally suited for batch-based data warehouse workloads. You can easily provision a data warehouse in 3-5 minutes and scale your compute in seconds to keep up with demand.

More budget freedom with decoupled storage and compute

SQL Data Warehouse delivers a decoupled storage and compute model which allows you to easily scale compute in seconds without the need to over-provision or over-pay. Additionally, only SQL Data Warehouse offers the ability to pause compute which gives you even more freedom over managing your cloud costs. This allows you to bring all your data with no tradeoffs on which data to ingest—run compute only on the datasets that matter.

More protection with unmatched innovations in security

Only SQL Data Warehouse delivers Auditing and Threat Detection built into the service which uses machine learning to understand the patterns of your workload and serves as an alarm system to alert you of a potential breach before it’s too late. Additionally, SQL Data Warehouse is the only cloud data warehouse service that works seamlessly with Azure Active Directory which currently supports 1.3 billion daily authentications across 600 million user accounts. This support enables Single Sign-On (SSO) which further protects data by ensuring the right users have access to the right data—this is critical when end users are running analytics against the data warehouse.

Unlocks big data insights with integrated queries over Hadoop clusters

Only Microsoft offers PolyBase technology which simplifies and enables distributed analytics—you simply run a single T-SQL query via familiar tools over multiple data sources, including Hadoop clusters. Built-into SQL Data Warehouse, PolyBase also offers blazing-fast data ingestion from within the same query tooling experience.

Real-time analytics across your data pipeline with built-in BI

Transform your business with real-time analytics for all of your data, structured and unstructured, with existing tools you already know and love—including industry-leading Power BI with 5 million users worldwide and Microsoft Excel. Microsoft also works with a set of popular BI partners to ensure the tools your teams use work great with SQL Data Warehouse so you don’t miss an insight including, Looker Data Sciences, Tableau Software, and Qlik Technologies. Plus, seamless compatibility with SQL Server Integration Services, Azure Stream Analytics, Azure Machine Learning, Azure Data Factory, and Azure Storage ensures insights over all of your data as fast as it’s coming in.

Build a cloud data warehouse

Learn about data warehousing or learn more about Azure SQL Data Warehouse to see how our fast, fully managed, petabyte-scale data warehouse can transform your business intelligence needs.

Why use a cloud data warehouse?

Learn how building a cloud-based data warehouse can drive incredible value while driving greater results.

Want the latest updates?

We never stop improving SQL Data Warehouse. Read our blog to stay up-to-date on our latest enhancements.

Not sure how to begin?

Review 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 data sources. Use Transact-SQL queries across relational and non-relational data. Dig into authentication and connections, Dynamic SQL, stored procedures, user-defined schemas, and views.

Related products and services

SQL Database

Managed relational SQL Database-as-a-service

Data Lake Store

Hyperscale repository for big data analytics workloads

Machine Learning

Powerful cloud-based predictive analytics

Try SQL Data Warehouse with a free Azure account