dim_order_lines - SourceMedium

Pro warehouses only. This table is not delivered on Foundation warehouses. On Foundation, start from obt_order_lines. See Foundation and Pro.

Order line dimension for product-level attributes at line grain.

Grain: One row per sm_order_line_key. No canonical date; _synced_at is a freshness timestamp (not for analysis).
Filters to start with: source_system for platform-specific line-item coverage.
Joins: dim_orders via sm_order_key (many:1); dim_product_variants via sm_product_variant_key (many:1).

Columns

Column	Type	Description
`sm_order_key`	STRING	Stable SourceMedium order key. Unique per order. Key joins: `obt_order_lines` (1:many via `sm_order_key`); `dim_customers` (many:1 via `sm_customer_key`). Platform caveat: TikTok Shop coverage may be limited.
`sm_order_line_key`	STRING	Stable SourceMedium order line key. Unique per line. Key joins: `dim_order_lines` (1:1); `dim_orders` (many:1 via `sm_order_key`). Platform caveat: TikTok Shop coverage may be limited.
`sm_product_key`	STRING	Stable SourceMedium join key for products to related tables.
`sm_product_variant_key`	STRING	Stable SourceMedium join key for product variants to related tables.
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`order_line_id`	STRING	The ID of the order line.
`order_line_price`	FLOAT64	The price of a single unit of the product at the time of purchase (before line-level discounts). Multiply by order_line_quantity to get total line revenue.
`order_line_product_title`	STRING	The title of the product that the order line represents.
`order_line_product_variant_title`	STRING	The title of the product variant that the order line represents. For Shopify workspaces on the v3 (GraphQL) feed, a deleted product leaves the line’s variant reference null, so the current catalog can no longer supply the title. It is then parsed from the order-time line name, which Shopify formats as “{product title} - {variant title}”. The current catalog title always wins where it still exists, so renamed variants read consistently with the rest of the catalog. Null where the product has only a single default variant, since no variant title exists to record.
`order_line_quantity`	NUMERIC	The number of units of the product variant ordered in this line item. Used to calculate total line revenue (order_line_price * order_line_quantity).
`product_id`	STRING	Platform-specific product identifier from the source system. Links to the parent product that this line item’s variant belongs to.
`product_variant_id`	STRING	A unique identifier for the product variant generated by the source system.
`sku`	STRING	The stock keeping unit (SKU) of the product variant.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.