We run an evaluation system of our models and visualize the results/diagnostics internally using Metabase. Every day we run the evaluation it creates a new table with the results (table name includes a datestamp to differentiate). I would like our Metabase questions & dashboard to constantly refer to the latest table instead of a static table name. How do I go about doing that?
I would create a View on the database, so Metabase always references that, and then you can update the View every time a new table is added.
Great, thanks for the suggestion! I decided that creating a static table and then archiving that after each run was the best way (inspired by your View suggestion).