view: dt_spotify_track_audio_features {

  derived_table: {
    sql:
    with ISRC_1 as (
select
    {% parameter isrc_1 %} as isrc

      ),

      ISRC_2 as (
      select
      {% parameter isrc_2 %} as isrc

      ),

      user_inputs as (
      select
      isrc as isrc,
      'isrc1' as isrc_no

      from ISRC_1

      union

      select
      isrc as isrc,
      'isrc2' as isrc_no

      from ISRC_2
      )

      select
      ui.isrc_no,
      af.*

      from INTELLIGENCE.DBT_PROD.SPOTIFY_TRACK_AUDIO_FEATURES af
      inner join user_inputs ui on af.isrc = ui.isrc

      ;;

  }

  parameter: isrc_1 {
    type: string
  }

  parameter: isrc_2 {
    type: string
  }


}