Variable SQL generates errors when I query my bigquerry DB

[Timm]

@dragonsahead @arakaki

I found the solution in a post from 2021.
Basically, the from-clause should be without Project ID

Error using Field filter with Bigquery

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]" [12] Question is: SELECT count(*) as cnt, '{{event_name}}' as what_is_in_filter FROM security-master-75d2d.analytics_264308021.events WHERE even…

Maybe this will help others when the time comes.
Thanks for your contributions