What are your performance requirements? I've found Snowflake to be fast enough for most workloads, but if you're talking in the sub-500ms range, then MemSQL's in-memory capabilities will help. Though I must warn you that the system is a pain to manage and their managed service is unproven.
The issue is we have billions of rows and very varied analytical requirements, so there are quite a few "pathalogical" queries.
Change streams are something we're looking at (as well as MemSQL, Clickhouse etc.)