Skip to main content
This is the front door for warehouse work. Start with access and sm_transformed_v2, then use table docs and definitions when a number needs explaining.

​
Foundation and Pro

SourceMedium delivers the warehouse on one of two plans. The difference is which tables land, not which numbers are right. The same models build both plans, so a metric that exists on Foundation is computed identically on Pro.

​
What Pro adds

Seventeen tables are Pro only. Each of their pages says so at the top.
  • The dimension suite: dim_orders, dim_order_lines, dim_customers, dim_customer_addresses, dim_order_discounts, dim_order_taxes, dim_order_shipping_lines
  • Subscriptions: dim_subscriptions, dim_subscribers, obt_subscriptions, obt_subscription_charges, fct_subscription_charges, rpt_subscriptions_performance_daily, rpt_subscription_signup_cohort_retention
  • Orders: fct_orders_placed
  • Media mix: obt_media_mix_performance, rpt_media_mix_channel_daily
On Foundation, start from the obt_* table that covers the same ground. obt_orders and obt_order_lines carry the order and line attributes the dim_* tables expose, already joined.
dim_product_variants is delivered on both plans, so a missing dimension does not by itself mean Foundation. Check the list above.
SQL examples in these docs use your_project.sm_transformed_v2. On Foundation, pick the dataset prefixed with your store name in BigQuery Explorer.

BigQuery essentials

Find your project, pick the right table, and run a first query.

Table docs

Customer-facing sm_transformed_v2 schemas.

How numbers are defined

Revenue, valid orders, reporting currency, and related rules.

SQL query library

Copy-paste queries for common analyses.

​
Go further

BI templates

Copy the Looker Studio templates built on the obt_* tables.

Other BI tools

Connect Tableau, Power BI, Metabase, or any tool that reads BigQuery.

Modeling

Build your own tables and views on top of SourceMedium’s.