I am creating external tables with configured locations and that is great, because now the only thing I need to do to push new daily data is to just create the parquet file and alter the table with the new partition details.
Now the challenge is the aggregated tables that are created as CREATE TABLE FOO AS SELECT..FROM ABC, XYZ,..WHERE...;
These ones I have to recreate them at each time and there is no way to just alter them and make them aware of the new data. The queries are evaluated at creation time!
Is there any other way to create aggregated tables that are updated automatically?