Field filters errors on BigQuery Views

[yugoli]

Hi,
I'm trying to create dashboards with filters. I have done this in the past with our BQ tables but with views I've created it gives me an error. First I imported my views into metabase since it resides in a separate dataset id. I can map the field to the field filter. But I get this error when I run it.

select date,
sum(num_logins)
from li.artist_login_ts
where {{date_var}}
group by 1
order by 2 desc

Thanks for your help.
Li

[jkindness]

Did you solve this issue? I'm having the same problem which I outlined in this post:

Date Filter with Big Query

We are using Big Query and are able to get most of our queries working. However, it doesn’t seem to work when we use a date filter variable. When I execute the following code, I get an error that reads “Unrecognized name: production at [8:16]”. #standardSQL select timestamp from production.production_20180221 table where {{date}} limit 10 Does the date filter not work with sql?

It seems like the date variable is not dealing with the dataset properly.

[ankish]

+1 facing this issue. Any fixes / Resolutions ?

[deanputney]

I’ll echo this, I am also having the same issue. No solution found yet.

[flamber]

From the documentation note, when using Field Filters on BigQuery:
Redirecting…

In BigQuery, back ticks are needed, like FROM `dataset_name.table`

[romain.r]

I have the same problem too. Any fixes? I tried this https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type but it does not work

[flamber]

@romain.r Post your query.