Cheat sheet for Azure SQL Data Warehouse

The data warehouse design process is summarised in this diagram.

The cheat sheet provides a useful way demonstrate best practices when building Azure SQL Data Warehouse solutions. The various links within the cheat sheet provide more information.

Azure SQL Data Warehouse Workload Patterns and Anti-Patterns

Azure Data Lake Store

Data migration

Data loading

Extract, Load, and Transform (ELT) process.

Replicated tables 

Distributed tables

Indexes

Partitions

Statistics

Resource classes and concurrency

Manage compute resources. 

Typical architectures that take advantage of SQL Data Warehouse