How to manage one table by day

[danielmguerrero]

Hi,

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

[flamber]

Hi @danielmguerrero
There's no exclude functionality currently:
https://github.com/metabase/metabase/issues/5281 - upvote by clicking 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:

SELECT *
FROM `hidden_ga_dataset.ga_sessions_*`
WHERE _TABLE_SUFFIX = FORMAT_DATE('%Y%m%d', CURRENT_DATE())

[danielmguerrero]

Thanks flamber.

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