Hi Flink users, I created a KeyedStream that tracks for each user of my website some metrics. It's time a user produces an event the metrics are recomputed and change. I would like to keep the outcome of a user's session at an RDBMS, which will be a single row.
The first and obvious solution would be to Insert the row at the RDBMS and then update it, it's time something new occurs. I would like to ask if another solution is possible. For example, could we maybe schedule to use the RDBMS as a sink of the state before its TTL passes by? Best regards, Anastasis