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.
Customers using Azure SQL Data Warehouse
Trusted partner network
Accelerate your time to value with a cloud data warehouse backed by our trusted partner ecosystem.
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.
By integrating with Azure SQL Database and Azure Analysis Services, there is no limit to how many users can interact with your data warehouse.
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.
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.
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.
More than 20 government and industry certifications, including HIPPA, to protect your data and keep it sovereign.
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