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

Hexagons are systems. Cylinders are data stores. Diamonds are decisions. Rounded orange boxes are people and teams. A dashed amber arrow is a link the AI inferred. Pink arrows are decision branches. Blue arrows move data.

Open this diagram in Wavelength

Opens an editable copy you can change by voice or by hand. Free account, no card.

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| n9

Map 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.

Start free Try the live demo

Every new account starts with 7 days of Pro. No card needed.

Flow diagram examples: all 37 worked process and data flow diagrams
Order to cash process: a finance flow example
Procure to pay process: a procurement flow example
Employee onboarding: an HR flow example
Invoice approval workflow: an approval flow example
Support ticket escalation: a support flow example
Flowchart template: copy, edit, and make your own
For business analysts: capture an as-is process in swimlanes
Live demo: describe a process and see the flow, no account needed

More examples

Stripe billing data to a data warehouseFlow diagram example Postgres to Snowflake with AirbyteFlow diagram example Marketing attribution data pipelineFlow diagram example

See all flow diagram examples