SQL Data Warehouse

What is SQL Data Warehouse

Azure SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.

Azure SQL Data Warehouse is a key component of big data solution.

Typical four stages exits in building analytics platform for big data solution. First three stages are Ingest, Store, Prepare and Train.

Once the data is ready for analysis with or without the first three stages, Data is loaded in any one of Model and Serve technology. SQL DW to run analytics at massive scale. Azure SQL Data Warehouse is a massively parallel processing (MPP) cloud-based, scale-out, relational database capable of processing massive volumes of data.

SQL Data Warehouse

· Combines the SQL Server relational database with Azure cloud scale-out capabilities.

· Decouples storage from compute.

· Enables increasing, decreasing, pausing, or resuming compute.

· Integrates across the Azure platform.

· Utilizes SQL Server Transact-SQL (T-SQL) and tools.
· Complies with various legal and business security requirements such as SOC and ISO.

Performance Tiers

Optimized for Elasticity Performance tier separates the compute and storage and excel on workload that is leveraged by scaling frequently to support short period of peak activity

Optimized for Compute Performance tier designed for high computing requirements. It uses additional hardware to keep the most frequently accessed data close to CPU.

MPP Architecture