dim_order_shipping_lines - SourceMedium

Pro warehouses only. This table is not delivered on Foundation warehouses. See Foundation and Pro.

Order shipping line dimension for shipping method and cost details at line-level.

Grain: One row per sm_shipping_line_key. No canonical date; _synced_at is a freshness timestamp (not for analysis).
Filters to start with: source_system for platform-specific shipping representation.
Joins: dim_orders via sm_order_key (many:1); dim_order_lines via sm_order_line_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_shipping_line_key`	STRING	The unique shipping line key created by SourceMedium that can be used to join shipping line dimensions 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_id`	STRING	Platform order identifier. Not globally unique across stores; pair with `sm_store_id` and `source_system` when needed for scoping.
`order_shipping_line_id`	STRING	The ID that represents the shipping details for a customer’s order.
`order_shipping_line_shipping`	NUMERIC	The shipping cost amount for this specific shipping line item. Represents the individual shipping charge when multiple shipping methods are used.
`order_shipping_line_title`	STRING	The title of the shipping line (e.g., 2-3 Day Shipping, Economy Shipping).
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.