I have a list of tables stored in a SQL database that have the same structure, more or less.
e.g. "financial_101223", "financial_111223", etc... Every couple of days there's a new table added.
Since the list of tables is continuously growing - I'm using a python script to find all tables that have a certain string pattern in their name and then query them (select * from x) and append the rows to get one table.
Is there an elegant way to do this using kedro's catalog?
Thanks in advance,
Gilad.