view: int_dbt_prod_agg_awa_model {                                                 #view_name
  sql_table_name:  INTELLIGENCE.DBT_PROD.AGG_AWA_MODEL ;;                          #snowflake_table_name

  dimension_group: activity_date {
    view_label: "Date"                                                             #Label name containing Dimensions and measure
    label: "Activity"
    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]
  }

  dimension: isrc {
    view_label: "Track"                       #Label name containing Dimensions and measure
    label: "ISRC"                             #Dimension name
    type:  string
    sql: ${TABLE}.isrc ;;                     #Col mapping name in snowflake
  }
  dimension: country_code {
    view_label: "Country Code"                       #Label name containing Dimensions and measure
    label: "Country Code"                             #Dimension name
    type:  string
    hidden: yes
    sql: ${TABLE}.country_code ;;                     #Col mapping name in snowflake
  }

  dimension: Track_ID {
    view_label: "Track"                       #Label name containing Dimensions and measure
    label: "Track ID"                         #Dimension name
    type:  string
    sql: ${TABLE}.track_id ;;                 #Col mapping name in snowflake
  }

  dimension: Track_Name {
    view_label: "Track"                       #Label name containing Dimensions and measure
    label: "Track Name"                      #Dimension name
    type:  string
    sql: ${TABLE}.track_name ;;               #Col mapping name in snowflake
  }

  dimension: Track_Artist {
    view_label: "Track"                       #Label name containing Dimensions and measure
    label: "Track Artist"                    #Dimension name
    type:  string
    sql: ${TABLE}.track_artist ;;             #Col mapping name in snowflake
  }

  dimension: upc {
    view_label: "Release"                     #Label name containing Dimensions and measure
    label: "UPC"                              #Dimension name
    type:  string
    sql: ${TABLE}.upc ;;                      #Col mapping name in snowflake
  }

  dimension: release_name {
    view_label: "Release"                     #Label name containing Dimensions and measure
    label: "Release Name"                     #Dimension name
    type:  string
    sql: ${TABLE}.release_name ;;             #Col mapping name in snowflake
  }

  dimension: release_artist {
    view_label: "Release"                     #Label name containing Dimensions and measure
    label: "Release Artist"                   #Dimension name
    type:  string
    sql: ${TABLE}.release_artist ;;           #Col mapping name in snowflake
  }

  dimension: label_id {
    view_label: "Label"
    label: "Label ID"
    type: number
    sql: ${TABLE}.label_id ;;
    value_format: "0"
  }

  measure:  units{
    view_label: "Units"
    label: "Units"
    type:  sum
    sql:  ${TABLE}.streams ;;
  }




}