Shopify to BigQuery order 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
Customers place orders on the Shopify store. The warehouse team picks and packs each order and hands it to the shipping carrier. Shopify order data syncs into BigQuery every night through Airbyte. Airflow runs the transformations, and the operations team tracks fulfillment times in a Looker Studio dashboard.
The diagram
What is in this flow
- Systems: Shopify, Airbyte, Airflow and Looker Studio Dashboard.
- Data stores: BigQuery.
- People and teams: Warehouse Team, Shipping Carrier and Operations Team.
- Size: 9 steps and 8 connections.
Mermaid code
Copy this into any Markdown file, GitHub README, or Mermaid Live to render the same flow.
flowchart TD
n1(["Customers")]
n2{{"Shopify"}}
n3("Warehouse Team")
n4("Shipping Carrier")
n5[("BigQuery")]
n6{{"Airbyte"}}
n7{{"Airflow"}}
n8("Operations Team")
n9{{"Looker Studio Dashboard"}}
n1 -->|places orders| n2
n2 -->|receives order| n3
n3 -->|hands to carrier| n4
n2 -->|syncs nightly via Airbyte| n6
n6 -->|loads into BigQuery| n5
n7 -->|transforms data| n5
n5 -->|feeds dashboard| n9
n8 -->|tracks in dashboard| n9Map 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.