Nightly ELT pipeline template

Components in this data flow diagram

• Salesforce
• Fivetran
• Postgres OLTP
• S3 event files
• Snowpipe
• Snowflake RAW
• Airflow schedule
• dbt build
• Staging models
• dbt tests pass?
• Alert data team
• Fix model
• Snowflake MARTS
• Looker
• Reverse ETL to CRM
• Data catalog & lineage

How to use this data flow diagram template

1. Click Open in the editor. The data flow diagram opens on a new page in FlowDiagram — nothing is uploaded and there is no sign-up.
2. Rename, add or delete shapes and drag them where you want; connectors stay attached as things move.
3. Drop in vendor logos from the library — 1,160 of them, including every AWS, Azure and Google Cloud service icon — or restyle it with the colour and theme controls.
4. Prefer text? Edit the Mermaid source below and paste it in through ☰ → Import diagram (see the Mermaid editor); it imports as an editable diagram.
5. Export to PNG, SVG or PDF, or press Ctrl+L for a link that carries the whole diagram.

Mermaid source

The whole template is the text below. Paste it into FlowDiagram, keep it in Git next to the code it describes, or hand it to an AI assistant to extend.

flowchart LR
  SF[Salesforce] --> FV[Fivetran]
  PG[(Postgres OLTP)] --> FV
  S3[(S3 event files)] --> SNOW[Snowpipe]
  FV --> RAW[(Snowflake RAW)]
  SNOW --> RAW
  RAW --> SCHED[Airflow schedule]
  SCHED --> DBT[dbt build]
  DBT --> STG[(Staging models)]
  STG --> TEST{dbt tests pass?}
  TEST -->|No| AL[Alert data team]
  AL --> FIX[Fix model]
  FIX --> DBT
  TEST -->|Yes| MART[(Snowflake MARTS)]
  MART --> LK[Looker]
  MART --> REV[Reverse ETL to CRM]
  MART --> CAT[Data catalog & lineage]

Related: Data pipeline diagram tool · Mermaid editor · All data pipelines & etl templates · All 521 templates