Wednesday
Have you looked into Compatibility Mode? It is explicitly built to generate a read-only compatibility version of streaming tables/materialized views at a chosen location and keep it refreshed automatically after updates.
