Hi there, people! I’ve just integrated my metabase instance with BigQuery. But, as far as I know, to be able to filter a question on a dashboard, I need to use a Field Filter. This is the query I’m using:
SELECT SUM(totals.visits) FROM `0000000.ga_sessions_*` VISIT WHERE _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d','2019-05-02') AND FORMAT_DATE('%Y%m%d','2019-05-02')
As you can see, we need to filter out which tables are being used, rather than a field in a table (BigQuery isn’t the usual SQL with structured data, but rather a big JSON-like database). How could I show a BigQuery question on a database?