view: int_dbt_prod_agg_snapchat_model {
  sql_table_name: INTELLIGENCE.DBT_PROD.AGG_SNAPCHAT_MODEL ;;

  dimension: label_id {
    type: number
    view_label: "Label"
    label: "Label ID"
    description: "label ID"
    sql: ${TABLE}.labelid ;;
    primary_key: yes
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    description: "label name"
    sql: ${TABLE}.labelname ;;
  }

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

  dimension: label_manager {
    type: string
    view_label: "Label"
    label: "Primary Relationship Manager"
    sql: ${TABLE}.label_manager ;;
  }

  dimension: upc {
    type: string
    view_label: "Release"
    label: "UPC"
    description:"Universal Product Code (UPC)"
    sql: ${TABLE}.upc ;;
  }

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

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

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

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

  dimension: release_id {
    view_label: "Release"
    label: "Release ID"
    type: number
    sql: ${TABLE}.releaseid;;
  }

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

  dimension_group: release {
    view_label: "Release"
    type: time
    description: "Original date of release"
    timeframes: [date, day_of_week, week_of_year, week, month, year]
    sql: ${TABLE}.releasedate ;;
    convert_tz: no
  }

  dimension_group: stream_date {
    type: time
    view_label: "Stream"
    description: "Date of stream"
    timeframes: [date, day_of_week, week_of_year, week, month, year]
    sql: ${TABLE}.stream_date ;;
    convert_tz: no
  }

  dimension: country_code {
    view_label: "Country"
    label: "Country Code"
    description: "ISO Code for each country"
    type: string
    map_layer_name: countries
    sql: ${TABLE}.country_code ;;
  }

  dimension: Country_name{
    view_label: "Country"
    label: "Country Name"
    type: string
    sql:${TABLE}.country_name;;
  }

  measure: views {
    type: sum
    view_label: "Views"
    label: "Views"
    description: "Total no of views"
    sql: ${TABLE}.views ;;
  }

  measure: creations {
    type: sum
    view_label: "Creations"
    label: "Creations"
    description: "Total no of Creations"
    sql: ${TABLE}.creations ;;
  }


}