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:

  1. Create a source first:
create source X;
  1. 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