version: 2

models:

  - name: DOWNLOADS_BY_PRODUCT_TRACK_COUNTRY_FEED_DISTRIBUTOR_DAILY_DBT
    description:
      A table containing number of downloads metrics for product tracks on a
      date / country / feedid level
    tests:
      - unique:
          column_name: "concat(product_id, '-', track_id, '-', download_activity_date, '-', country_code, '-', feed_id, '-', distributor)"
    columns:
      - name: product_id
        tests:
          - not_null
      - name: track_id
        tests:
          - not_null
      - name: download_activity_date
        tests:
          - not_null
      - name: feed_id
        tests:
          - not_null
      - name: country_code
      - name: distributor
        tests:
          - not_null
      - name: store_id
        tests:
          - not_null
      - name: downloads
        tests:
          - not_null