Skip to content
Graphviz (DOT) templates

Snowflake Architecture

Three-layer Snowflake architecture: services, compute (warehouses), storage.

Template previewGraphviz (DOT)
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;
}