Median function error

Hi.

I need to use the Median function but the error occurs as per the attached print.
Below is the Diagnostic Info.
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.12+7",
"java.vendor": "Eclipse Foundation",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.12",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.12+7",
"os.name": "Linux",
"os.version": "4.19.112+",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"h2",
"bigquery-cloud-sdk",
"googleanalytics",
"bigquery",
"postgres",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.34-google-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-10-21",
"tag": "v0.41.1",
"branch": "release-x.41.x",
"hash": "76aa4a5"
},
"settings": {
"report-timezone": null
}
}
}

image

Hi @gustavolm
Which database are you querying?
Check the logs for full stacktrace error - Admin > Troubleshooting > Logs.

Hi @flamber

The Metabase database is Mysql, but the database I'm running the query on is BigQuery on Google Cloud.

[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:19-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 53,
:started_at #t "2021-11-12T18:07:17.861603Z[UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query",
:stacktrace
["--> driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:224)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:205)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$process_native_STAR_$thunk__81689.invoke(bigquery.clj:277)"
"driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
"driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
"driver.bigquery$fn__81694.invokeStatic(bigquery.clj:299)"
"driver.bigquery$fn__81694.invoke(bigquery.clj:290)"
"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:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49089.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__49575.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47462.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__49949.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50942.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50986.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49146.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39248.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43679.invoke(annotate.clj:615)"
"query_processor.middleware.permissions$check_query_permissions$fn__45617.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50126.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46015.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45953.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47060.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50712.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50248.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47079.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50300.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46451.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45926.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39148.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45260.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49501.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49798.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47447.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46828.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50048.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48398.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45241.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48052.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45314.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51370.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47831.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50315.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809$fn__49813.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45864.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46052$fn__46053.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__46052.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50098.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50105.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47777.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49075.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47795.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50084.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50395.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42499$thunk__42500.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42499.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___42508$fn__42511.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___42508.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:243)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:239)"
"query_processor$fn__51418$process_query_and_save_execution_BANG___51427$fn__51430.invoke(query_processor.clj:255)"
"query_processor$fn__51418$process_query_and_save_execution_BANG___51427.invoke(query_processor.clj:247)"
"query_processor$fn__51462$process_query_and_save_with_max_results_constraints_BANG___51471$fn__51474.invoke(query_processor.clj:267)"
"query_processor$fn__51462$process_query_and_save_with_max_results_constraints_BANG___51471.invoke(query_processor.clj:260)"
"api.dataset$run_query_async$fn__57805.invoke(dataset.clj:64)"
"query_processor.streaming$streaming_response_STAR_$fn__38057$fn__38058.invoke(streaming.clj:148)"
"query_processor.streaming$streaming_response_STAR_$fn__38057.invoke(streaming.clj:147)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__25228.invoke(streaming_response.clj:84)"],
:error_type :invalid-query,
:ex-data
{:type :invalid-query,
:sql
"-- Metabase:: userID: 91 queryType: MBQL queryHash: a0882e18c61c48813fb8503919258acc219fad83044b37d74202d4cf613e7aaa\nSELECT (CAST(APPROX_QUANTILES(metabase.engajamento_zendesk_tickets_1.ticket_metric_full_resolution_time_in_minutes_business, 10)[OFFSET(5)] AS float64) / CASE WHEN 60.0 = 0 THEN NULL ELSE 60.0 END) AS TMR FROM metabase.engajamento_zendesk_tickets_1 WHERE (metabase.engajamento_zendesk_tickets_1.ticket_metric_solved_at >= CAST(datetime_trunc(current_datetime(), month) AS timestamp) AND metabase.engajamento_zendesk_tickets_1.ticket_metric_solved_at < CAST(datetime_trunc(datetime_add(current_datetime(), INTERVAL 1 month), month) AS timestamp) AND metabase.engajamento_zendesk_tickets_1.group_name = ?)",
:parameters ("CS - Engajamento N1 - Serviço")}}],
:error_type :invalid-query,
:json_query
{:type "query",
:query
{:source-table 62784,
:filter
["and"
["time-interval" ["field" 962931 nil] "current" "month"]
["=" ["field" 962952 nil] "CS - Engajamento N1 - Serviço"]],
:aggregation [["aggregation-options" ["/" ["median" ["field" 962957 nil]] 60] {:name "TMR", :display-name "TMR"}]]},
:database 53,
:parameters [],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native
{:query
"SELECT (CAST(APPROX_QUANTILES(metabase.engajamento_zendesk_tickets_1.ticket_metric_full_resolution_time_in_minutes_business, 10)[OFFSET(5)] AS float64) / CASE WHEN 60.0 = 0 THEN NULL ELSE 60.0 END) AS TMR FROM metabase.engajamento_zendesk_tickets_1 WHERE (metabase.engajamento_zendesk_tickets_1.ticket_metric_solved_at >= CAST(datetime_trunc(current_datetime(), month) AS timestamp) AND metabase.engajamento_zendesk_tickets_1.ticket_metric_solved_at < CAST(datetime_trunc(datetime_add(current_datetime(), INTERVAL 1 month), month) AS timestamp) AND metabase.engajamento_zendesk_tickets_1.group_name = ?)",
:params ("CS - Engajamento N1 - Serviço"),
:table-name "engajamento_zendesk_tickets_1",
:mbql? true},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.google$execute_no_auto_retry.invokeStatic(google.clj:41)"
"driver.google$execute_no_auto_retry.invoke(google.clj:33)"
"driver.google$execute.invokeStatic(google.clj:55)"
"driver.google$execute.invoke(google.clj:45)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:216)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:205)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$process_native_STAR_$thunk__81689.invoke(bigquery.clj:277)"
"driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
"driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
"driver.bigquery$fn__81694.invokeStatic(bigquery.clj:299)"
"driver.bigquery$fn__81694.invoke(bigquery.clj:290)"
"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:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49089.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__49575.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47462.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__49949.invoke(cache.clj:204)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50942.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50986.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49146.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39248.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43679.invoke(annotate.clj:615)"
"query_processor.middleware.permissions$check_query_permissions$fn__45617.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50126.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46015.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45953.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47060.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50712.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50248.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47079.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50300.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46451.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45926.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39148.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45260.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49501.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49798.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47447.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46828.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50048.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48398.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45241.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48052.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45314.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51370.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47831.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50315.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809$fn__49813.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45864.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46052$fn__46053.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__46052.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50098.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50105.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47777.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49075.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47795.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50084.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50395.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42499$thunk__42500.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42499.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___42508$fn__42511.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___42508.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:243)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:239)"
"query_processor$fn__51418$process_query_and_save_execution_BANG___51427$fn__51430.invoke(query_processor.clj:255)"
"query_processor$fn__51418$process_query_and_save_execution_BANG___51427.invoke(query_processor.clj:247)"
"query_processor$fn__51462$process_query_and_save_with_max_results_constraints_BANG___51471$fn__51474.invoke(query_processor.clj:267)"
"query_processor$fn__51462$process_query_and_save_with_max_results_constraints_BANG___51471.invoke(query_processor.clj:260)"
"api.dataset$run_query_async$fn__57805.invoke(dataset.clj:64)"
"query_processor.streaming$streaming_response_STAR_$fn__38057$fn__38058.invoke(streaming.clj:148)"
"query_processor.streaming$streaming_response_STAR_$fn__38057.invoke(streaming.clj:147)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__25228.invoke(streaming_response.clj:84)"],
:card_id nil,
:context :ad-hoc,
:error "Unrecognized name: metabase at [2:31]",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:query
{:source-table 62784,
:filter
[:and
[:>= [:field 962931 {:temporal-unit :default}] [:relative-datetime 0 :month]]
[:< [:field 962931 {:temporal-unit :default}] [:relative-datetime 1 :month]]
[:=
[:field 962952 nil]
[:value
"CS - Engajamento N1 - Serviço"
{:base_type :type/Text,
:effective_type :type/Text,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "STRING",
:name "group_name"}]]],
:aggregation [[:aggregation-options [:confused: [:median [:field 962957 nil]] 60] {:name "TMR", :display-name "TMR"}]]},
:database 53,
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
:info
{:executed-by 91,
:context :ad-hoc,
:nested? false,
:query-hash
[-96, -120, 46, 24, -58, 28, 72, -127, 63, -72, 80, 57, 25, 37, -118, -52, 33, -97, -83, -125, 4, 75, 55, -41, 66,
2, -44, -49, 97, 62, 122, -86]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:ex-data
{"code" 400,
"errors"
[{"domain" "global", "location" "q", "locationType" "parameter", "message" "Unrecognized name: metabase at [2:31]", "reason" "invalidQuery"}],
"message" "Unrecognized name: metabase at [2:31]",
"status" "INVALID_ARGUMENT"},
:data {:rows [], :cols []}}

[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:19-03:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.4 s (10 DB calls) App DB connections: 1/10 Jetty threads: 2/50 (5 idle, 0 queued) (102 total active threads) Queries in flight: 0 (0 queued)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:19-03:00 INFO metabase.sync.analyze classify-fields Analyzed [····················] :relieved: 60% Table 64,096 'cloudaudit_googleapis_com_activity_20210922'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:20-03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for bigquery Database 52 'production logs' (4.6 s)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:20-03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for bigquery Database 52 'production logs'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:21-03:00 INFO metabase.sync.analyze classify-tables Analyzed [
···············] :smirk: 70% Table 61,986 'stdout_20191014'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:22-03:00 INFO metabase.sync.analyze classify-tables Analyzed [··········] :blush: 80% Table 62,860 'cloudaudit_googleapis_com_data_access_20200804'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:24-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:24-03:00 INFO metabase.sync.analyze classify-tables Analyzed [
·····] :heart_eyes: 90% Table 63,732 'cloudaudit_googleapis_com_activity_20210224'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for bigquery Database 52 'production logs' (5.4 s)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util FINISHED: Analyze data for bigquery Database 52 'production logs' (17.6 s)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.task.sync-databases Starting sync task for Database 27.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util STARTING: Sync metadata for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for postgres Database 27 'fiscal-prod-postgres' (79.3 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for postgres Database 27 'fiscal-prod-postgres' (160.3 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:26-03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for postgres Database 27 'fiscal-prod-postgres' (700.0 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for postgres Database 27 'fiscal-prod-postgres' (283.6 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for postgres Database 27 'fiscal-prod-postgres' (35.2 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: Sync metadata for postgres Database 27 'fiscal-prod-postgres' (1.3 s)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: Analyze data for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [·············································] :cry: 10% Table 8,297 'public.empresa_parceira_audit'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [········································] :disappointed: 20% Table 61,497 'public.nota_sumarizada_fora_periodo'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [
···································] :confused: 31% Table 61,681 'public.status_pendencia'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for postgres Database 27 'fiscal-prod-postgres' (43.5 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-fields Analyzed [······························] :neutral_face: 41% Table 8,296 'public.nota_audit'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-fields Analyzed [·························] :grimacing: 51% Table 61,496 'public.dado_sumarizado_devolucao'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-fields Analyzed [
····················] :relieved: 61% Table 61,680 'public.pendencia'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for postgres Database 27 'fiscal-prod-postgres' (26.1 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for postgres Database 27 'fiscal-prod-postgres'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-tables Analyzed [
***···············] :yum: 71% Table 8,295 'public.dado_sumarizado'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-tables Analyzed [··········] :blush: 82% Table 61,428 'public.dado_sumarizado_industria_audit'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.analyze classify-tables Analyzed [
·····] :heart_eyes: 92% Table 61,679 'public.tipo_pendencia'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for postgres Database 27 'fiscal-prod-postgres' (29.8 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:27-03:00 INFO metabase.sync.util FINISHED: Analyze data for postgres Database 27 'fiscal-prod-postgres' (126.3 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:28-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:29-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:34-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:38-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:39-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:44-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:48-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:54-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:58-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:07:59-03:00 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.task.sync-databases Starting sync task for Database 49.
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: Sync metadata for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for bigquery Database 49 'Datastore-Trace' (95.3 µs)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for bigquery Database 49 'Datastore-Trace' (237.8 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.sync-metadata.tables Updating description for tables: (Table 'trace')
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for bigquery Database 49 'Datastore-Trace' (176.9 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for bigquery Database 49 'Datastore-Trace' (2.2 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for bigquery Database 49 'Datastore-Trace' (173.2 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util FINISHED: Sync metadata for bigquery Database 49 'Datastore-Trace' (618.0 ms)
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: Analyze data for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [
······································] :unamused: 25% Table 61,656 'trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:00-03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for bigquery Database 49 'Datastore-Trace'
[ed7dd5a5-af50-4203-928c-6ea6fcc12938] 2021-11-12T15:08:01-03:00 WARN metabase.sync.util Error fingerprinting Table 61,656 'trace'
clojure.lang.ExceptionInfo: Error executing query {:type :invalid-query, :sql "-- Metabase\nSELECT trace_datastore.trace.entity AS entity, trace_datastore.trace.modulo AS modulo, trace_datastore.trace.path AS path, trace_datastore.trace.timestamp AS timestamp, trace_datastore.trace.tipo AS tipo, trace_datastore.trace.trace AS trace, trace_datastore.trace.traceId AS traceId FROM trace_datastore.trace LIMIT 10000", :parameters nil}
at metabase.driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:224)
at metabase.driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)
at metabase.driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:205)
at metabase.driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)
at metabase.driver.bigquery$process_native_STAR_$thunk__81689.invoke(bigquery.clj:277)
at metabase.driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)
at metabase.driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)
at metabase.driver.bigquery$fn__81694.invokeStatic(bigquery.clj:299)
at metabase.driver.bigquery$fn__81694.invoke(bigquery.clj:290)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
at metabase.query_processor.context$executef.invoke(context.clj:48)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
at metabase.query_processor.context$runf.invoke(context.clj:39)
at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49089.invoke(mbql_to_native.clj:25)
at metabase.query_processor.middleware.check_features$check_features$fn__49575.invoke(check_features.clj:39)
at metabase.query_processor.middleware.limit$limit$fn__47462.invoke(limit.clj:37)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__49949.invoke(cache.clj:204)
at metabase.query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50942.invoke(optimize_temporal_filters.clj:204)
at metabase.query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50986.invoke(validate_temporal_bucketing.clj:50)
at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49146.invoke(auto_parse_filter_values.clj:43)
at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39248.invoke(wrap_value_literals.clj:161)
at metabase.query_processor.middleware.annotate$add_column_info$fn__43679.invoke(annotate.clj:615)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__45617.invoke(permissions.clj:108)
at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50126.invoke(pre_alias_aggregations.clj:40)
at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46015.invoke(cumulative_aggregations.clj:60)
at metabase.query_processor.middleware.visualization_settings$update_viz_settings$fn__45953.invoke(visualization_settings.clj:63)
at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47060.invoke(resolve_joined_fields.clj:102)
at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__50712.invoke(resolve_joins.clj:171)
at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50248.invoke(add_implicit_joins.clj:190)
at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__47079.invoke(large_int_id.clj:59)
at metabase.query_processor.middleware.format_rows$format_rows$fn__50300.invoke(format_rows.clj:74)
at metabase.query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46451.invoke(add_default_temporal_unit.clj:23)
at metabase.query_processor.middleware.desugar$desugar$fn__45926.invoke(desugar.clj:21)
at metabase.query_processor.middleware.binning$update_binning_strategy$fn__39148.invoke(binning.clj:229)
at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__45260.invoke(resolve_fields.clj:34)
at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__49501.invoke(add_dimension_projections.clj:314)
at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49798.invoke(add_implicit_clauses.clj:147)
at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47447.invoke(upgrade_field_literals.clj:40)
at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46828.invoke(add_source_metadata.clj:123)
at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50048.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)
at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48398.invoke(auto_bucket_datetimes.clj:147)
at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45241.invoke(resolve_source_table.clj:45)
at metabase.query_processor.middleware.parameters$substitute_parameters$fn__48052.invoke(parameters.clj:111)
at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45314.invoke(resolve_referenced.clj:79)
at metabase.query_processor.middleware.expand_macros$expand_macros$fn__51370.invoke(expand_macros.clj:184)
at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__47831.invoke(add_timezone_info.clj:15)
at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50315.invoke(splice_params_in_response.clj:32)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809$fn__49813.invoke(resolve_database_and_driver.clj:31)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
at metabase.driver$do_with_driver.invoke(driver.clj:56)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49809.invoke(resolve_database_and_driver.clj:25)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45864.invoke(fetch_source_query.clj:274)
at metabase.query_processor.middleware.store$initialize_store$fn__46052$fn__46053.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:42)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.query_processor.middleware.store$initialize_store$fn__46052.invoke(store.clj:10)
at metabase.query_processor.middleware.validate$validate_query$fn__50098.invoke(validate.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__50105.invoke(normalize_query.clj:22)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47777.invoke(add_rows_truncated.clj:35)
at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49075.invoke(results_metadata.clj:143)
at metabase.query_processor.reducible$async_qp$qp_STAR___42499$thunk__42500.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___42499.invoke(reducible.clj:109)
at metabase.query_processor.reducible$sync_qp$qp_STAR___42508$fn__42511.invoke(reducible.clj:135)
at metabase.query_processor.reducible$sync_qp$qp_STAR___42508.invoke(reducible.clj:134)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor$process_query.invokeStatic(query_processor.clj:152)
at metabase.query_processor$process_query.doInvoke(query_processor.clj:146)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.db.metadata_queries$fn__69339$table_rows_sample__69348$fn__69351.invoke(metadata_queries.clj:144)
at metabase.db.metadata_queries$fn__69339$table_rows_sample__69348.invoke(metadata_queries.clj:131)
at metabase.sync.analyze.fingerprint$fn__69406$fingerprint_table_BANG___69411$fn__69412.invoke(fingerprint.clj:66)
at metabase.sync.analyze.fingerprint$fn__69406$fingerprint_table_BANG___69411.invoke(fingerprint.clj:46)
at metabase.sync.analyze.fingerprint$fn__69582$fingerprint_fields_BANG___69587$fn__69588$fn__69589.invoke(fingerprint.clj:180)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at metabase.sync.analyze.fingerprint$fn__69582$fingerprint_fields_BANG___69587$fn__69588.invoke(fingerprint.clj:178)
at metabase.sync.analyze.fingerprint$fn__69582$fingerprint_fields_BANG___69587.invoke(fingerprint.clj:174)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626$fn__69629$fn__69630$fn__69631.invoke(fingerprint.clj:204)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6829)
at clojure.core$reduce.invoke(core.clj:6812)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626$fn__69629$fn__69630.invoke(fingerprint.clj:200)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626$fn__69629.invoke(fingerprint.clj:197)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626.invoke(fingerprint.clj:186)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626$fn__69627.invoke(fingerprint.clj:191)
at metabase.sync.analyze.fingerprint$fn__69617$fingerprint_fields_for_db_BANG__STAR___69626.invoke(fingerprint.clj:186)
at metabase.sync.analyze.fingerprint$fn__69659$fingerprint_fields_for_db_BANG___69664$fn__69665.invoke(fingerprint.clj:218)
at metabase.sync.analyze.fingerprint$fn__69659$fingerprint_fields_for_db_BANG___69664.invoke(fingerprint.clj:212)
at metabase.sync.analyze$make_analyze_steps$fn__69972.invoke(analyze.clj:104)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__40095$run_step_with_metadata__40100$fn__40104$fn__40106.doInvoke(util.clj:360)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:116)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:113)
at metabase.sync.util$fn__40095$run_step_with_metadata__40100$fn__40104.invoke(util.clj:355)
at metabase.sync.util$fn__40095$run_step_with_metadata__40100.invoke(util.clj:350)
at metabase.sync.util$fn__40286$run_sync_operation__40291$fn__40292$fn__40300.invoke(util.clj:451)
at metabase.sync.util$fn__40286$run_sync_operation__40291$fn__40292.invoke(util.clj:449)
at metabase.sync.util$fn__40286$run_sync_operation__40291.invoke(util.clj:443)
at metabase.sync.analyze$fn__69984$analyze_db_BANG___69989$fn__69990$fn__69991.invoke(analyze.clj:121)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__24546.invokeStatic(driver.clj:555)
at metabase.driver$fn__24546.invoke(driver.clj:555)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__40007.invoke(util.clj:135)
at metabase.sync.util$with_db_logging_disabled$fn__40004.invoke(util.clj:126)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
at metabase.sync.util$with_start_and_finish_logging$fn__39993.invoke(util.clj:111)
at metabase.sync.util$with_sync_events$fn__39988.invoke(util.clj:85)
at metabase.sync.util$with_duplicate_ops_prevented$fn__39979.invoke(util.clj:64)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:177)
at metabase.sync.util$do_sync_operation.invoke(util.clj:174)
at metabase.sync.analyze$fn__69984$analyze_db_BANG___69989$fn__69990.invoke(analyze.clj:118)
at metabase.sync.analyze$fn__69984$analyze_db_BANG___69989.invoke(analyze.clj:113)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invokeStatic(sync_databases.clj:70)
at metabase.task.sync_databases$sync_and_analyze_database_BANG_.invoke(sync_databases.clj:58)
at metabase.task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: clojure.lang.ExceptionInfo: Cannot query over table 'trace_datastore.trace' without a filter over column(s) '_PARTITION_LOAD_TIME', '_PARTITIONDATE', '_PARTITIONTIME' that can be used for partition elimination {"code" 400, "errors" [{"domain" "global", "location" "q", "locationType" "parameter", "message" "Cannot query over table 'trace_datastore.trace' without a filter over column(s) '_PARTITION_LOAD_TIME', '_PARTITIONDATE', '_PARTITIONTIME' that can be used for partition elimination", "reason" "invalidQuery"}], "message" "Cannot query over table 'trace_datastore.trace' without a filter over column(s) '_PARTITION_LOAD_TIME', '_PARTITIONDATE', '_PARTITIONTIME' that can be used for partition elimination", "status" "INVALID_ARGUMENT"}
at metabase.driver.google$execute_no_auto_retry.invokeStatic(google.clj:41)
at metabase.driver.google$execute_no_auto_retry.invoke(google.clj:33)
at metabase.driver.google$execute.invokeStatic(google.clj:55)
at metabase.driver.google$execute.invoke(google.clj:45)
at metabase.driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:216)
... 137 more

@gustavolm Looks like the database you're querying is using the old driver, change to the new driver via Admin > Databases > (db)

@flamber after updating the BQ driver, it solved the problem. Thank you.