version: 2
models:
  - name: SONGWHIP_PRESAVE_PAGE_DBT
    description: '{{ doc("SONGWHIP_PRESAVE_PAGE_DBT") }}'
    data_tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - ID
            - VENDOR_ID
            - SUBACCOUNT_ID
            - GLOBAL_PARTICIPANT_ID
    columns:
      - name: ID
        data_tests:
          - not_null
      - name: NAME
        data_tests:
          - not_null
      - name: IMAGE
      - name: UPC
      - name: VENDOR_ID
        data_tests:
          - not_null
      - name: SUBACCOUNT_ID
        data_tests:
          - not_null
      - name: GLOBAL_PARTICIPANT_ID
        data_tests:
          - not_null
      - name: CREATED_AT
        data_tests:
          - not_null
  - name: SONGWHIP_PRESAVE_PAGE_FAN_DBT
    description: '{{ doc("SONGWHIP_PRESAVE_PAGE_FAN_DBT") }}'
    data_tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - FAN_ID
            - VENDOR_ID
            - SUBACCOUNT_ID
            - GLOBAL_PARTICIPANT_ID
            - ID
    columns:
      - name: FAN_ID
        data_tests:
          - not_null
      - name: VENDOR_ID
        data_tests:
          - not_null
      - name: SUBACCOUNT_ID
        data_tests:
          - not_null
      - name: GLOBAL_PARTICIPANT_ID
        data_tests:
          - not_null
      - name: ID
        description: ID representing Songwhip presave
        data_tests:
          - not_null
  - name: SONGWHIP_CUSTOM_PAGE_DBT
    description: '{{ doc("SONGWHIP_CUSTOM_PAGE_DBT") }}'
    data_tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - ID
            - VENDOR_ID
            - SUBACCOUNT_ID
            - GLOBAL_PARTICIPANT_ID
    columns:
      - name: ID
        data_tests:
          - not_null
      - name: NAME
        data_tests:
          - not_null
      - name: IMAGE
      - name: VENDOR_ID
        data_tests:
          - not_null
      - name: SUBACCOUNT_ID
        data_tests:
          - not_null
      - name: GLOBAL_PARTICIPANT_ID
        data_tests:
          - not_null
      - name: CREATED_AT
        data_tests:
          - not_null
  - name: SONGWHIP_CUSTOM_PAGE_FAN_DBT
    description: '{{ doc("SONGWHIP_CUSTOM_PAGE_FAN_DBT") }}'
    data_tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - FAN_ID
            - VENDOR_ID
            - SUBACCOUNT_ID
            - GLOBAL_PARTICIPANT_ID
            - ID
    columns:
      - name: FAN_ID
        data_tests:
          - not_null
      - name: VENDOR_ID
        data_tests:
          - not_null
      - name: SUBACCOUNT_ID
        data_tests:
          - not_null
      - name: GLOBAL_PARTICIPANT_ID
        data_tests:
          - not_null
      - name: ID
        description: ID representing Songwhip custom page
        data_tests:
          - not_null