Skip to content

CAP-063 — Proactive financial insight engine

Category Intelligence & automation (platform)
Business goal BG-003
Satisfying modules MOD-039 Customer analytics · MOD-040 Customer health score
Mode AUTO
BD owner BD01 Customer
Human needed No

The Snowflake analytics layer that computes personalised insight signals for every customer on a per-signal refresh cadence — idle cash detection, spend anomaly scores, FX rate opportunity signals, and product recommendations. Results are pre-computed into Snowflake presentation tables and served to the app via the Snowflake read API (ADR-038 Tier 3). Insights never enter Postgres — the app reads them directly from Snowflake via a dedicated API layer at 150–400ms per query. See ADR-038 for the tier classification and ADR-019 for the home screen architecture.