view: anr_shazam_tracks_top_weekly_shazams {
  derived_table: {
    sql: select ARTIST, WEEKLY_CHANGE_IN_SHAZAMS, TRACK_TITLE from TABLE({% parameter shazam_table_name %})
      QUALIFY row_number() OVER (partition by ARTIST order by WEEKLY_CHANGE_IN_SHAZAMS desc) = 1;;
  }

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

  dimension: shazams {
    type: number
    sql: ${TABLE}.WEEKLY_CHANGE_IN_SHAZAMS;;
  }

  dimension: title {
    type: string
    sql: ${TABLE}.TRACK_TITLE;;
  }

  parameter: shazam_table_name {
    type: string
    view_label: "Shazam Table"
    default_value: "FACTS.PROD.SHAZAM_TRACKS_STATISTICS"
  }
}

view: anr_shazam_tracks_spike_song {
  derived_table: {
    sql: select ARTIST, ROUND(100 * PERCENTAGE_CHANGE_SHAZAMS, 2) AS PERCENTAGE_CHANGE_SHAZAMS, TRACK_TITLE from TABLE({% parameter shazam_table_name %})
      QUALIFY row_number() OVER (partition by ARTIST order by PERCENTAGE_CHANGE_SHAZAMS desc) = 1;;
  }

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

  dimension: percentage {
    type: number
    sql: ${TABLE}.PERCENTAGE_CHANGE_SHAZAMS;;
  }

  dimension: title {
    type: string
    sql: ${TABLE}.TRACK_TITLE;;
  }

  parameter: shazam_table_name {
    type: string
    view_label: "Shazam Table"
    default_value: "FACTS.PROD.SHAZAM_TRACKS_STATISTICS"
  }
}