Created
August 19, 2025 22:23
-
-
Save escherize/3ac145f2c7fb0fd5ea5506f8a032b1e7 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "database_id": 13371337, | |
| "parameterized": false, | |
| "started_at": "2025-08-19T22:22:59.101199Z", | |
| "via": [ | |
| { | |
| "status": "failed", | |
| "class": "class org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException", | |
| "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(order by `source`.`running_time_seconds`) AS `Percentile 90`, PERCENTILE_CONT(0' at line 2", | |
| "stacktrace": [ | |
| "org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)", | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:195)", | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:263)", | |
| "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)", | |
| "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)", | |
| "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1341)", | |
| "--> driver.sql_jdbc.execute$eval152402$fn__152403.invoke(execute.clj:592)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:600)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:597)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546$fn__152547.invoke(execute.clj:777)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546.invoke(execute.clj:776)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224$fn__152225.invoke(execute.clj:427)", | |
| "driver.sql_jdbc.execute$fn__152136$do_with_resolved_connection152135__152137.invoke(execute.clj:355)", | |
| "driver.sql_jdbc.execute$fn__152136$fn__152142.invoke(execute.clj:335)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224.invoke(execute.clj:421)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:769)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:758)", | |
| "driver.sql_jdbc$eval170038$fn__170039.invoke(sql_jdbc.clj:81)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105)", | |
| "query_processor.execute$run.invokeStatic(execute.clj:64)", | |
| "query_processor.execute$run.invoke(execute.clj:58)", | |
| "metabase_enterprise.database_routing.middleware$eval214004$swap_destination_db__214005$fn__214006.invoke(middleware.clj:30)", | |
| "query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)", | |
| "metabase_enterprise.impersonation.middleware$eval213982$apply_impersonation_postprocessing__213983$fn__213984.invoke(middleware.clj:25)", | |
| "query_processor.middleware.enterprise$apply_impersonation_postprocessing_middleware$fn__123487.invoke(enterprise.clj:48)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$_AMPERSAND_f__128050.invoke(update_used_cards.clj:67)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$fn__128060.invoke(update_used_cards.clj:59)", | |
| "query_processor.execute$add_native_form_to_result_metadata$fn__128072.invoke(execute.clj:25)", | |
| "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__128078.invoke(execute.clj:36)", | |
| "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___127718.invoke(cache.clj:241)", | |
| "query_processor.middleware.permissions$check_query_permissions$fn__125807.invoke(permissions.clj:149)", | |
| "metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$eval214984$check_download_permissions__214985$fn__214986.invoke(permissions.clj:97)", | |
| "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__123514.invoke(enterprise.clj:90)", | |
| "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$eval218750$maybe_apply_column_level_perms_check__218751$fn__218752.invoke(column_level_perms_check.clj:38)", | |
| "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__123524.invoke(enterprise.clj:103)", | |
| "query_processor.execute$fn__128112$execute128111__128113$fn__128114.invoke(execute.clj:96)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:225)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor.execute$fn__128112$execute128111__128113.invoke(execute.clj:95)", | |
| "query_processor.execute$fn__128112$fn__128117.invoke(execute.clj:91)", | |
| "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:50)", | |
| "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:45)", | |
| "metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$eval213795$handle_audit_app_internal_queries__213796$fn__213797.invoke(handle_audit_queries.clj:143)", | |
| "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__123552.invoke(enterprise.clj:142)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$_AMPERSAND_f__128392.invoke(process_userland_query.clj:179)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$fn__128398.invoke(process_userland_query.clj:167)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$_AMPERSAND_f__128213.invoke(catch_exceptions.clj:137)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$fn__128228.invoke(catch_exceptions.clj:127)", | |
| "query_processor$fn__128737$process_query128736__128738$fn__128739.invoke(query_processor.clj:81)", | |
| "query_processor.setup$fn__126999$do_with_canceled_chan126998__127000$fn__127001.invoke(setup.clj:187)", | |
| "query_processor.setup$fn__126988$do_with_database_local_settings126987__126989$fn__126990.invoke(setup.clj:181)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979$fn__126980.invoke(setup.clj:166)", | |
| "driver$do_with_driver.invokeStatic(driver.clj:49)", | |
| "driver$do_with_driver.invoke(driver.clj:44)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979.invoke(setup.clj:165)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966$fn__126969.invoke(setup.clj:151)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:185)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:178)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966.invoke(setup.clj:150)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$_AMPERSAND_f__126946.invoke(setup.clj:128)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$fn__126949.invoke(setup.clj:122)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:232)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor$fn__128737$process_query128736__128738.invoke(query_processor.clj:79)", | |
| "query_processor$fn__128737$fn__128743.invoke(query_processor.clj:72)", | |
| "query_processor.api$fn__188362$run_streaming_query188361__188365$fn__188369.invoke(api.clj:87)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547$fn__107548.invoke(streaming.clj:213)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547.invoke(streaming.clj:211)", | |
| "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:202)", | |
| "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:189)", | |
| "query_processor.streaming$_streaming_response$fn__107546.invoke(streaming.clj:208)", | |
| "server.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:79)", | |
| "server.streaming_response$do_f_STAR_.invoke(streaming_response.clj:77)", | |
| "server.streaming_response$do_f_async$task__107076.invoke(streaming_response.clj:94)" | |
| ], | |
| "state": "42000" | |
| }, | |
| { | |
| "status": "failed", | |
| "class": "class java.sql.SQLSyntaxErrorException", | |
| "error": "(conn=18) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(order by `source`.`running_time_seconds`) AS `Percentile 90`, PERCENTILE_CONT(0' at line 2", | |
| "stacktrace": [ | |
| "org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)", | |
| "org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)", | |
| "org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)", | |
| "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)", | |
| "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)", | |
| "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1341)", | |
| "--> driver.sql_jdbc.execute$eval152402$fn__152403.invoke(execute.clj:592)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:600)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:597)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546$fn__152547.invoke(execute.clj:777)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546.invoke(execute.clj:776)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224$fn__152225.invoke(execute.clj:427)", | |
| "driver.sql_jdbc.execute$fn__152136$do_with_resolved_connection152135__152137.invoke(execute.clj:355)", | |
| "driver.sql_jdbc.execute$fn__152136$fn__152142.invoke(execute.clj:335)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224.invoke(execute.clj:421)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:769)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:758)", | |
| "driver.sql_jdbc$eval170038$fn__170039.invoke(sql_jdbc.clj:81)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105)", | |
| "query_processor.execute$run.invokeStatic(execute.clj:64)", | |
| "query_processor.execute$run.invoke(execute.clj:58)", | |
| "metabase_enterprise.database_routing.middleware$eval214004$swap_destination_db__214005$fn__214006.invoke(middleware.clj:30)", | |
| "query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)", | |
| "metabase_enterprise.impersonation.middleware$eval213982$apply_impersonation_postprocessing__213983$fn__213984.invoke(middleware.clj:25)", | |
| "query_processor.middleware.enterprise$apply_impersonation_postprocessing_middleware$fn__123487.invoke(enterprise.clj:48)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$_AMPERSAND_f__128050.invoke(update_used_cards.clj:67)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$fn__128060.invoke(update_used_cards.clj:59)", | |
| "query_processor.execute$add_native_form_to_result_metadata$fn__128072.invoke(execute.clj:25)", | |
| "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__128078.invoke(execute.clj:36)", | |
| "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___127718.invoke(cache.clj:241)", | |
| "query_processor.middleware.permissions$check_query_permissions$fn__125807.invoke(permissions.clj:149)", | |
| "metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$eval214984$check_download_permissions__214985$fn__214986.invoke(permissions.clj:97)", | |
| "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__123514.invoke(enterprise.clj:90)", | |
| "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$eval218750$maybe_apply_column_level_perms_check__218751$fn__218752.invoke(column_level_perms_check.clj:38)", | |
| "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__123524.invoke(enterprise.clj:103)", | |
| "query_processor.execute$fn__128112$execute128111__128113$fn__128114.invoke(execute.clj:96)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:225)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor.execute$fn__128112$execute128111__128113.invoke(execute.clj:95)", | |
| "query_processor.execute$fn__128112$fn__128117.invoke(execute.clj:91)", | |
| "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:50)", | |
| "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:45)", | |
| "metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$eval213795$handle_audit_app_internal_queries__213796$fn__213797.invoke(handle_audit_queries.clj:143)", | |
| "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__123552.invoke(enterprise.clj:142)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$_AMPERSAND_f__128392.invoke(process_userland_query.clj:179)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$fn__128398.invoke(process_userland_query.clj:167)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$_AMPERSAND_f__128213.invoke(catch_exceptions.clj:137)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$fn__128228.invoke(catch_exceptions.clj:127)", | |
| "query_processor$fn__128737$process_query128736__128738$fn__128739.invoke(query_processor.clj:81)", | |
| "query_processor.setup$fn__126999$do_with_canceled_chan126998__127000$fn__127001.invoke(setup.clj:187)", | |
| "query_processor.setup$fn__126988$do_with_database_local_settings126987__126989$fn__126990.invoke(setup.clj:181)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979$fn__126980.invoke(setup.clj:166)", | |
| "driver$do_with_driver.invokeStatic(driver.clj:49)", | |
| "driver$do_with_driver.invoke(driver.clj:44)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979.invoke(setup.clj:165)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966$fn__126969.invoke(setup.clj:151)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:185)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:178)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966.invoke(setup.clj:150)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$_AMPERSAND_f__126946.invoke(setup.clj:128)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$fn__126949.invoke(setup.clj:122)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:232)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor$fn__128737$process_query128736__128738.invoke(query_processor.clj:79)", | |
| "query_processor$fn__128737$fn__128743.invoke(query_processor.clj:72)", | |
| "query_processor.api$fn__188362$run_streaming_query188361__188365$fn__188369.invoke(api.clj:87)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547$fn__107548.invoke(streaming.clj:213)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547.invoke(streaming.clj:211)", | |
| "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:202)", | |
| "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:189)", | |
| "query_processor.streaming$_streaming_response$fn__107546.invoke(streaming.clj:208)", | |
| "server.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:79)", | |
| "server.streaming_response$do_f_STAR_.invoke(streaming_response.clj:77)", | |
| "server.streaming_response$do_f_async$task__107076.invoke(streaming_response.clj:94)" | |
| ], | |
| "state": "42000" | |
| }, | |
| { | |
| "status": "failed", | |
| "class": "class clojure.lang.ExceptionInfo", | |
| "error": "Error executing query: (conn=18) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(order by `source`.`running_time_seconds`) AS `Percentile 90`, PERCENTILE_CONT(0' at line 2", | |
| "stacktrace": [ | |
| "--> driver.sql_jdbc.execute$execute_reducible_query$fn__152546$fn__152547.invoke(execute.clj:779)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546.invoke(execute.clj:776)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224$fn__152225.invoke(execute.clj:427)", | |
| "driver.sql_jdbc.execute$fn__152136$do_with_resolved_connection152135__152137.invoke(execute.clj:355)", | |
| "driver.sql_jdbc.execute$fn__152136$fn__152142.invoke(execute.clj:335)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224.invoke(execute.clj:421)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:769)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:758)", | |
| "driver.sql_jdbc$eval170038$fn__170039.invoke(sql_jdbc.clj:81)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105)", | |
| "query_processor.execute$run.invokeStatic(execute.clj:64)", | |
| "query_processor.execute$run.invoke(execute.clj:58)", | |
| "metabase_enterprise.database_routing.middleware$eval214004$swap_destination_db__214005$fn__214006.invoke(middleware.clj:30)", | |
| "query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)", | |
| "metabase_enterprise.impersonation.middleware$eval213982$apply_impersonation_postprocessing__213983$fn__213984.invoke(middleware.clj:25)", | |
| "query_processor.middleware.enterprise$apply_impersonation_postprocessing_middleware$fn__123487.invoke(enterprise.clj:48)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$_AMPERSAND_f__128050.invoke(update_used_cards.clj:67)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$fn__128060.invoke(update_used_cards.clj:59)", | |
| "query_processor.execute$add_native_form_to_result_metadata$fn__128072.invoke(execute.clj:25)", | |
| "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__128078.invoke(execute.clj:36)", | |
| "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___127718.invoke(cache.clj:241)", | |
| "query_processor.middleware.permissions$check_query_permissions$fn__125807.invoke(permissions.clj:149)", | |
| "metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$eval214984$check_download_permissions__214985$fn__214986.invoke(permissions.clj:97)", | |
| "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__123514.invoke(enterprise.clj:90)", | |
| "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$eval218750$maybe_apply_column_level_perms_check__218751$fn__218752.invoke(column_level_perms_check.clj:38)", | |
| "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__123524.invoke(enterprise.clj:103)", | |
| "query_processor.execute$fn__128112$execute128111__128113$fn__128114.invoke(execute.clj:96)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:225)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor.execute$fn__128112$execute128111__128113.invoke(execute.clj:95)", | |
| "query_processor.execute$fn__128112$fn__128117.invoke(execute.clj:91)", | |
| "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:50)", | |
| "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:45)", | |
| "metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$eval213795$handle_audit_app_internal_queries__213796$fn__213797.invoke(handle_audit_queries.clj:143)", | |
| "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__123552.invoke(enterprise.clj:142)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$_AMPERSAND_f__128392.invoke(process_userland_query.clj:179)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$fn__128398.invoke(process_userland_query.clj:167)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$_AMPERSAND_f__128213.invoke(catch_exceptions.clj:137)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$fn__128228.invoke(catch_exceptions.clj:127)", | |
| "query_processor$fn__128737$process_query128736__128738$fn__128739.invoke(query_processor.clj:81)", | |
| "query_processor.setup$fn__126999$do_with_canceled_chan126998__127000$fn__127001.invoke(setup.clj:187)", | |
| "query_processor.setup$fn__126988$do_with_database_local_settings126987__126989$fn__126990.invoke(setup.clj:181)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979$fn__126980.invoke(setup.clj:166)", | |
| "driver$do_with_driver.invokeStatic(driver.clj:49)", | |
| "driver$do_with_driver.invoke(driver.clj:44)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979.invoke(setup.clj:165)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966$fn__126969.invoke(setup.clj:151)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:185)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:178)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966.invoke(setup.clj:150)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$_AMPERSAND_f__126946.invoke(setup.clj:128)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$fn__126949.invoke(setup.clj:122)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:232)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor$fn__128737$process_query128736__128738.invoke(query_processor.clj:79)", | |
| "query_processor$fn__128737$fn__128743.invoke(query_processor.clj:72)", | |
| "query_processor.api$fn__188362$run_streaming_query188361__188365$fn__188369.invoke(api.clj:87)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547$fn__107548.invoke(streaming.clj:213)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547.invoke(streaming.clj:211)", | |
| "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:202)", | |
| "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:189)", | |
| "query_processor.streaming$_streaming_response$fn__107546.invoke(streaming.clj:208)", | |
| "server.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:79)", | |
| "server.streaming_response$do_f_STAR_.invoke(streaming_response.clj:77)", | |
| "server.streaming_response$do_f_async$task__107076.invoke(streaming_response.clj:94)" | |
| ], | |
| "error_type": "invalid-query", | |
| "ex-data": { | |
| "driver": "mysql", | |
| "sql": [ | |
| "-- Metabase:: userID: 13371339 queryType: MBQL queryHash: eb96ee24ee5e8b2863ea3e8463126b01b46b202a56c3a1526c0a0a6c45ec58f1", | |
| "SELECT", | |
| " STR_TO_DATE(", | |
| " CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'),", | |
| " '%X%V %W'", | |
| " ) AS `started_at`,", | |
| " PERCENTILE_CONT(0.9) within group (", | |
| " order by", | |
| " `source`.`running_time_seconds`", | |
| " ) AS `Percentile 90`,", | |
| " PERCENTILE_CONT(0.5) within group (", | |
| " order by", | |
| " `source`.`running_time_seconds`", | |
| " ) AS `Percentile 50`", | |
| "FROM", | |
| " (", | |
| " SELECT", | |
| " `v_query_log`.`entity_id` AS `entity_id`,", | |
| " `v_query_log`.`started_at` AS `started_at`,", | |
| " `v_query_log`.`running_time_seconds` AS `running_time_seconds`,", | |
| " `v_query_log`.`result_rows` AS `result_rows`,", | |
| " `v_query_log`.`is_native` AS `is_native`,", | |
| " `v_query_log`.`query_source` AS `query_source`,", | |
| " `v_query_log`.`error` AS `error`,", | |
| " `v_query_log`.`user_id` AS `user_id`,", | |
| " `v_query_log`.`card_id` AS `card_id`,", | |
| " `v_query_log`.`card_qualified_id` AS `card_qualified_id`,", | |
| " `v_query_log`.`dashboard_id` AS `dashboard_id`,", | |
| " `v_query_log`.`dashboard_qualified_id` AS `dashboard_qualified_id`,", | |
| " `v_query_log`.`pulse_id` AS `pulse_id`,", | |
| " `v_query_log`.`database_id` AS `database_id`,", | |
| " `v_query_log`.`database_qualified_id` AS `database_qualified_id`,", | |
| " `v_query_log`.`cache_hit` AS `cache_hit`,", | |
| " `v_query_log`.`action_id` AS `action_id`,", | |
| " `v_query_log`.`action_qualified_id` AS `action_qualified_id`,", | |
| " `v_query_log`.`query` AS `query`,", | |
| " `v_users__via__user_id`.`full_name` AS `v_users__via__user_id__full_name`,", | |
| " `v_content__via__card_qualified_id`.`name` AS `v_content__via__card_qualified_id__name`,", | |
| " `v_content__via__dashboard_qualified_id`.`name` AS `v_content__via__dashboard_qualified_id__name`,", | |
| " `v_databases__via__database_qualified_id`.`name` AS `v_databases__via__database_qualified_id__name`,", | |
| " `v_content__via__action_qualified_id`.`name` AS `v_content__via__action_qualified_id__name`", | |
| " FROM", | |
| " `v_query_log`", | |
| " LEFT JOIN `v_users` AS `v_users__via__user_id` ON `v_query_log`.`user_id` = `v_users__via__user_id`.`user_id`", | |
| " LEFT JOIN `v_content` AS `v_content__via__card_qualified_id` ON `v_query_log`.`card_qualified_id` = `v_content__via__card_qualified_id`.`entity_qualified_id`", | |
| " LEFT JOIN `v_content` AS `v_content__via__dashboard_qualified_id` ON `v_query_log`.`dashboard_qualified_id` = `v_content__via__dashboard_qualified_id`.`entity_qualified_id`", | |
| " LEFT JOIN `v_databases` AS `v_databases__via__database_qualified_id` ON `v_query_log`.`database_qualified_id` = `v_databases__via__database_qualified_id`.`entity_qualified_id`", | |
| " LEFT JOIN `v_content` AS `v_content__via__action_qualified_id` ON `v_query_log`.`action_qualified_id` = `v_content__via__action_qualified_id`.`entity_qualified_id`", | |
| " ) AS `source`", | |
| "WHERE", | |
| " (", | |
| " `source`.`started_at` >= STR_TO_DATE(", | |
| " CONCAT(", | |
| " YEARWEEK(DATE_ADD(NOW(6), INTERVAL -52 week)),", | |
| " ' Sunday'", | |
| " ),", | |
| " '%X%V %W'", | |
| " )", | |
| " )", | |
| " AND (", | |
| " `source`.`started_at` < CAST(", | |
| " STR_TO_DATE(CONCAT(YEARWEEK(NOW(6)), ' Sunday'), '%X%V %W') AS datetime", | |
| " )", | |
| " )", | |
| " AND (`source`.`cache_hit` IS NOT NULL)", | |
| "GROUP BY", | |
| " STR_TO_DATE(", | |
| " CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'),", | |
| " '%X%V %W'", | |
| " )", | |
| "ORDER BY", | |
| " STR_TO_DATE(", | |
| " CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'),", | |
| " '%X%V %W'", | |
| " ) ASC", | |
| "LIMIT", | |
| " 10" | |
| ], | |
| "params": null, | |
| "type": "invalid-query" | |
| } | |
| } | |
| ], | |
| "action_id": null, | |
| "state": "42000", | |
| "error_type": "invalid-query", | |
| "json_query": { | |
| "database": 13371337, | |
| "type": "query", | |
| "query": { | |
| "aggregation": [ | |
| [ | |
| "aggregation-options", | |
| [ | |
| "percentile", | |
| [ | |
| "field", | |
| "running_time_seconds", | |
| { | |
| "base-type": "type/Float" | |
| } | |
| ], | |
| 0.9 | |
| ], | |
| { | |
| "name": "Percentile 90", | |
| "display-name": "Percentile 90" | |
| } | |
| ], | |
| [ | |
| "aggregation-options", | |
| [ | |
| "percentile", | |
| [ | |
| "field", | |
| "running_time_seconds", | |
| { | |
| "base-type": "type/Float" | |
| } | |
| ], | |
| 0.5 | |
| ], | |
| { | |
| "name": "Percentile 50", | |
| "display-name": "Percentile 50" | |
| } | |
| ] | |
| ], | |
| "breakout": [ | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ", | |
| "temporal-unit": "week" | |
| } | |
| ] | |
| ], | |
| "limit": 10, | |
| "source-table": "card__38", | |
| "filter": [ | |
| "and", | |
| [ | |
| "time-interval", | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ" | |
| } | |
| ], | |
| -52, | |
| "week" | |
| ], | |
| [ | |
| "not-null", | |
| [ | |
| "field", | |
| "cache_hit", | |
| { | |
| "base-type": "type/Boolean" | |
| } | |
| ] | |
| ] | |
| ] | |
| }, | |
| "parameters": [], | |
| "middleware": { | |
| "js-int-to-string?": true, | |
| "userland-query?": true, | |
| "add-default-userland-constraints?": true | |
| } | |
| }, | |
| "native": { | |
| "query": "SELECT STR_TO_DATE(CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'), '%X%V %W') AS `started_at`, PERCENTILE_CONT(0.9) within group (order by `source`.`running_time_seconds`) AS `Percentile 90`, PERCENTILE_CONT(0.5) within group (order by `source`.`running_time_seconds`) AS `Percentile 50` FROM (SELECT `v_query_log`.`entity_id` AS `entity_id`, `v_query_log`.`started_at` AS `started_at`, `v_query_log`.`running_time_seconds` AS `running_time_seconds`, `v_query_log`.`result_rows` AS `result_rows`, `v_query_log`.`is_native` AS `is_native`, `v_query_log`.`query_source` AS `query_source`, `v_query_log`.`error` AS `error`, `v_query_log`.`user_id` AS `user_id`, `v_query_log`.`card_id` AS `card_id`, `v_query_log`.`card_qualified_id` AS `card_qualified_id`, `v_query_log`.`dashboard_id` AS `dashboard_id`, `v_query_log`.`dashboard_qualified_id` AS `dashboard_qualified_id`, `v_query_log`.`pulse_id` AS `pulse_id`, `v_query_log`.`database_id` AS `database_id`, `v_query_log`.`database_qualified_id` AS `database_qualified_id`, `v_query_log`.`cache_hit` AS `cache_hit`, `v_query_log`.`action_id` AS `action_id`, `v_query_log`.`action_qualified_id` AS `action_qualified_id`, `v_query_log`.`query` AS `query`, `v_users__via__user_id`.`full_name` AS `v_users__via__user_id__full_name`, `v_content__via__card_qualified_id`.`name` AS `v_content__via__card_qualified_id__name`, `v_content__via__dashboard_qualified_id`.`name` AS `v_content__via__dashboard_qualified_id__name`, `v_databases__via__database_qualified_id`.`name` AS `v_databases__via__database_qualified_id__name`, `v_content__via__action_qualified_id`.`name` AS `v_content__via__action_qualified_id__name` FROM `v_query_log` LEFT JOIN `v_users` AS `v_users__via__user_id` ON `v_query_log`.`user_id` = `v_users__via__user_id`.`user_id` LEFT JOIN `v_content` AS `v_content__via__card_qualified_id` ON `v_query_log`.`card_qualified_id` = `v_content__via__card_qualified_id`.`entity_qualified_id` LEFT JOIN `v_content` AS `v_content__via__dashboard_qualified_id` ON `v_query_log`.`dashboard_qualified_id` = `v_content__via__dashboard_qualified_id`.`entity_qualified_id` LEFT JOIN `v_databases` AS `v_databases__via__database_qualified_id` ON `v_query_log`.`database_qualified_id` = `v_databases__via__database_qualified_id`.`entity_qualified_id` LEFT JOIN `v_content` AS `v_content__via__action_qualified_id` ON `v_query_log`.`action_qualified_id` = `v_content__via__action_qualified_id`.`entity_qualified_id`) AS `source` WHERE (`source`.`started_at` >= STR_TO_DATE(CONCAT(YEARWEEK(DATE_ADD(NOW(6), INTERVAL -52 week)), ' Sunday'), '%X%V %W')) AND (`source`.`started_at` < CAST(STR_TO_DATE(CONCAT(YEARWEEK(NOW(6)), ' Sunday'), '%X%V %W') AS datetime)) AND (`source`.`cache_hit` IS NOT NULL) GROUP BY STR_TO_DATE(CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'), '%X%V %W') ORDER BY STR_TO_DATE(CONCAT(YEARWEEK(`source`.`started_at`), ' Sunday'), '%X%V %W') ASC LIMIT 10", | |
| "params": null | |
| }, | |
| "status": "failed", | |
| "class": "class java.sql.SQLException", | |
| "stacktrace": [ | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1693)", | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1555)", | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1518)", | |
| "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:257)", | |
| "org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)", | |
| "org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)", | |
| "com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1341)", | |
| "--> driver.sql_jdbc.execute$eval152402$fn__152403.invoke(execute.clj:592)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:600)", | |
| "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:597)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546$fn__152547.invoke(execute.clj:777)", | |
| "driver.sql_jdbc.execute$execute_reducible_query$fn__152546.invoke(execute.clj:776)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224$fn__152225.invoke(execute.clj:427)", | |
| "driver.sql_jdbc.execute$fn__152136$do_with_resolved_connection152135__152137.invoke(execute.clj:355)", | |
| "driver.sql_jdbc.execute$fn__152136$fn__152142.invoke(execute.clj:335)", | |
| "driver.sql_jdbc.execute$eval152223$fn__152224.invoke(execute.clj:421)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:769)", | |
| "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:758)", | |
| "driver.sql_jdbc$eval170038$fn__170039.invoke(sql_jdbc.clj:81)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:58)", | |
| "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:43)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:116)", | |
| "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:105)", | |
| "query_processor.execute$run.invokeStatic(execute.clj:64)", | |
| "query_processor.execute$run.invoke(execute.clj:58)", | |
| "metabase_enterprise.database_routing.middleware$eval214004$swap_destination_db__214005$fn__214006.invoke(middleware.clj:30)", | |
| "query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)", | |
| "metabase_enterprise.impersonation.middleware$eval213982$apply_impersonation_postprocessing__213983$fn__213984.invoke(middleware.clj:25)", | |
| "query_processor.middleware.enterprise$apply_impersonation_postprocessing_middleware$fn__123487.invoke(enterprise.clj:48)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$_AMPERSAND_f__128050.invoke(update_used_cards.clj:67)", | |
| "query_processor.middleware.update_used_cards$fn__128048$update_used_cards_BANG_128047__128049$fn__128060.invoke(update_used_cards.clj:59)", | |
| "query_processor.execute$add_native_form_to_result_metadata$fn__128072.invoke(execute.clj:25)", | |
| "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__128078.invoke(execute.clj:36)", | |
| "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___127718.invoke(cache.clj:241)", | |
| "query_processor.middleware.permissions$check_query_permissions$fn__125807.invoke(permissions.clj:149)", | |
| "metabase_enterprise.advanced_permissions.query_processor.middleware.permissions$eval214984$check_download_permissions__214985$fn__214986.invoke(permissions.clj:97)", | |
| "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__123514.invoke(enterprise.clj:90)", | |
| "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$eval218750$maybe_apply_column_level_perms_check__218751$fn__218752.invoke(column_level_perms_check.clj:38)", | |
| "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__123524.invoke(enterprise.clj:103)", | |
| "query_processor.execute$fn__128112$execute128111__128113$fn__128114.invoke(execute.clj:96)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:225)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor.execute$fn__128112$execute128111__128113.invoke(execute.clj:95)", | |
| "query_processor.execute$fn__128112$fn__128117.invoke(execute.clj:91)", | |
| "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:50)", | |
| "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:45)", | |
| "metabase_enterprise.audit_app.query_processor.middleware.handle_audit_queries$eval213795$handle_audit_app_internal_queries__213796$fn__213797.invoke(handle_audit_queries.clj:143)", | |
| "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__123552.invoke(enterprise.clj:142)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$_AMPERSAND_f__128392.invoke(process_userland_query.clj:179)", | |
| "query_processor.middleware.process_userland_query$fn__128390$process_userland_query_middleware128389__128391$fn__128398.invoke(process_userland_query.clj:167)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$_AMPERSAND_f__128213.invoke(catch_exceptions.clj:137)", | |
| "query_processor.middleware.catch_exceptions$fn__128211$catch_exceptions128210__128212$fn__128228.invoke(catch_exceptions.clj:127)", | |
| "query_processor$fn__128737$process_query128736__128738$fn__128739.invoke(query_processor.clj:81)", | |
| "query_processor.setup$fn__126999$do_with_canceled_chan126998__127000$fn__127001.invoke(setup.clj:187)", | |
| "query_processor.setup$fn__126988$do_with_database_local_settings126987__126989$fn__126990.invoke(setup.clj:181)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979$fn__126980.invoke(setup.clj:166)", | |
| "driver$do_with_driver.invokeStatic(driver.clj:49)", | |
| "driver$do_with_driver.invoke(driver.clj:44)", | |
| "query_processor.setup$fn__126977$do_with_driver126976__126978$fn__126979.invoke(setup.clj:165)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966$fn__126969.invoke(setup.clj:151)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:185)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.store$fn__95751$do_with_metadata_provider95750__95752.invoke(store.clj:178)", | |
| "query_processor.store$fn__95751$fn__95755.invoke(store.clj:171)", | |
| "query_processor.setup$fn__126964$do_with_metadata_provider126963__126965$fn__126966.invoke(setup.clj:150)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$_AMPERSAND_f__126946.invoke(setup.clj:128)", | |
| "query_processor.setup$fn__126944$do_with_resolved_database126943__126945$fn__126949.invoke(setup.clj:122)", | |
| "query_processor.setup$fn__127008$do_with_qp_setup127007__127009.invoke(setup.clj:232)", | |
| "query_processor.setup$fn__127008$fn__127013.invoke(setup.clj:216)", | |
| "query_processor$fn__128737$process_query128736__128738.invoke(query_processor.clj:79)", | |
| "query_processor$fn__128737$fn__128743.invoke(query_processor.clj:72)", | |
| "query_processor.api$fn__188362$run_streaming_query188361__188365$fn__188369.invoke(api.clj:87)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547$fn__107548.invoke(streaming.clj:213)", | |
| "query_processor.streaming$_streaming_response$fn__107546$fn__107547.invoke(streaming.clj:211)", | |
| "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:202)", | |
| "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:189)", | |
| "query_processor.streaming$_streaming_response$fn__107546.invoke(streaming.clj:208)", | |
| "server.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:79)", | |
| "server.streaming_response$do_f_STAR_.invoke(streaming_response.clj:77)", | |
| "server.streaming_response$do_f_async$task__107076.invoke(streaming_response.clj:94)" | |
| ], | |
| "card_id": 38, | |
| "context": "ad-hoc", | |
| "error": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(order by `source`.`running_time_seconds`) AS `Percentile 90`, PERCENTILE_CONT(0' at line 2", | |
| "row_count": 0, | |
| "running_time": 0, | |
| "preprocessed": { | |
| "constraints": { | |
| "max-results": 10000, | |
| "max-results-bare-rows": 2000 | |
| }, | |
| "middleware": { | |
| "js-int-to-string?": true, | |
| "userland-query?": true, | |
| "add-default-userland-constraints?": true | |
| }, | |
| "qp/source-card-id": 38, | |
| "database": 13371337, | |
| "metabase.query-processor.middleware.add-remaps/external-remaps": [ | |
| { | |
| "id": 9, | |
| "name": "User ID", | |
| "field-id": 91, | |
| "field-name": "user_id", | |
| "human-readable-field-id": 90, | |
| "human-readable-field-name": "full_name" | |
| }, | |
| { | |
| "id": 7, | |
| "name": "Card Qualified ID", | |
| "field-id": 76, | |
| "field-name": "card_qualified_id", | |
| "human-readable-field-id": 74, | |
| "human-readable-field-name": "name" | |
| }, | |
| { | |
| "id": 8, | |
| "name": "Dashboard Qualified ID", | |
| "field-id": 77, | |
| "field-name": "dashboard_qualified_id", | |
| "human-readable-field-id": 74, | |
| "human-readable-field-name": "name_2" | |
| }, | |
| { | |
| "id": 10, | |
| "name": "Database Qualified ID", | |
| "field-id": 94, | |
| "field-name": "database_qualified_id", | |
| "human-readable-field-id": 93, | |
| "human-readable-field-name": "name_3" | |
| }, | |
| { | |
| "id": 11, | |
| "name": "Action Qualified ID", | |
| "field-id": 95, | |
| "field-name": "action_qualified_id", | |
| "human-readable-field-id": 74, | |
| "human-readable-field-name": "name_4" | |
| } | |
| ], | |
| "info": { | |
| "executed-by": 13371339, | |
| "context": "ad-hoc", | |
| "card-id": 38, | |
| "metadata/model-metadata": [ | |
| { | |
| "semantic_type": "type/PK", | |
| "name": "entity_id", | |
| "field_ref": [ | |
| "field", | |
| 87, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 87, | |
| "visibility_type": "normal", | |
| "display_name": "Entity ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/CreationTimestamp", | |
| "unit": "default", | |
| "name": "started_at", | |
| "field_ref": [ | |
| "field", | |
| 84, | |
| { | |
| "temporal-unit": "default" | |
| } | |
| ], | |
| "effective_type": "type/DateTimeWithLocalTZ", | |
| "id": 84, | |
| "visibility_type": "normal", | |
| "display_name": "Started At", | |
| "base_type": "type/DateTimeWithLocalTZ" | |
| }, | |
| { | |
| "name": "running_time_seconds", | |
| "field_ref": [ | |
| "field", | |
| 88, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "id": 88, | |
| "visibility_type": "normal", | |
| "display_name": "Running Time Seconds", | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "name": "result_rows", | |
| "field_ref": [ | |
| "field", | |
| 86, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 86, | |
| "visibility_type": "normal", | |
| "display_name": "Result Rows", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/Category", | |
| "name": "is_native", | |
| "field_ref": [ | |
| "field", | |
| 72, | |
| null | |
| ], | |
| "effective_type": "type/Boolean", | |
| "id": 72, | |
| "visibility_type": "normal", | |
| "display_name": "Is Native", | |
| "base_type": "type/Boolean" | |
| }, | |
| { | |
| "semantic_type": "type/Source", | |
| "name": "query_source", | |
| "field_ref": [ | |
| "field", | |
| 81, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 81, | |
| "visibility_type": "normal", | |
| "display_name": "Query Source", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "name": "error", | |
| "field_ref": [ | |
| "field", | |
| 92, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 92, | |
| "visibility_type": "normal", | |
| "display_name": "Error", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "semantic_type": "type/FK", | |
| "name": "user_id", | |
| "fk_target_field_id": 82, | |
| "field_ref": [ | |
| "field", | |
| 91, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 91, | |
| "visibility_type": "normal", | |
| "display_name": "User ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "name": "card_id", | |
| "field_ref": [ | |
| "field", | |
| 78, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 78, | |
| "visibility_type": "details-only", | |
| "display_name": "Card ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/FK", | |
| "name": "card_qualified_id", | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 76, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 76, | |
| "visibility_type": "normal", | |
| "display_name": "Card Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "name": "dashboard_id", | |
| "field_ref": [ | |
| "field", | |
| 96, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 96, | |
| "visibility_type": "details-only", | |
| "display_name": "Dashboard ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/FK", | |
| "name": "dashboard_qualified_id", | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 77, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 77, | |
| "visibility_type": "normal", | |
| "display_name": "Dashboard Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "name": "pulse_id", | |
| "field_ref": [ | |
| "field", | |
| 85, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 85, | |
| "visibility_type": "normal", | |
| "display_name": "Pulse ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "name": "database_id", | |
| "field_ref": [ | |
| "field", | |
| 80, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 80, | |
| "visibility_type": "details-only", | |
| "display_name": "Database ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/FK", | |
| "name": "database_qualified_id", | |
| "fk_target_field_id": 73, | |
| "field_ref": [ | |
| "field", | |
| 94, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 94, | |
| "visibility_type": "normal", | |
| "display_name": "Database Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "semantic_type": "type/Category", | |
| "name": "cache_hit", | |
| "field_ref": [ | |
| "field", | |
| 83, | |
| null | |
| ], | |
| "effective_type": "type/Boolean", | |
| "id": 83, | |
| "visibility_type": "normal", | |
| "display_name": "Cache Hit", | |
| "base_type": "type/Boolean" | |
| }, | |
| { | |
| "name": "action_id", | |
| "field_ref": [ | |
| "field", | |
| 79, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "id": 79, | |
| "visibility_type": "details-only", | |
| "display_name": "Action ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "semantic_type": "type/FK", | |
| "name": "action_qualified_id", | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 95, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 95, | |
| "visibility_type": "normal", | |
| "display_name": "Action Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "semantic_type": "type/SerializedJSON", | |
| "name": "query", | |
| "field_ref": [ | |
| "field", | |
| 89, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "id": 89, | |
| "visibility_type": "normal", | |
| "display_name": "Query", | |
| "base_type": "type/Text" | |
| } | |
| ] | |
| }, | |
| "type": "query", | |
| "query": { | |
| "limit": 10, | |
| "source-query": { | |
| "source-table": 10, | |
| "qp/stage-is-from-source-card": 38, | |
| "fields": [ | |
| [ | |
| "field", | |
| 87, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 84, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 88, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 86, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 72, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 81, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 92, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 91, | |
| { | |
| "metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 9 | |
| } | |
| ], | |
| [ | |
| "field", | |
| 78, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 76, | |
| { | |
| "metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 7 | |
| } | |
| ], | |
| [ | |
| "field", | |
| 96, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 77, | |
| { | |
| "metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 8 | |
| } | |
| ], | |
| [ | |
| "field", | |
| 85, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 80, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 94, | |
| { | |
| "metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 10 | |
| } | |
| ], | |
| [ | |
| "field", | |
| 83, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 79, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 95, | |
| { | |
| "metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 11 | |
| } | |
| ], | |
| [ | |
| "field", | |
| 89, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 90, | |
| { | |
| "source-field": 91, | |
| "metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 9, | |
| "join-alias": "v_users__via__user_id" | |
| } | |
| ], | |
| [ | |
| "field", | |
| 74, | |
| { | |
| "source-field": 76, | |
| "metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 7, | |
| "join-alias": "v_content__via__card_qualified_id" | |
| } | |
| ], | |
| [ | |
| "field", | |
| 74, | |
| { | |
| "source-field": 77, | |
| "metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 8, | |
| "join-alias": "v_content__via__dashboard_qualified_id" | |
| } | |
| ], | |
| [ | |
| "field", | |
| 93, | |
| { | |
| "source-field": 94, | |
| "metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 10, | |
| "join-alias": "v_databases__via__database_qualified_id" | |
| } | |
| ], | |
| [ | |
| "field", | |
| 74, | |
| { | |
| "source-field": 95, | |
| "metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 11, | |
| "join-alias": "v_content__via__action_qualified_id" | |
| } | |
| ] | |
| ], | |
| "joins": [ | |
| { | |
| "alias": "v_users__via__user_id", | |
| "strategy": "left-join", | |
| "qp/is-implicit-join": true, | |
| "fk-field-id": 91, | |
| "condition": [ | |
| "=", | |
| [ | |
| "field", | |
| 91, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 82, | |
| { | |
| "join-alias": "v_users__via__user_id" | |
| } | |
| ] | |
| ], | |
| "source-table": 13 | |
| }, | |
| { | |
| "alias": "v_content__via__card_qualified_id", | |
| "strategy": "left-join", | |
| "qp/is-implicit-join": true, | |
| "fk-field-id": 76, | |
| "condition": [ | |
| "=", | |
| [ | |
| "field", | |
| 76, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 75, | |
| { | |
| "join-alias": "v_content__via__card_qualified_id" | |
| } | |
| ] | |
| ], | |
| "source-table": 12 | |
| }, | |
| { | |
| "alias": "v_content__via__dashboard_qualified_id", | |
| "strategy": "left-join", | |
| "qp/is-implicit-join": true, | |
| "fk-field-id": 77, | |
| "condition": [ | |
| "=", | |
| [ | |
| "field", | |
| 77, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 75, | |
| { | |
| "join-alias": "v_content__via__dashboard_qualified_id" | |
| } | |
| ] | |
| ], | |
| "source-table": 12 | |
| }, | |
| { | |
| "alias": "v_databases__via__database_qualified_id", | |
| "strategy": "left-join", | |
| "qp/is-implicit-join": true, | |
| "fk-field-id": 94, | |
| "condition": [ | |
| "=", | |
| [ | |
| "field", | |
| 94, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 73, | |
| { | |
| "join-alias": "v_databases__via__database_qualified_id" | |
| } | |
| ] | |
| ], | |
| "source-table": 11 | |
| }, | |
| { | |
| "alias": "v_content__via__action_qualified_id", | |
| "strategy": "left-join", | |
| "qp/is-implicit-join": true, | |
| "fk-field-id": 95, | |
| "condition": [ | |
| "=", | |
| [ | |
| "field", | |
| 95, | |
| null | |
| ], | |
| [ | |
| "field", | |
| 75, | |
| { | |
| "join-alias": "v_content__via__action_qualified_id" | |
| } | |
| ] | |
| ], | |
| "source-table": 12 | |
| } | |
| ], | |
| "metabase.query-processor.middleware.add-implicit-joins/reused-join-aliases": [] | |
| }, | |
| "source-metadata": [ | |
| { | |
| "database_type": "INT", | |
| "semantic_type": "type/PK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "entity_id", | |
| "lib/original-name": "entity_id", | |
| "lib/breakout?": false, | |
| "name": "entity_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "entity_id", | |
| "lib/model-display-name": "Entity ID", | |
| "field_ref": [ | |
| "field", | |
| 87, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 87, | |
| "lib/desired-column-alias": "entity_id", | |
| "position": 0, | |
| "visibility_type": "normal", | |
| "display_name": "Entity ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "TIMESTAMP", | |
| "semantic_type": "type/CreationTimestamp", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "started_at", | |
| "lib/original-name": "started_at", | |
| "lib/breakout?": false, | |
| "unit": "default", | |
| "name": "started_at", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "started_at", | |
| "lib/model-display-name": "Started At", | |
| "field_ref": [ | |
| "field", | |
| 84, | |
| { | |
| "temporal-unit": "default" | |
| } | |
| ], | |
| "effective_type": "type/DateTimeWithLocalTZ", | |
| "active": true, | |
| "id": 84, | |
| "lib/desired-column-alias": "started_at", | |
| "position": 1, | |
| "visibility_type": "normal", | |
| "display_name": "Started At", | |
| "base_type": "type/DateTimeWithLocalTZ" | |
| }, | |
| { | |
| "database_type": "DOUBLE", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "running_time_seconds", | |
| "lib/original-name": "running_time_seconds", | |
| "lib/breakout?": false, | |
| "name": "running_time_seconds", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "running_time_seconds", | |
| "lib/model-display-name": "Running Time Seconds", | |
| "field_ref": [ | |
| "field", | |
| 88, | |
| null | |
| ], | |
| "effective_type": "type/Float", | |
| "active": true, | |
| "id": 88, | |
| "lib/desired-column-alias": "running_time_seconds", | |
| "position": 2, | |
| "visibility_type": "normal", | |
| "display_name": "Running Time Seconds", | |
| "base_type": "type/Float" | |
| }, | |
| { | |
| "description": "Number of rows in the query results.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "result_rows", | |
| "lib/original-name": "result_rows", | |
| "lib/breakout?": false, | |
| "name": "result_rows", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "result_rows", | |
| "lib/model-display-name": "Result Rows", | |
| "field_ref": [ | |
| "field", | |
| 86, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 86, | |
| "lib/desired-column-alias": "result_rows", | |
| "position": 3, | |
| "visibility_type": "normal", | |
| "display_name": "Result Rows", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "BIT", | |
| "semantic_type": "type/Category", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "is_native", | |
| "lib/original-name": "is_native", | |
| "lib/breakout?": false, | |
| "name": "is_native", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "is_native", | |
| "lib/model-display-name": "Is Native", | |
| "field_ref": [ | |
| "field", | |
| 72, | |
| null | |
| ], | |
| "effective_type": "type/Boolean", | |
| "active": true, | |
| "id": 72, | |
| "lib/desired-column-alias": "is_native", | |
| "position": 4, | |
| "visibility_type": "normal", | |
| "display_name": "Is Native", | |
| "base_type": "type/Boolean" | |
| }, | |
| { | |
| "description": "Short string specifying how this query was executed, e.g. in a Dashboard or Pulse.", | |
| "database_type": "VARCHAR", | |
| "semantic_type": "type/Source", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "query_source", | |
| "lib/original-name": "query_source", | |
| "lib/breakout?": false, | |
| "name": "query_source", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "query_source", | |
| "lib/model-display-name": "Query Source", | |
| "field_ref": [ | |
| "field", | |
| 81, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 81, | |
| "lib/desired-column-alias": "query_source", | |
| "position": 5, | |
| "visibility_type": "normal", | |
| "display_name": "Query Source", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "LONGTEXT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "error", | |
| "lib/original-name": "error", | |
| "lib/breakout?": false, | |
| "name": "error", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "error", | |
| "lib/model-display-name": "Error", | |
| "field_ref": [ | |
| "field", | |
| 92, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 92, | |
| "lib/desired-column-alias": "error", | |
| "position": 6, | |
| "visibility_type": "normal", | |
| "display_name": "Error", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "BIGINT", | |
| "semantic_type": "type/FK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "user_id", | |
| "lib/original-name": "user_id", | |
| "lib/breakout?": false, | |
| "name": "user_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "user_id", | |
| "lib/model-display-name": "User ID", | |
| "lib/external-remap": { | |
| "lib/type": "metadata.column.remapping/external", | |
| "id": 9, | |
| "name": "User ID", | |
| "field-id": 90 | |
| }, | |
| "fk_target_field_id": 82, | |
| "field_ref": [ | |
| "field", | |
| 91, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 91, | |
| "lib/desired-column-alias": "user_id", | |
| "position": 7, | |
| "visibility_type": "normal", | |
| "display_name": "User ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "description": "The ID of the Card (Question) associated with this query execution, if any.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "card_id", | |
| "lib/original-name": "card_id", | |
| "lib/breakout?": false, | |
| "name": "card_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "card_id", | |
| "lib/model-display-name": "Card ID", | |
| "field_ref": [ | |
| "field", | |
| 78, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 78, | |
| "lib/desired-column-alias": "card_id", | |
| "position": 8, | |
| "visibility_type": "details-only", | |
| "display_name": "Card ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "VARCHAR", | |
| "semantic_type": "type/FK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "card_qualified_id", | |
| "lib/original-name": "card_qualified_id", | |
| "lib/breakout?": false, | |
| "name": "card_qualified_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "card_qualified_id", | |
| "lib/model-display-name": "Card Qualified ID", | |
| "lib/external-remap": { | |
| "lib/type": "metadata.column.remapping/external", | |
| "id": 7, | |
| "name": "Card Qualified ID", | |
| "field-id": 74 | |
| }, | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 76, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 76, | |
| "lib/desired-column-alias": "card_qualified_id", | |
| "position": 9, | |
| "visibility_type": "normal", | |
| "display_name": "Card Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "description": "The ID of the Dashboard associated with this query execution, if any.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "dashboard_id", | |
| "lib/original-name": "dashboard_id", | |
| "lib/breakout?": false, | |
| "name": "dashboard_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "dashboard_id", | |
| "lib/model-display-name": "Dashboard ID", | |
| "field_ref": [ | |
| "field", | |
| 96, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 96, | |
| "lib/desired-column-alias": "dashboard_id", | |
| "position": 10, | |
| "visibility_type": "details-only", | |
| "display_name": "Dashboard ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "VARCHAR", | |
| "semantic_type": "type/FK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "dashboard_qualified_id", | |
| "lib/original-name": "dashboard_qualified_id", | |
| "lib/breakout?": false, | |
| "name": "dashboard_qualified_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "dashboard_qualified_id", | |
| "lib/model-display-name": "Dashboard Qualified ID", | |
| "lib/external-remap": { | |
| "lib/type": "metadata.column.remapping/external", | |
| "id": 8, | |
| "name": "Dashboard Qualified ID", | |
| "field-id": 74 | |
| }, | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 77, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 77, | |
| "lib/desired-column-alias": "dashboard_qualified_id", | |
| "position": 11, | |
| "visibility_type": "normal", | |
| "display_name": "Dashboard Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "description": "The ID of the Pulse associated with this query execution, if any.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "pulse_id", | |
| "lib/original-name": "pulse_id", | |
| "lib/breakout?": false, | |
| "name": "pulse_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "pulse_id", | |
| "lib/model-display-name": "Pulse ID", | |
| "field_ref": [ | |
| "field", | |
| 85, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 85, | |
| "lib/desired-column-alias": "pulse_id", | |
| "position": 12, | |
| "visibility_type": "normal", | |
| "display_name": "Pulse ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "description": "ID of the database this query was ran against.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "database_id", | |
| "lib/original-name": "database_id", | |
| "lib/breakout?": false, | |
| "name": "database_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "database_id", | |
| "lib/model-display-name": "Database ID", | |
| "field_ref": [ | |
| "field", | |
| 80, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 80, | |
| "lib/desired-column-alias": "database_id", | |
| "position": 13, | |
| "visibility_type": "details-only", | |
| "display_name": "Database ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "VARCHAR", | |
| "semantic_type": "type/FK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "database_qualified_id", | |
| "lib/original-name": "database_qualified_id", | |
| "lib/breakout?": false, | |
| "name": "database_qualified_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "database_qualified_id", | |
| "lib/model-display-name": "Database Qualified ID", | |
| "lib/external-remap": { | |
| "lib/type": "metadata.column.remapping/external", | |
| "id": 10, | |
| "name": "Database Qualified ID", | |
| "field-id": 93 | |
| }, | |
| "fk_target_field_id": 73, | |
| "field_ref": [ | |
| "field", | |
| 94, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 94, | |
| "lib/desired-column-alias": "database_qualified_id", | |
| "position": 14, | |
| "visibility_type": "normal", | |
| "display_name": "Database Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "BIT", | |
| "semantic_type": "type/Category", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "cache_hit", | |
| "lib/original-name": "cache_hit", | |
| "lib/breakout?": false, | |
| "name": "cache_hit", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "cache_hit", | |
| "lib/model-display-name": "Cache Hit", | |
| "field_ref": [ | |
| "field", | |
| 83, | |
| null | |
| ], | |
| "effective_type": "type/Boolean", | |
| "active": true, | |
| "id": 83, | |
| "lib/desired-column-alias": "cache_hit", | |
| "position": 15, | |
| "visibility_type": "normal", | |
| "display_name": "Cache Hit", | |
| "base_type": "type/Boolean" | |
| }, | |
| { | |
| "description": "The ID of the action associated with this query execution, if any.", | |
| "database_type": "INT", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "action_id", | |
| "lib/original-name": "action_id", | |
| "lib/breakout?": false, | |
| "name": "action_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "action_id", | |
| "lib/model-display-name": "Action ID", | |
| "field_ref": [ | |
| "field", | |
| 79, | |
| null | |
| ], | |
| "effective_type": "type/Integer", | |
| "active": true, | |
| "id": 79, | |
| "lib/desired-column-alias": "action_id", | |
| "position": 16, | |
| "visibility_type": "details-only", | |
| "display_name": "Action ID", | |
| "base_type": "type/Integer" | |
| }, | |
| { | |
| "database_type": "VARCHAR", | |
| "semantic_type": "type/FK", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "action_qualified_id", | |
| "lib/original-name": "action_qualified_id", | |
| "lib/breakout?": false, | |
| "name": "action_qualified_id", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "action_qualified_id", | |
| "lib/model-display-name": "Action Qualified ID", | |
| "lib/external-remap": { | |
| "lib/type": "metadata.column.remapping/external", | |
| "id": 11, | |
| "name": "Action Qualified ID", | |
| "field-id": 74 | |
| }, | |
| "fk_target_field_id": 75, | |
| "field_ref": [ | |
| "field", | |
| 95, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 95, | |
| "lib/desired-column-alias": "action_qualified_id", | |
| "position": 17, | |
| "visibility_type": "normal", | |
| "display_name": "Action Qualified ID", | |
| "base_type": "type/Text" | |
| }, | |
| { | |
| "database_type": "LONGTEXT", | |
| "semantic_type": "type/SerializedJSON", | |
| "table_id": 10, | |
| "lib/deduplicated-name": "query", | |
| "lib/original-name": "query", | |
| "lib/breakout?": false, | |
| "name": "query", | |
| "lib/card-id": 38, | |
| "lib/source": "source/card", | |
| "lib/source-column-alias": "query", | |
| "lib/model-display-name": "Query", | |
| "field_ref": [ | |
| "field", | |
| 89, | |
| null | |
| ], | |
| "effective_type": "type/Text", | |
| "active": true, | |
| "id": 89, | |
| "lib/desired-column-alias": "query", | |
| "position": 18, | |
| "visibility_type": "normal", | |
| "display_name": "Query", | |
| "base_type": "type/Text" | |
| } | |
| ], | |
| "filter": [ | |
| "and", | |
| [ | |
| ">=", | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ", | |
| "temporal-unit": "default" | |
| } | |
| ], | |
| [ | |
| "relative-datetime", | |
| -52, | |
| "week" | |
| ] | |
| ], | |
| [ | |
| "<", | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ", | |
| "temporal-unit": "default" | |
| } | |
| ], | |
| [ | |
| "relative-datetime", | |
| 0, | |
| "week" | |
| ] | |
| ], | |
| [ | |
| "!=", | |
| [ | |
| "field", | |
| "cache_hit", | |
| { | |
| "base-type": "type/Boolean" | |
| } | |
| ], | |
| [ | |
| "value", | |
| null, | |
| { | |
| "base_type": "type/Boolean", | |
| "database_type": "BIT" | |
| } | |
| ] | |
| ] | |
| ], | |
| "source-query/model?": true, | |
| "breakout": [ | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ", | |
| "temporal-unit": "week" | |
| } | |
| ] | |
| ], | |
| "order-by": [ | |
| [ | |
| "asc", | |
| [ | |
| "field", | |
| "started_at", | |
| { | |
| "base-type": "type/DateTimeWithLocalTZ", | |
| "temporal-unit": "week" | |
| } | |
| ] | |
| ] | |
| ], | |
| "aggregation": [ | |
| [ | |
| "aggregation-options", | |
| [ | |
| "percentile", | |
| [ | |
| "field", | |
| "running_time_seconds", | |
| { | |
| "base-type": "type/Float" | |
| } | |
| ], | |
| 0.9 | |
| ], | |
| { | |
| "name": "Percentile 90", | |
| "display-name": "Percentile 90" | |
| } | |
| ], | |
| [ | |
| "aggregation-options", | |
| [ | |
| "percentile", | |
| [ | |
| "field", | |
| "running_time_seconds", | |
| { | |
| "base-type": "type/Float" | |
| } | |
| ], | |
| 0.5 | |
| ], | |
| { | |
| "name": "Percentile 50", | |
| "display-name": "Percentile 50" | |
| } | |
| ] | |
| ], | |
| "qp/stage-had-source-card": 38 | |
| } | |
| }, | |
| "data": { | |
| "rows": [], | |
| "cols": [] | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment