Filter different tables based on date

Get Help
1

Hi,

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!

2

Hi @Fresh
I'm not sure where you want to filter, but Metabase uses parameters in SQL queries, when using variables to prevent SQL injection.
Sounds like you are looking for this - there might be some hacky workarounds for some database types.
https://github.com/metabase/metabase/issues/4639 - upvote by clicking :+1: on the first post