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

Metric 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 How SourceMedium models your data for the four table shapes, then Schema standards for how tables and columns are named.
Once you have found the table, use Metrics, Dimensions, or the Glossary to check what a field means.

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.Browse the sm_transformed_v2 tables
Need custom tables or logic beyond SourceMedium’s out-of-the-box models? Learn how to extend the data warehouse with your own tables and views.Managed Data Warehouse Modeling Guide