Looking into getting near-realtime analytics data from bigquery, and considering costs vs. accuracy, it seems like using materialized view might be a great win.
Considering "near real time" will change to a minimum of 1 minute refresh_interval_minutes, my main concern is that while from documentation it seems that the query will be only on the delta data, the billing will be on the "standard" minimum of 10MB per table.
As I see it, if this minimum is being forced, it dismiss using materialized view as a valid solution for near-realtime.
I would have used "standard" caching over the queries, but caching does not work when querying table with "buffered data", as far as I understand it.
Please advise,
Shushu