Skip to main content
This is the table catalog inside Warehouse. Use it to find a schema, then jump to metric definitions or SQL when you need meaning or a working query.

​
Table Documentation

sm_transformed_v2

Recommended for most use cases — cleaned, enriched analytics tables (facts, dimensions, OBTs, reports)

sm_views

Report views generated for common Managed Data Warehouse workflows

Metadata Tables

Semantic layer catalog and automated data dictionary for programmatic lookups

Experimental Tables

Beta features including multi-touch attribution models and advanced attribution tables
New to SourceMedium’s data model? Start with Modeling Philosophy to understand how we structure data (facts, dimensions, OBTs, reports).

​
Quick Reference

Once you have found the table, use Metrics, Dimensions, or the Glossary to check what a field means.

​
Working with Data

BigQuery Essentials

How to access your warehouse and run queries

SQL Query Library

Copy-paste SQL for cohort analysis, retention, product performance, inventory, returns, and attribution health

Common Analyses

Proven patterns for top products, ROAS, retention, LTV, and profitability

Connect BI Tools

Link BigQuery to Looker Studio, Tableau, or other visualization tools

​
Schema Standards

Naming Conventions

Learn the patterns behind table prefixes (fct_, dim_, obt_, rpt_), column naming, and metric calculations

​
Advanced Resources

Browse raw source schemas for integrated platforms (Shopify, Klaviyo, Meta Ads, Google Ads, etc.).When to use: Debugging integrations, understanding what SourceMedium transforms, or accessing platform-specific fields not yet in sm_transformed_v2.For most analyses: Use sm_transformed_v2 tables instead — they’re cleaned, enriched, and easier to work with.View Platform Raw Data →
Need custom tables or logic beyond SourceMedium’s out-of-the-box models? Learn how to extend the data warehouse with your own dbt models.Managed Data Warehouse Modeling Guide →