Variable SQL generates errors when I query my bigquerry DB

[Luiggi]

please consider this is a "best effort" type of support, we're not able to set up a bigquery account, develop a similar case to what you're seeing and come up with a solution. We need a few weeks to see what's going on here

[Timm]

Nevertheless, do you have cases where you use metabase variables on a bigquerry table ? @Luiggi

[Timm]

@Luiggi @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