I receive 1 table everyday. These tables comes from Bigquery. Please check the attached screenshot.
u+tg/qB9XovmB3+NmxounM09FchRx7FaIvboAxhl5D8=
To make a daily trend I have to use UNION function to make all data union. Is there any automated system that makes all the tables into one table?
My query screenshot.
flamber
September 16, 2022, 12:07pm
2
Hi @shaonyuvi
Create a function or view on BigQuery which does this, so Metabase can just see a simple single table.
Can I do this on Metabase?
Actually, I don't have access there.
flamber
September 16, 2022, 12:17pm
4
@shaonyuvi Seems like BigQuery has some functionality builtin: https://stackoverflow.com/questions/53709752/bigquery-extract-data-for-yesterday-where-date-is-in-the-table-name-as-filename2
You'll find better help in a forum dedicated to BigQuery, since it's not really related to Metabase.
tonyg
September 16, 2022, 3:25pm
5
Try this:
select * from analytics_325139175.events_*
BigQuery lets you use wildcard tables. It will treat all the tables found with the * as a union of the individual tables.
You can also do select * from analytics_325139175.events_202208* if you only want the data for August.