We make heavy use of views within Snowflake, have sensible cluster keying and, further downstream, also leverage things like Looker's PDTs and Elastic Search.
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.)
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.)