How to manage one table by day


I've connected Metabase to BigQuery. There I have a dataset that creates one table per day with all my data. Is there any way to synchronize just the latest table?

Thanks for your help

Hi @danielmguerrero
There's no exclude functionality currently: - upvote by clicking :+1: on the first post

You could perhaps not include that dataset, but have another dataset, which contains views like this taking advantage of _TABLE_SUFFIX:

FROM `hidden_ga_dataset.ga_sessions_*`
1 Like

Thanks flamber.

This workaround works fine for me. I made the query, saved it as a question, and then used it as a dataset.