view: cm_raw_data_spotify {
  sql_table_name: chartmetric.raw_data.spotify ;;

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

  dimension: spotify_track_id {
    type: string
    hidden: no
    sql: ${TABLE}.spotify_track_id ;;
  }

  dimension: spotify_album_id {
    type: string
    hidden: no
    sql: ${TABLE}.spotify_album_id ;;
  }

  dimension: spotify_artist_id {
    type: string
    hidden: yes
    sql: ${TABLE}.spotify_artist_id ;;
  }

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

  dimension: album_name {
    label: "Album Name"
    type: string
    hidden: yes
    sql: ${TABLE}.album_name ;;
    view_label: "Spotify"
  }

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

  dimension: artwork_url {
    type: string
    hidden: yes
    sql: ${TABLE}.artwork_url ;;
  }

  dimension: popularity_score {
    label: "Track Popularity"
    type: number
    hidden: no
    sql: ${TABLE}.popularity_score ;;
    view_label: "Spotify"
  }

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

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