view: int_dbt_prod_agg_wynk_model {
  sql_table_name: INTELLIGENCE.DBT_PROD.AGG_WYNK_MODEL ;;

  dimension: ROW_ID {
    label: "Row Id"
    type:  string
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.ROW_ID ;;

  }

  dimension_group: DOWNLOAD_ACTIVITY_DATE {
    view_label: "Date"
    label: "Activty"
    type:  time
    sql: ${TABLE}.DOWNLOAD_ACTIVITY_DATE ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
    description: "Date when the activity occured"
  }

  dimension: TRACK_ID {
    view_label: "Track"
    label: "Track ID"
    type:  string
    sql: ${TABLE}.TRACK_ID ;;
    description: "ID of the Track as provided by the store"
  }

  dimension: isrc {
    view_label: "Track"
    label: "ISRC"
    type:  string
    sql: ${TABLE}.isrc ;;
    description: "ISRC"
  }

  dimension: TRACK_NAME {
    view_label: "Track"
    label: "Track Name"
    type:  string
    sql: ${TABLE}.TRACK_NAME ;;
    description: "Track Name"
  }

  dimension: RELEASE_NAME {
    view_label: "Release"
    label: "Release Name"
    type:  string
    sql: ${TABLE}.RELEASE_NAME ;;
    description: "Release Name"
  }

  dimension: ARTIST_NAME {
    view_label: "Artist"
    label: "Artists"
    type:  string
    sql: ${TABLE}.ARTIST_NAME ;;
    description: "Artist Names associated with the track as reported by the store"
  }

  dimension: RELEASE_ID {
    view_label: "Release"
    label: "Release ID"
    type:  string
    sql: ${TABLE}.RELEASE_ID ;;
    description: "ID associated with the Release as provided by the store"
  }

  measure: STREAMS {
    view_label: "Track"
    label: "Streams"
    type: sum
    sql: ${TABLE}.STREAMS ;;
    description: "Streams"
  }

  dimension: COUNTRY_CODE {
    view_label: "Transaction Country"
    label: "Country Code"
    type:  string
    hidden: yes
    sql: ${TABLE}.COUNTRY_CODE ;;
    description: "Transaction Country code"
  }

  dimension: UPC {
    view_label: "Release"
    label: "UPC"
    type:  string
    sql: ${TABLE}.UPC ;;
    description: "UPC"
  }

  dimension: LABEL_ID {
    view_label: "Label"
    label: "Label ID"
    type:  string
    sql: ${TABLE}.LABEL_ID ;;
    description: "Label ID"
  }

  dimension: LANGUAGE {
    view_label: "Track"
    label: "Language Code"
    type:  string
    sql: ${TABLE}.LANGUAGE ;;
    description: "Language Code associated with a track (as reported by the store)"
  }

}