view: master_discography_export_reduced {
  derived_table: {
    sql:
      SELECT
        sr.id NR_ID,
        sr.isrc ISRC,
        sr.main_artist Main_artist,
        sr.recording_title,
        sr.version,
        sr.external_id
        from FACTS.prod.performance_nr_sound_recording sr;;
  }

  dimension: NR_ID {
    type: string
    sql: ${TABLE}.NR_ID ;;
  }

  dimension: Primary_Artist_Displayed_As {
    type: string
    sql: ${TABLE}.Main_artist ;;
  }

  dimension: Recording_Title {
    type:  string
    sql: ${TABLE}.recording_title ;;
  }

  dimension: Recording_Version {
    type:  string
    sql: ${TABLE}.version ;;
  }

  dimension: ISRC {
    type:  string
    sql: ${TABLE}.ISRC ;;
  }

  dimension: Sax_Rec_ID {
    type:  string
    sql: ${TABLE}.external_id;;
  }
}