At ingestion or processing time, stored procedures can transactionally perform lookups and queries as data is coming into the system, allowing for richer writes at scale.
global transactional reads can trigger events, support dashboards and even live decisioning on immediate data.