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. Warehouse access comes from your workspace role, not from a Google Group. Google Groups share Looker Studio dashboards and Sheets that your team owns. In your SourceMedium workspace, Warehouse brings together your dedicated BigQuery project, Raw data, and Usage. Raw data lets Admins and Editors choose source tables for delivery; Usage shows Admins the compute reported in that project. The available tabs depend on your warehouse setup and role.

​
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, your SourceMedium connection supplies your project and dataset names. BI tools that accept a service account key can also use an admin-issued app credential from Dashboards & Apps on either plan. Access through your own Google account is part of Pro.

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

Choose raw tables

Choose source tables for sm_sources and follow their delivery status.

Warehouse usage

See reported compute by account and workload in a dedicated project.

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.

Metabase starter

Download an app key file from Dashboards & Apps and build an executive summary dashboard.

Modeling

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