Salesforce to Snowflake with Fivetran and dbt diagram
This is a worked example. Wavelength built the diagram below from the description on this page. Nobody drew it by hand.
What was said
Account executives update opportunities in Salesforce. Fivetran pulls Salesforce objects into the Snowflake raw schema every hour. dbt runs staging models, then runs tests. If the dbt tests fail, dbt posts an alert to the data team Slack channel. If they pass, dbt builds the revenue mart, and finance reads it in Looker for the forecast.
The diagram
What is in this flow
- Systems: Salesforce, Fivetran, dbt, Looker and Data Team Slack Channel.
- Data stores: Snowflake Raw Schema and Revenue Mart.
- People and teams: Account Executives and Finance.
- Decisions: dbt tests pass?.
- Size: 10 steps and 10 connections.
Questions to confirm
The AI inferred these links. On a real call, you ask the customer to confirm them.
- Does dbt tests pass? No (tests fail) Data Team Slack Channel?
- Does dbt tests pass? Yes (tests pass) Revenue Mart?
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1("Account Executives")
n2{{"Salesforce"}}
n3{{"Fivetran"}}
n4[("Snowflake Raw Schema")]
n5{{"dbt"}}
n6{"dbt tests pass?"}
n7[("Revenue Mart")]
n8{{"Looker"}}
n9("Finance")
n10{{"Data Team Slack Channel"}}
n1 -->|updates opportunities| n2
n3 -->|loads Salesforce objects hourly| n4
n5 -->|reads raw schema| n4
n5 -->|runs tests| n6
n6 -.->|No (tests fail)| n10
n5 -->|posts alert| n10
n6 -.->|Yes (tests pass)| n7
n5 -->|builds revenue mart| n7
n7 -->|feeds data| n8
n9 -->|reads forecast| n8Map your own process
Describe your version out loud, or paste the transcript of a call. Wavelength draws the flow as you talk, and you can edit it by voice, by prompt, or by hand.
Every new account starts with 14 days of Pro. No card needed.