all-things-risingwave
Does Rising Wave have built-in orchestration and scheduling capabilities for tasks like deleting data based on TTL?
I am considering deleting data from my Table after a specific TTL and wondering if Rising Wave provides any built-in orchestration or scheduling capabilities similar to a cron job for this purpose.
Ro
Robert Gargalac
Asked on Apr 09, 2024
Yes, Rising Wave does not have built-in orchestration and scheduling capabilities like a cron job. However, you can achieve data deletion based on TTL using temporal filters and external scripts. Here is how you can define a table with TTL using temporal filters:
- Create a source first:
create source X;
- Create a materialized view (the table you want) with TTL:
create materialized view real_X_table as
select * from X where X.timestamp > now() - interval '1 month';
By using temporal filters and defining materialized views with TTL, you can effectively manage data deletion based on time-to-live in Rising Wave.
Apr 10, 2024Edited by