Related to this and Polyscale use case. Would this work ?

  CREATE WINDOW VIEW IF NOT EXISTS minute_metrics_wv minute_metrics_tt AS SELECT ... FROM raw_metrics WHERE ... GROUP BY ...

That is, replacing the materialized view if favor of a WINDOW VIEW