view: int_dbt_prod_cm_spotify_artist_stat_clean {
  sql_table_name: intelligence.dbt_prod.stg_cm_spotify_artist_stat_clean ;;

  dimension: id {
    type: number
    hidden: yes
    sql: ${TABLE}.id ;;
  }

  dimension: spotify_artist {
    type: number
    description: "Chartmetrics Spotify Artist ID used to join with other Chartmetric Data (i.e cm_raw_data_spotify_artist.id)."
    hidden: yes
    sql: ${TABLE}.spotify_artist ;;
  }

  dimension: spotify_followers {
    type: number
    description: "The artists latest Spotify follower count."
    sql: ${TABLE}.followers ;;
    group_label: "Spotify Stats"
  }

  dimension: spotify_popularity {
    type: number
    description: "The artists latest Spotify popularity score."
    sql: ${TABLE}.popularity ;;
    group_label: "Spotify Stats"
  }

  dimension: spotify_monthly_listeners{
    type: number
    description: "The artists latest Spotify monthly listener count."
    sql: ${TABLE}.monthly_listeners ;;
    group_label: "Spotify Stats"
  }

  dimension: timestamp {
    type: date
    description: "The timestamps that Spotify Stats were updated by Chartmetric (i.e followers, popularity, monthly listeners)."
    group_label: "Spotify Stats"
  }

 }