Error after upgrading to 0.43.0

After upgrading to 0.43.0, I receive an error when trying to do any query

Setup:

  • Metabase version 0.43.0
  • Hosted on Google App Engine
  • Database connector - BigQuery

Im getting an error that says

"Error executing query: com.google.cloud.bigquery.BigQueryException: Table "Comment" must be qualified with a dataset (e.g. dataset.table).",
:stacktrace"

[21ada520-d4ad-40c2-ad20-629bc9c691c3] 2022-05-11T10:42:04+10:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 6,
 :started_at #t "2022-05-11T00:41:55.824421Z[Etc/UTC]",
 :via
 [{:status :failed,
   :class com.google.cloud.bigquery.BigQueryException,
   :error "Table \"Comment\" must be qualified with a dataset (e.g. dataset.table).",
   :stacktrace
   ["com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.translate(HttpBigQueryRpc.java:115)"
    "com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.queryRpc(HttpBigQueryRpc.java:652)"
    "com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1278)"
    "com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1275)"
    "com.google.api.gax.retrying.DirectRetryingExecutor.submit(DirectRetryingExecutor.java:105)"
    "com.google.cloud.RetryHelper.run(RetryHelper.java:76)"
    "com.google.cloud.RetryHelper.runWithRetries(RetryHelper.java:50)"
    "com.google.cloud.bigquery.BigQueryImpl.queryRpc(BigQueryImpl.java:1274)"
    "com.google.cloud.bigquery.BigQueryImpl.query(BigQueryImpl.java:1262)"
    "--> driver.bigquery_cloud_sdk$execute_bigquery$fn__81034.invoke(bigquery_cloud_sdk.clj:193)"]}
  {:status :failed,
   :class java.util.concurrent.ExecutionException,
   :error
   "com.google.cloud.bigquery.BigQueryException: Table \"Comment\" must be qualified with a dataset (e.g. dataset.table).",
   :stacktrace
   ["java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)"
    "java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)"
    "clojure.core$deref_future.invokeStatic(core.clj:2304)"
    "clojure.core$future_call$reify__8477.deref(core.clj:6976)"
    "clojure.core$deref.invokeStatic(core.clj:2324)"
    "clojure.core$deref.invoke(core.clj:2310)"
    "--> driver.bigquery_cloud_sdk$execute_bigquery.invokeStatic(bigquery_cloud_sdk.clj:181)"
    "driver.bigquery_cloud_sdk$execute_bigquery.invoke(bigquery_cloud_sdk.clj:177)"
    "driver.bigquery_cloud_sdk$execute_bigquery_on_db.invokeStatic(bigquery_cloud_sdk.clj:219)"
    "driver.bigquery_cloud_sdk$execute_bigquery_on_db.invoke(bigquery_cloud_sdk.clj:217)"
    "driver.bigquery_cloud_sdk$process_native_STAR_$thunk__81135.invoke(bigquery_cloud_sdk.clj:279)"
    "driver.bigquery_cloud_sdk$process_native_STAR_.invokeStatic(bigquery_cloud_sdk.clj:287)"
    "driver.bigquery_cloud_sdk$process_native_STAR_.invoke(bigquery_cloud_sdk.clj:271)"
    "driver.bigquery_cloud_sdk$fn__81141.invokeStatic(bigquery_cloud_sdk.clj:307)"
    "driver.bigquery_cloud_sdk$fn__81141.invoke(bigquery_cloud_sdk.clj:299)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)"
    "query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51425.invoke(cache.clj:219)"
    "query_processor.middleware.permissions$check_query_permissions$fn__47208.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50366.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__52898$combined_post_process__52903$combined_post_process_STAR___52904.invoke(query_processor.clj:207)"
    "query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
    "query_processor.middleware.store$initialize_store$fn__47639$fn__47640.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__47639.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
    "query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44179$fn__44183.invoke(reducible.clj:105)"]}
  {:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error
   "Error executing query: com.google.cloud.bigquery.BigQueryException: Table \"Comment\" must be qualified with a dataset (e.g. dataset.table).",
   :stacktrace
   ["--> driver.bigquery_cloud_sdk$throw_invalid_query.invokeStatic(bigquery_cloud_sdk.clj:173)"
    "driver.bigquery_cloud_sdk$throw_invalid_query.invoke(bigquery_cloud_sdk.clj:172)"
    "driver.bigquery_cloud_sdk$execute_bigquery.invokeStatic(bigquery_cloud_sdk.clj:215)"
    "driver.bigquery_cloud_sdk$execute_bigquery.invoke(bigquery_cloud_sdk.clj:177)"
    "driver.bigquery_cloud_sdk$execute_bigquery_on_db.invokeStatic(bigquery_cloud_sdk.clj:219)"
    "driver.bigquery_cloud_sdk$execute_bigquery_on_db.invoke(bigquery_cloud_sdk.clj:217)"
    "driver.bigquery_cloud_sdk$process_native_STAR_$thunk__81135.invoke(bigquery_cloud_sdk.clj:279)"
    "driver.bigquery_cloud_sdk$process_native_STAR_.invokeStatic(bigquery_cloud_sdk.clj:287)"
    "driver.bigquery_cloud_sdk$process_native_STAR_.invoke(bigquery_cloud_sdk.clj:271)"
    "driver.bigquery_cloud_sdk$fn__81141.invokeStatic(bigquery_cloud_sdk.clj:307)"
    "driver.bigquery_cloud_sdk$fn__81141.invoke(bigquery_cloud_sdk.clj:299)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:193)"
    "query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:178)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51425.invoke(cache.clj:219)"
    "query_processor.middleware.permissions$check_query_permissions$fn__47208.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50366.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__52898$combined_post_process__52903$combined_post_process_STAR___52904.invoke(query_processor.clj:207)"
    "query_processor$fn__52898$combined_pre_process__52899$combined_pre_process_STAR___52900.invoke(query_processor.clj:204)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346$fn__51351.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51346.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47451.invoke(fetch_source_query.clj:281)"
    "query_processor.middleware.store$initialize_store$fn__47639$fn__47640.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__47639.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__51618.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__48708.invoke(constraints.clj:52)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__51557.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__51929.invoke(catch_exceptions.clj:162)"
    "query_processor.reducible$async_qp$qp_STAR___44179$thunk__44181.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44179$fn__44183.invoke(reducible.clj:105)"],
   :error_type :invalid-query,
   :ex-data {:type :invalid-query, :sql "-- Metabase\nSELECT count(*) AS `count` FROM `Comment.`", :parameters nil}}],
 :error_type :invalid-query,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :query,
  :middleware {:js-int-to-string? true, :ignore-cached-results? false},
  :database 6,
  :query {:source-table 32367, :aggregation [[:count]]},
  :parameters [],
  :async? true,

:cache-ttl 12},

Hi @jins-agridigital, please post your troubleshooting info if possible. Thanks!