i have various snapshots of a table. These snapshots are generated at the end of each months, because these tables are overwritten from time to time and i would like to keep past informations.
E.g. "stats_202201", "stats_202202", "stats_202203", ...
I would like to know, if it is possible to filter these tables based on a date.
Maybe like: Cast the date input to string -> append the string (yyyymm) to the table name end.
Thanks in advance!