Errors when creating dashboard filters on BigQuery Views

Hi I posted here and received no answer. Field filters errors on BigQuery Views

Can someone please help?

Logs, version, OS?

Metabase v 0.27.2 on Chrome 63.0.3239.132 macOS 10.13.2
log of the error below:

Feb 14 21:08:53 WARN metabase.util :: auto-retry metabase.driver.google$execute$fn__47068@7e79d796: Unrecognized name: li at [8:18]
Feb 14 21:08:54 WARN metabase.util :: auto-retry metabase.driver.google$execute$fn__47068@7e79d796: Unrecognized name: li at [8:18]
Feb 14 21:08:54 WARN metabase.util :: auto-retry metabase.driver.bigquery$process_native_STAR_$fn__47511@58f779a5: Unrecognized name: li at [8:18]
Feb 14 21:08:55 WARN metabase.util :: auto-retry metabase.driver.google$execute$fn__47068@3ebebf81: Unrecognized name: li at [8:18]
Feb 14 21:08:55 WARN metabase.util :: auto-retry metabase.driver.google$execute$fn__47068@3ebebf81: Unrecognized name: li at [8:18]
Feb 14 21:08:56 WARN metabase.query-processor :: {:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Unrecognized name: li at [8:18]",
:stacktrace
["driver.google$execute_no_auto_retry.invokeStatic(google.clj:34)"
"driver.google$execute_no_auto_retry.invoke(google.clj:27)"
"driver.google$execute$fn__47068.invoke(google.clj:45)"
"util$do_with_auto_retries.invokeStatic(util.clj:713)"
"util$do_with_auto_retries.invoke(util.clj:705)"
"util$do_with_auto_retries.invokeStatic(util.clj:717)"
"util$do_with_auto_retries.invoke(util.clj:705)"
"util$do_with_auto_retries.invokeStatic(util.clj:717)"
"util$do_with_auto_retries.invoke(util.clj:705)"
"driver.google$execute.invokeStatic(google.clj:44)"
"driver.google$execute.invoke(google.clj:38)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:124)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:113)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:115)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:113)"
"driver.bigquery$process_native_STAR_$fn__47511.invoke(bigquery.clj:187)"
"util$do_with_auto_retries.invokeStatic(util.clj:713)"
"util$do_with_auto_retries.invoke(util.clj:705)"
"util$do_with_auto_retries.invokeStatic(util.clj:717)"
"util$do_with_auto_retries.invoke(util.clj:705)"
"driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:186)"
"driver.bigquery$process_native_STAR_.invoke(bigquery.clj:183)"
"driver.bigquery$execute_query.invokeStatic(bigquery.clj:286)"
"driver.bigquery$execute_query.invoke(bigquery.clj:282)"
"driver$fn__24320$G__24313__24327.invoke(driver.clj:34)"
"query_processor$execute_query.invokeStatic(query_processor.clj:50)"
"query_processor$execute_query.invoke(query_processor.clj:44)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__28572.invoke(mbql_to_native.clj:30)"
"query_processor.middleware.annotate_and_sort$annotate_and_sort$fn__26996.invoke(annotate_and_sort.clj:41)"
"query_processor.middleware.limit$limit$fn__28527.invoke(limit.clj:14)"
"query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__28385.invoke(cumulative_aggregations.clj:46)"
"query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__28385.invoke(cumulative_aggregations.clj:46)"
"query_processor.middleware.format_rows$format_rows$fn__28517.invoke(format_rows.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__27075.invoke(binning.clj:172)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__29821.invoke(results_metadata.clj:89)"
"query_processor.middleware.resolve$resolve_middleware$fn__26603.invoke(resolve.clj:359)"
"query_processor.middleware.expand$expand_middleware$fn__28279.invoke(expand.clj:550)"
"query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__26687.invoke(add_row_count_and_status.clj:14)"
"query_processor.middleware.driver_specific$process_query_in_context$fn__28405.invoke(driver_specific.clj:12)"
"query_processor.middleware.resolve_driver$resolve_driver$fn__29832.invoke(resolve_driver.clj:14)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__27156.invoke(cache.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__28327.invoke(catch_exceptions.clj:58)"
"query_processor$process_query.invokeStatic(query_processor.clj:126)"
"query_processor$process_query.invoke(query_processor.clj:122)"
"query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:234)"
"query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:229)"
"query_processor$fn__29866$process_query_and_save_execution_BANG___29871$fn__29872.invoke(query_processor.clj:272)"
"query_processor$fn__29866$process_query_and_save_execution_BANG___29871.invoke(query_processor.clj:258)"
"api.dataset$fn__32396$fn__32399.invoke(dataset.clj:63)"
"api.common.internal$do_with_caught_api_exceptions.invokeStatic(internal.clj:248)"
"api.common.internal$do_with_caught_api_exceptions.invoke(internal.clj:243)"
"api.dataset$fn__32396.invokeStatic(dataset.clj:54)"
"api.dataset$fn__32396.invoke(dataset.clj:54)"
"middleware$enforce_authentication$fn__31785.invoke(middleware.clj:122)"
"api.routes$fn__44994.invokeStatic(routes.clj:65)"
"api.routes$fn__44994.invoke(routes.clj:65)"
"routes$fn__45721$fn__45722.doInvoke(routes.clj:101)"
"routes$fn__45721.invokeStatic(routes.clj:97)"
"routes$fn__45721.invoke(routes.clj:97)"
"middleware$log_api_call$fn__31884$fn__31886.invoke(middleware.clj:330)"
"middleware$log_api_call$fn__31884.invoke(middleware.clj:329)"
"middleware$add_security_headers$fn__31834.invoke(middleware.clj:245)"
"middleware$bind_current_user$fn__31789.invoke(middleware.clj:142)"
"middleware$maybe_set_site_url$fn__31838.invoke(middleware.clj:268)"],
:query
{:type "native",
:native
{:query "#standardsql\n\nselect date(timestamp) as d\n, track_artists\n, count(track_artists) as streams\nfrom li.spotify_streams\nwhere {{date_var}}\ngroup by 1,2\norder by 2",
:template_tags
{:date_var
{:id "11f90d48-fcac-38fb-5fbd-a8f77b32d951",
:name "date_var",
:display_name "Date var",
:type "dimension",
:dimension ["field-id" 7114],
:widget_type "date/range",
:default "2018-01-01~2018-01-25"}},
:collection "artist_fb_summary"},
:parameters ,
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info
{:executed-by 5,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [0, -12, -3, -54, -72, -19, 59, -52, 1, 54, -108, -30, -64, -3, 113, -103, 18, 95, 83, 51, -71, -34, 63, -23, -92, -16, -1, -35, 14, -94, -106, 68],
:query-type "native"}},
:expanded-query nil,
:ex-data
{"code" 400,
"errors" [{"domain" "global", "location" "query", "locationType" "other", "message" "Unrecognized name: li at [8:18]", "reason" "invalidQuery"}],
"message" "Unrecognized name: li at [8:18]"}}

Feb 14 21:08:56 WARN metabase.query-processor :: Query failure: Unrecognized name: li at [8:18]
["query_processor$assert_query_status_successful.invokeStatic(query_processor.clj:203)"
"query_processor$assert_query_status_successful.invoke(query_processor.clj:196)"
"query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:235)"
"query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:229)"
"query_processor$fn__29866$process_query_and_save_execution_BANG___29871$fn__29872.invoke(query_processor.clj:272)"
"query_processor$fn__29866$process_query_and_save_execution_BANG___29871.invoke(query_processor.clj:258)"
"api.dataset$fn__32396$fn__32399.invoke(dataset.clj:63)"
"api.common.internal$do_with_caught_api_exceptions.invokeStatic(internal.clj:248)"
"api.common.internal$do_with_caught_api_exceptions.invoke(internal.clj:243)"
"api.dataset$fn__32396.invokeStatic(dataset.clj:54)"
"api.dataset$fn__32396.invoke(dataset.clj:54)"
"middleware$enforce_authentication$fn__31785.invoke(middleware.clj:122)"
"api.routes$fn__44994.invokeStatic(routes.clj:65)"
"api.routes$fn__44994.invoke(routes.clj:65)"
"routes$fn__45721$fn__45722.doInvoke(routes.clj:101)"
"routes$fn__45721.invokeStatic(routes.clj:97)"
"routes$fn__45721.invoke(routes.clj:97)"
"middleware$log_api_call$fn__31884$fn__31886.invoke(middleware.clj:330)"
"middleware$log_api_call$fn__31884.invoke(middleware.clj:329)"
"middleware$add_security_headers$fn__31834.invoke(middleware.clj:245)"
"middleware$bind_current_user$fn__31789.invoke(middleware.clj:142)"
"middleware$maybe_set_site_url$fn__31838.invoke(middleware.clj:268)"]

You need to combine your two postings - you now have the log in one, but the error in the other.
I’ve no experience of BigQuery, but someone else should be along to help.

Have you tried this with the latest release?