I’m testing MetaBase as a possible visualization layeron top of Google BigQuery. I’ve been trying to create queries with date range variables - both as “Date” variables, and as a “Field Filter” variable. In both cases I’m getting syntax errors from BigQuery.
Due to the nature of the implementation, being tied to a single user (and not to a service account, for example), I can see the queries that were sent to BQ through their UI; all of the variable fields are left intact, resulting in queries like:
select {{app_dt}} from base_enriched limit 1
Obviously, this cannot work. Am I missing something, or are variables not supported with BigQuery?
I’m trying to do this (This is in bigquery and I’m getting error: A valid date part name is required at [3:35]):
select
timestamp_trunc(w.created_at, {{duration}}) as period
from
dbt_prod.wapi__workouts w
limit 10