Basic materialized views support in the Iceberg connector

[tdcmeehan]

Many popular SQL systems that interface with Iceberg support Materialized Views. Iceberg support would enable some common interactive use cases, such as dashboards, BI tools and canned queries, which materialized views can help to accelerate.

Expected Behavior or Use Case

Basic fresh/stale materialized view support in Iceberg, with full REFRESH.

Presto Component, Service, or Connector

Iceberg connector

Possible Implementation

Report only the freshness of the materialized view without partition staleness.

Example Screenshots (if appropriate):

Context

Basic materialized view support for Iceberg would be a good milestone to achieve, and it would serve as the foundation for future enhancements such as conjunctive and disjunctive constraints for partition stitching and automatic incremental refresh.