Error using Field filter with Bigquery

[alexklklkl]

I very carefully read
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type,
https://www.metabase.com/learn/sql-questions/field-filters
and discourse, but there are not answer.

I try to use Field filter with Bigquery but there is error "Unrecognized name: analytics_264308021.events at [8:9]"

Question is:

SELECT
count(*) as cnt,
'{{event_name}}' as what_is_in_filter
FROM security-master-75d2d.analytics_264308021.events
WHERE
event_date_date = '2021-08-30'
AND {{event_name}}

Query in Bigquery is:

-- Metabase:: userID: 1 queryType: native queryHash: 75ac8da465127c2dc5d040cefd4976af235543ad596f1735af6b5cf8e42a06ba
SELECT
count(*) as cnt,
'analytics_264308021.events.event_name IN (?)' as what_is_in_filter
FROM security-master-75d2d.analytics_264308021.events
WHERE
event_date_date = '2021-08-30'
AND analytics_264308021.events.event_name IN (?)

Error is in line:

AND analytics_264308021.events.event_name IN (?)

If run query without dataset_name "analytics_264308021" or with project_id prefix before dataset_name "security-master-75d2d.analytics_264308021", there are not any errors:

Both is correct:

1. AND event_name IN (?)
2. AND security-master-75d2d.analytics_264308021.events.event_name IN (?)

What is right way to use Field Filter with Bigquery (without dataset_name or with project_id before dataset_name)?

[flamber]

Hi @alexklklkl
Your from-clause should be without Project ID.
FROM `analytics_264308021.events`

[alexklklkl]

Big big big thanks, it is very helpfull!

[rodolphoya1]

Hey @flamber
How's it going?

UP in this old thread (kkkrying)

I opened this issue here

Field Filter with BigQuery doesn't work

Even trying to avoid field filter gotchas, there's a strange behavior on it (Better described in the issue)

tks in advance