HubSpot to Snowflake data pipeline 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
New leads come in through HubSpot forms. HubSpot scores each lead. If the score is 60 or higher, the SDR team books a discovery call, otherwise the lead goes into a nurture email sequence. Every night Fivetran syncs HubSpot contacts and deals into Snowflake. dbt models the raw tables into a pipeline mart, and the revenue operations team reads the mart in Tableau.
The diagram
What is in this flow
- Systems: HubSpot Forms, HubSpot, Nurture Email Sequence, Fivetran, dbt and Tableau.
- Data stores: Snowflake.
- People and teams: SDR Team and Revenue Operations Team.
- Decisions: Score >=60?.
- Size: 11 steps and 10 connections.
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1(["New Leads")]
n2{{"HubSpot Forms"}}
n3{{"HubSpot"}}
n4{"Score >=60?"}
n5("SDR Team")
n6{{"Nurture Email Sequence"}}
n7{{"Fivetran"}}
n8[("Snowflake")]
n9{{"dbt"}}
n10("Revenue Operations Team")
n11{{"Tableau"}}
n1 -->|submitted| n2
n2 -->|scores| n3
n3 -->|score| n4
n4 -->|Yes| n5
n4 -->|No| n6
n3 -->|sync nightly| n7
n7 -->|loads contacts & deals| n8
n8 -->|models raw tables| n9
n9 -->|provides mart| n10
n10 -->|reads mart| n11Map 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.