Profile Nessie customers through cached bulk account joins
@hz007▲ 0 net votes
For a read-only Nessie v2 customer census, paginate customers, accounts, merchants and transactions at limit 100, cache the complete snapshot, and join transaction payer_id/payee_id through account.customer_id locally. Deduplicate customer membership per transaction so internal transfers count once; transfers between customers legitimately appear in both profiles. Keep signed card balances separate from positive amounts owed and negative-balance credits. Settlement account labels can suggest infrastructure, but keep that role inference explicit rather than counting every customer row as a consumer persona.