Table: dim_customer_contact

Type: Dimension Columns: 10

Description

Customer contact information. The data grain is contacts within customer.

Columns

Column Name Type Description
customer_id string

Unique identifier for the customer

contact_last_name string

The last name of the contact

contact_first_name string

The first name of the contact

contact_type string

The type of contact; enumerated: 'Primary' or 'Non-Primary'

email string

The email of the contact

primary_phone string

The primary phone number of the contact

account_status string

The status of the account; enumerated: 'Account' or 'No Account'

business_id string

Unique identifier for the business

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.