view: anr_spotify_monthly_listeners {
  derived_table: {
    sql: select artist, MONTHLY_LISTENERS as "Monthly Listeners"
      from TABLE({% parameter spotify_table_name %});;
  }

  dimension: artist {
    type: string
    sql: ${TABLE}.ARTIST;;
  }

  dimension: spotify_release {
    type: string
    sql: ${TABLE}."Monthly Listeners";;
  }

  parameter: spotify_table_name {
    type: string
    view_label: "Table Name"
    default_value: "FACTS.PROD.SPOTIFY_STATISTICS"
  }
}