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

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

​
What Is A Managed Data Warehouse?

SourceMedium’s Managed Data Warehouse offering helps simplify data warehouse adoption, a table-stakes technology investment for businesses looking to establish a competitive advantage through data and advanced analytics. Once we’ve ingested data from the sources you’ve integrated, we run our transformation pipeline and deliver data into a managed data warehouse instance that you can access directly. Through this product, you’ll get: - Data quality: We’ve collaborated with hundreds of e-commerce merchants to refine our models and decision-making frameworks to ensure our data is accurate, reliable, and intuitive no matter the analytical use case. We also conduct over 2,500 data quality tests daily to help enforce our quality standards. - Time to value & predictability: We streamline your data infrastructure stack so you don’t have to manage a data pipeline, build models from the ground up, and navigate the unpredictability of billing, cost optimization, identity access management, security, performance, and more. - Future-proofing: As your data needs grow alongside your business, you’ll already have the infrastructural versatility and scalability in place to 10x your capabilities.

​
Activating Your Managed Data Warehouse

To kickstart your journey activating the data in your Managed Data Warehouse, we offer two primary pathways to get started.

​
Bootstrap your BI with our base templates

While you can connect your Managed Data Warehouse to any BI tool, our base data source and report templates are a great starting point for businesses looking to quickly gain insights without the need to build charts and tables from scratch. These templates are designed around our pre-configured semantic layer (see OBT table description), helping turbocharge BI developers and data analysts. Learn how to use our base data source and report templates in BI Tools.

​
Build models inside your warehouse

For businesses with custom analytics needs that our out-of-the-box semantic layer doesn’t address, you can build customized models directly in your Managed Data Warehouse. Learn how to extend SourceMedium’s models in Modeling with SourceMedium.