- Explore SQL Data Warehouse:
- Pricing details
- Documentation
- Community
Fast provisioning and scaling
Provision a data warehouse in just 3 to 5 minutes, and scale your compute in seconds to keep up with demand. Unlike other cloud services that can require hours to scale up, SQL Data Warehouse truly delivers on the promise of cloud elasticity, making it ideal for batch-based data warehouse workloads.
Budget freedom and flexibility
Because SQL Data Warehouse has a decoupled storage and compute model, it allows you to easily scale compute in seconds without over-provisioning or over-paying. Plus, SQL Data Warehouse offers the unique option to pause compute, giving you even more freedom to better manage your cloud costs. Now bring all your data with no tradeoffs on which data to ingest—run compute only on the datasets that matter.
Innovative security for strong protection
Only SQL Data Warehouse includes built-in auditing and threat detection, which use machine learning to understand the patterns of your workload and serve as an alarm system to alert you of a potential breach—before it’s too late. SQL Data Warehouse also works seamlessly with Azure Active Directory, the proven technology that currently supports 1.3 billion daily authentications across 600 million user accounts. This support enables single sign-on (SSO) to further protect data by ensuring the right users have access to the right data, which is critical when end users are running analytics against the data warehouse.
Big data insights with integrated queries
Built-into SQL Data Warehouse, Microsoft PolyBase technology simplifies and enables distributed analytics and allows you to run a single T-SQL query using familiar tools over multiple data sources, including Azure Storage blobs. PolyBase also offers blazing-fast data ingestion from within the same query tooling experience.
Real-time analytics 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 and Microsoft Excel. Plus, tools from popular BI partners including Looker Data Sciences, Tableau Software, and Qlik Technologies work great with SQL Data Warehouse. And seamless compatibility with SQL Server Integration Services, Azure Analysis Services, Azure Stream Analytics, Azure Machine Learning, Azure Data Factory, and Azure Storage ensures insight across all of your data, as fast as it’s coming in.
BI provider optimizes data processing with Azure SQL Data Warehouse
Customer: Agoop
“What we’ve ended up with is the ability to not only look at our data in real time, but also know that it’s going into what is essentially a large data bucket in Azure SQL Data Warehouse. As a result, we can keep all of our first- and third-party data in the same place for additional processing.”
Christopher Beach
MediaBrix
Senior Vice President of Engineering
This maverick moved from Amazon to Azure and boosted customer revenue-per-click by 38 percent.
“Given the success of the project and the effectiveness of Azure, we will look to migrate to a full cloud offering in a few years’ time. Our experience in setting up Azure to meet our disaster recovery requirements have given us a lot of confidence in the Microsoft solution for our business.”
Mike Reilly, P:Cubed, CIO
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.