version: 2

models:

  - name: DOWNLOADS_BY_PARTICIPANT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_DBT
    description:
      A table containing number of downloads for global participants on a date / country / feedid level
    tests:
      - unique:
          column_name: "concat(global_participant_id, '-', download_activity_date, '-', country_code, '-', feed_id, '-', distributor)"
    columns:
      - name: global_participant_id
        tests:
          - not_null
      - name: download_activity_date
        tests:
          - not_null
      - name: country_code
      - name: feed_id
        tests:
          - not_null
      - name: distributor
        tests:
          - not_null
      - name: store_id
        tests:
          - not_null
      - name: product_id
        tests:
          - not_null
      - name: isrc
        tests:
          - not_null
      - name: downloads
        tests:
          - not_null