dim_customer_addresses - SourceMedium

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

Customer address dimension for enriching customers and orders with normalized geo attributes.

Grain: One row per sm_customer_address_key. No canonical date; _synced_at is a freshness timestamp (not for analysis).
Filters to start with: source_system for platform coverage and address availability; is_default_address_for_customer for primary address.
Joins: dim_customers via sm_customer_key (many:1).

Columns

Column	Type	Description
`sm_customer_address_key`	STRING	The unique address key created by SourceMedium that can be used to join address dimensions to related tables.
`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.
`address_id`	STRING	The unique identifier for the address.
`customer_address_city`	STRING	The city the customer’s location is in.
`customer_address_country`	STRING	The country the customer’s location is in.
`customer_address_country_code`	STRING	The two-letter code (ISO 3166-1 format) for the country of the customer’s location.
`customer_address_province`	STRING	The province, state, or district code of the customer’s location.
`customer_address_province_code`	STRING	The province, state, or district code (ISO 3166-2 alpha-2 format) of the customer’s location.
`customer_address_zip_code`	STRING	The postal code of the customer’s location.
`customer_id`	STRING	Platform-specific customer identifier from the source system. Links to the customer who owns this address.
`customer_street_address`	STRING	The customer’s street address.
`is_default_address_for_customer`	BOOL	Boolean indicating whether this address is the default/primary address for the customer. Used to identify the customer’s preferred address for shipping and billing.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.