BigQuery question on dashboard

Get Help
1

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?