Snowflake Architecture
Three-layer Snowflake architecture: services, compute (warehouses), storage.
Rendering…
Make it your own.
digraph sf {
rankdir=TB;
graph [bgcolor=transparent];
node [shape=box, style="rounded,filled", fontname=Inter, fontsize=10];
Svc [label="Cloud Services Layer\n(metadata, optimiser, auth, txn)", fillcolor="#fce7f3"];
W1 [label="Virtual Warehouse\n(BI — XS)", fillcolor="#dbeafe"];
W2 [label="Virtual Warehouse\n(ETL — L)", fillcolor="#dbeafe"];
W3 [label="Virtual Warehouse\n(Data Science — XL)", fillcolor="#dbeafe"];
Stor [label="Centralised storage\n(micro-partitions on S3/ADLS/GCS)", fillcolor="#fef3c7"];
Cli [label="Client tools\n(SnowSQL, Snowsight, Power BI...)", fillcolor="#dcfce7"];
Cli -> Svc;
Svc -> W1; Svc -> W2; Svc -> W3;
W1 -> Stor; W2 -> Stor; W3 -> Stor;
}