view: anr_youtube_subscribers {
  derived_table: {
    sql: select artist, CURRENT_SUBSCRIBERS_COUNT as "Subscribers"
      from TABLE({% parameter stats_table_name %});;
  }

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

  dimension: youtube_subscribers {
    type: number
    sql: ${TABLE}."Subscribers";;
  }

  parameter: stats_table_name {
    type: string
    view_label: "Table Name"
    default_value: "FACTS.PROD.YOUTUBE_STATISTICS"
  }
}