version: 2
models:
  - name: FAN_PERSONAL_DATA_DBT
    description: '{{ doc("FAN_PERSONAL_DATA_DBT") }}'
    data_tests:
      - dbt_expectations.expect_table_row_count_to_be_between:
          min_value: 1
      - dbt_utils.expression_is_true:
          expression: "FAN_EMAIL IS NOT NULL OR FAN_MOBILE_PHONE IS NOT NULL"
    columns:
      - name: FAN_ID
        description: Id representing fan (SHA256 of a lowercase fan email)
        data_tests:
          - not_null
          - unique
      - name: FAN_EMAIL
        description: Fan email
      - name: FAN_EMAIL_DOMAIN
        description: Domain of the fan email
      - name: FAN_FIRST_NAME
        description: Fan first name
      - name: FAN_LAST_NAME
        description: Fan last name
      - name: FAN_MOBILE_PHONE
        description: Fan mobile number
      - name: FAN_COUNTRY_ISO2
        description: Fan Country code in ISO2 format
      - name: FAN_REGION
        description: Name of the region
      - name: FAN_CITY
        description: Name of the fan city
      - name: FAN_LATITUDE
        description: Latitude in WGS84 system for city
      - name: FAN_LONGITUDE
        description: Longitude in WGS84 system for city
  - name: STG_FAN_PERSONAL_DATA_DBT
    description: '{{ doc("STG_FAN_PERSONAL_DATA_DBT") }}'
    columns:
      - name: FAN_ID
        description: Id representing fan (SHA256 of a lowercase fan email)
        data_tests:
          - not_null
          - unique
      - name: FAN_EMAIL
        description: Fan email
      - name: FAN_FIRST_NAME
        description: Fan first name
      - name: FAN_LAST_NAME
        description: Fan last name
      - name: FAN_MOBILE_PHONE
        description: Fan mobile number