type: ODS
entity: Customer
layer: OperationalDatastore
schema: crm_ods
name: klant
columns: 
- name: KlantID
  primary_key: True
- name: Code
- name: Naam
- name: Actief
  data_type: BIT
track_history: True
flows: 
  crm:
    upstream:
    - schema: crm_stg
---
type: ODS
layer: OperationalDatastore
entity: Customer
schema: exact_ods
name: customer
columns: 
- name: CustomerID
  primary_key: True
- name: Code
- name: Name
- name: Active
  data_type: BIT
track_history: True
flows: 
  eol:
    upstream:
    - schema: eol_stg
---
type: HUB
entity: Customer
business_keys:
- name: Code
flows:
  crm: 
    upstream:
    - schema: crm_ods
      table: klant
  eol: 
    upstream:
    - schema: exact_ods
      table: customer
--- 
type: SAT
entity: Customer
name: Customer_CRM_SAT
additional_columns:
- name: KlantID
- name: Naam
- name: Actief
flows:
  crm:
    upstream:
    - schema: crm_ods
      table: klant
--- 
type: SAT
entity: Customer
name: Customer_EOL_SAT
additional_columns:
- name: CustomerID
- name: Name
- name: Active
flows:
  eol:
    upstream:
    - schema: exact_ods
      table: customer
---
type: CUST
layer: DATAVAULT
schema: bv_stg
entity: Customer
name: customer_incremental
storage: virtual
columns:
- name: Code
- name: Name
- name: Active
---
type: CUST
layer: DATAVAULT
schema: bv_stg
entity: Customer
name: customer_full
storage: virtual
columns:
- name: Code
- name: Name
- name: Active
---
type: SAT
entity: Customer
schema: bv
name: Customer_SAT
additional_columns:
- name: Name
- name: Active
flows:
  full: 
    load_types:
      full:
        enabled: True
    upstream:
    - schema: bv_stg
      table: customer_full
  incremental: 
    load_types:
      incremental:
        enabled: True
    upstream:
    - schema: bv_stg
      table: customer_incremental
---
type: DIM
entity: Customer
storage: virtual
columns:
- name: Customer HK
  primary_key: True
- name: Code
- name: Name
- name: Active