dim_campaign


Description

Campaign dimension

Columns

Column Type Size Nulls Auto Default Children Parents Comments
campaign_id int8 19 null
dim_contract_voucher_definition.campaign_id erp_v2_dim_contract_voucher_definition_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_de47ec642bb7 R
fct_contract_voucher.campaign_id erp_v2_fct_contract_voucher_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_00f5f09da640 R
fct_lead_lifetime.campaign_id erp_v2_fct_lead_lifetime_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_791cdefd0cec R

Primary key for campaign
name varchar 256 √ null

Campaign name
description varchar 65535 √ null

Campaign description. Null values are replaced with ‘UNKNOWN’. Truncated to 250 characters.
external_identifier varchar 256 √ null

External identifier for the campaign
archived bool 1 √ null

Permanently removed but kept for historic relations
created_date_time timestamptz 35 √ null

Timestamp when the campaign was created
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