SQL Data Warehouse
Fast, familiar and flexible analytics platform for enterprises
Quickly implement a high-performance, secure and compliant cloud data warehouse. Azure SQL Data Warehouse is the SQL analytics platform that lets you scale compute and storage elastically and independently, with a massively parallel processing architecture. Seamlessly integrate SQL Data Warehouse with big data stores and create a hub for your data marts and cubes – to drive highly tailored, enterprise-grade performance, while leveraging your existing SQL and BI skills.
SQL Data Warehouse guarantees 99.9 per cent availability, regulatory compliance, advanced security features and tight integration with upstream and downstream services so you can build a data warehouse that fits your needs. SQL Data Warehouse is the first service enabling enterprises to replicate data virtually anywhere around the globe.
Make your data go further. SQL Data Warehouse gives you a highly elastic data warehouse solution to remove limits to scale and performance.
Elastic and extensible
Optimise data warehouse performance and lower costs by scaling compute and storage independently.
Trusted and secure
Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is Health Insurance Portability and Accountability Act of 1996 (HIPPA)-compliant.
Continue using other valuable technologies. 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
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, read about common partner application patterns.
Provision and scale compute to thousands of cores in under five minutes, for incredibly fast performance.
Cloud-scale data processing
SQL Data Warehouse can handle the most demanding big-data analytics tasks. PolyBase gives you rapid data intake from multiple data sources using the same query tooling experience.
Elastic compute and storage
SQL Data Warehouse allows you to independently scale compute and storage to adjust to your unique business needs.
Fully managed infrastructure
SQL Data Warehouse automatically handles infrastructure, optimisation and more, so that you can focus on driving value from your data.
Integration with leading data management and business intelligence vendors, as well as Microsoft services, to accelerate your time to value for a finished solution.
SQL Server foundation
SQL Data Warehouse is built on SQL Server, the industry’s top-performing SQL engine, with the most comprehensive support for SQL language.
By integrating with Azure SQL Database and Azure Analysis Services, there is no limit to how many users can interact with your data warehouse.
Available in more than 30 regions, SQL Data Warehouse is the most geographically available data warehouse service in the cloud. Keep your data where your users are.
Built-in features include VNET service endpoints, advanced threat detection, always-on encryption, audit and managed access through Azure Active Directory.
SQL Data Warehouse has 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?
Hub and spokes for thousands of BI users
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 for optimised usage
With Azure Functions, you can take full advantage of the elasticity of Azure SQL Data Warehouse by auto-scaling, and optimise your cost.
Big-data integration for batch processing of unstructured data
With Azure Data Factory, users can easily integrate your on-premises and cloud data applications to your data warehouse. Customers can 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 in 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 you can easily adjust the frequency of your micro-batching with Azure Event Grid, which sends an event to SQL Data Warehouse to load processed data with Polybase.
Related products and services