version: 2

models:

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