In my case, daily data is getting produced in one topic. I want KSQLDB server to create two tables daily for today and yesterday. For example, Today-Table and Yesterday-Table are two KTables of same topic conditioning that Today-Table contains today’s data and Yesterday-Table contain yesterday’s data. It is pretty achievable when it comes to static creation.
But what I need here is, for next day it should automatically toggle today’s data as yesterday’s data and next day’s data as today’s data and so on.
As for tomorrow, today is yesterday,
Is it achievable with KSQLDB? How can I do that? What should be the prerequisites?
Please put some light in this case,