dim_customers - SourceMedium

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

Customer dimension with stable keys and profile attributes for joining and segmentation.

Grain: One row per sm_customer_key.
Date field: customer_created_at.
Filters to start with: source_system for platform-specific coverage differences.
Joins: dim_orders via sm_customer_key (1:many).

Columns

Column	Type	Description
`sm_customer_key`	STRING	Stable SourceMedium customer key. Unique per customer. Key joins: `dim_customers` (1:1); `dim_orders`/`obt_orders` (1:many). Platform caveat: TikTok Shop coverage may be limited.
`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.
`customer_created_at`	TIMESTAMP	UTC timestamp when the customer was created.
`customer_email`	STRING	Customer email address (PII); see customer_email_hashed for privacy‑safe matching.
`customer_email_hashed`	STRING	SHA-256 hash of customer email address. Used for privacy-safe customer matching and analytics across systems without exposing PII.
`customer_first_name`	STRING	Customer’s first name as provided during account creation or checkout. May be null for guest checkouts or incomplete registrations.
`customer_id`	STRING	The ID of the customer who placed the order.
`customer_last_name`	STRING	Customer’s last name as provided during account creation or checkout. May be null for guest checkouts or incomplete registrations.
`customer_phone_number`	STRING	Customer’s phone number in platform-provided format (varies by source_system). May be NULL if not collected; formatting and country codes not standardized.
`customer_tags_csv`	STRING	Comma-separated list of all tags associated with a customer. Use for simple filtering; beware that individual tag values may contain commas.
`customer_updated_at`	TIMESTAMP	UTC timestamp when the customer was last modified.
`has_customer_consented_to_marketing`	BOOL	Whether the customer has consented to receive marketing communications.
`is_customer_email_verified`	BOOL	Whether the customer’s email has been verified.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.