view: orch_app_ar_instrument{
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.instrument ;;

  dimension: instrument_id {
    label: "Instrument ID"
    type: number
    sql: ${TABLE}.instrument_id ;;
    primary_key: yes
    hidden: yes
  }

  dimension: instrument {
    label: "Instrument"
    type: string
    sql: ${TABLE}.instrument ;;
  }

  dimension: instrument_check {
    label: "Instrument Check"
    type: string
    sql: iff(${TABLE}.instrument IS NOT NULL, 'Have', 'Needed') ;;
  }
}