view: nr_performance_nr_contribution_multi_row {
    derived_table: {
    sql:
      SELECT
        c.ID,
        f.value::string AS instrument,
        f.index AS instrument_position
      FROM FACTS.PROD.PERFORMANCE_NR_CONTRIBUTION c,
           LATERAL FLATTEN(input => c.INSTRUMENTS) f
    ;;
  }

  # 🔑 Important: this is NOT a true PK anymore (multiple rows per ID)
  dimension: contribution_id {
    label: "Contribution ID"
    type: string
    sql: ${TABLE}.ID ;;
  }

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

  dimension: instrument_position {
    type: number
    sql: ${TABLE}.INSTRUMENT_POSITION ;;
  }

  measure: count {
    type: count
  }
}