Earlier quoted context omitted.
You should schedule a "create or replace table" statement every N hours/days/etc. It will be effectively just the same as a scheduled materialized view refresh.
I've been reading up on this as a potential solution; I may have to finally take it seriously and try it out.
the "t" at the end of "fact" implies past tense. if a materialized view is
a statement of fact then you are safe to deploy in a relational schema, i claim. think about it.
https://www.protechtraining.com/blog/post/the-value-of-value...