How to Detect Lateral Movement with Streaming SQL

Detect lateral movement in real time by ingesting authentication logs from Kafka into RisingWave, then running a SQL materialized view that counts distinct destination hosts per source account inside a session window. When the count crosses a thresho...