view: int_dbt_prod_agg_tencent_model {
  sql_table_name:INTELLIGENCE.DBT_PROD.AGGREGATED_TENCENT_STOREFRONT_MODEL;;

  dimension: labelid {
    label: "Label ID"
    view_label: "Label"
    type: number
    hidden: yes
    sql: ${TABLE}.LABELID ;;
  }

  dimension: labelname {
    label: "Label Name"
    view_label: "Label"
    type: string
    hidden: yes
    sql: ${TABLE}.LABELNAME ;;
  }

  dimension: label_manager {
    label: "Label Manager"
    view_label: "Label"
    type: string
    hidden: yes
    sql: ${TABLE}.LABEL_MANAGER ;;
  }

  dimension: artistid {
    label: "Artist ID"
    view_label: "Artist"
    type: number
    sql: ${TABLE}.ARTISTID ;;
  }

  dimension: artist_name {
    label: "Artist Name"
    view_label: "Artist"
    type: string
    sql: ${TABLE}.ARTIST_NAME ;;
  }

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

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

  dimension_group: releasedate {
    label: "Release"
    view_label: "Release"
    type: time
    timeframes: [raw, date, week, month, year]
    sql: ${TABLE}.RELEASEDATE ;;
  }

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

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

  dimension_group: download_date {
    label: "Activity"
    type: time
    timeframes: [date, week, month, year]
    sql: ${TABLE}.DOWNLOAD_DATE ;;
  }

  dimension: licensor {
    label: "Licensor"
    hidden: yes
    type: string
    sql: ${TABLE}.LICENSOR ;;
  }

  dimension: store {
    label: "Store Name"
    type: string
    sql: ${TABLE}.STORE ;;
  }

  dimension: country_code {
    label: "Country Code"
    type: string
    sql: ${TABLE}.COUNTRY_CODE ;;
  }

  measure: stream {
    label: "Stream"
    type: sum
    sql: ${TABLE}.STREAM ;;
  }
}