Skip to content
Mermaid templates

ETL Pipeline

Extract → transform → load with quality gates and observability.

Template previewMermaid
Rendering…

Make it your own.

flowchart LR
S1[(Postgres)] --> Ext[Extract]
S2[(S3 events)] --> Ext
S3[(SaaS API)] --> Ext
Ext --> Land[(Raw / landing zone)]
Land --> Trans["Transform<br/>(dbt models)"]
Trans --> DQ{Data quality\ntests pass?}
DQ -- no --> Alert[Alert on-call]
DQ -- yes --> Mart[(Mart / warehouse)]
Mart --> BI[BI tools]
Mart --> ML[Feature store]
Mart --> Rev[Reverse ETL]