For the large tables, what about using timestamp based table partitioning to split data into smaller units ? And then materialize each of them one by one ?

So you get to keep materialized data and a single logical table.