preview__dim_customer_code


Description

Dimension table containing customer codes (tags) used to categorize customers. Customer codes help organize and filter customers based on business-defined categories. Each customer code has a unique identifier and can be associated with multiple customers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_code_id int8 19 null

Unique identifier for the customer code (primary key)
name varchar 256 √ null

Display name of the customer code
description varchar 256 √ null

Detailed description of the customer code purpose and usage. Defaults to ‘UNKNOWN’ if not provided.
color_hex varchar 256 √ null

Hexadecimal color code for visual representation of the customer code in UI
active bool 1 √ null

Indicates if the customer code is currently active and available for use
archived bool 1 √ null

Indicates if the customer code has been archived and is no longer in regular use
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation