view: anr_plays {
  derived_table: {
    sql: select S.artist, S.CURRENT_PLAYS_COUNT
      as "Plays" from TABLE({% parameter soundcloud_table_name %}) S;;
  }

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

  dimension: plays {
    type: number
    sql: ${TABLE}."Plays";;
  }

  parameter: soundcloud_table_name {
    type: string
    view_label: "SoundCloud Table"
    default_value: "FACTS.PROD.SOUNDCLOUD_STATISTICS"
  }
}

view: anr_views {
  derived_table: {
    sql: select Y.artist, Y.CURRENT_VIEWS_COUNT
      as "Views" from TABLE({% parameter youtube_table_name %}) Y;;
  }

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

  dimension: views {
    type: number
    sql: ${TABLE}."Views";;
  }

  parameter: youtube_table_name {
    type: string
    view_label: "YouTube Table"
    default_value: "FACTS.PROD.YOUTUBE_STATISTICS"
  }
}