I had a couple of questions:

1. Can I create a materialized view on a table with a TTL longer than the
base table? For ex: my materialized view TTL is 1 month while my base table
TTL is 1 week.

2. In the above scenario, since the data in my base table would be gone
after a week, would it impact data in the materialized view?

My use case if I have some time series data, which is stored in the base
table by_minute and I want to downsample it to by_month. So my base table
stores by_minute data but my materialized view stores stores by_week data.



Reply via email to