Skip to content

Instantly share code, notes, and snippets.

@escherize

escherize/bla2.json

Last active August 19, 2025 19:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save escherize/e5a0266b8efc7b4ae311762f775a3bfb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save escherize/e5a0266b8efc7b4ae311762f775a3bfb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bla2.json
{
"database_id": 13371337,
"parameterized": true,
"started_at": "2025-08-19T18:23:49.389733Z",
"via": [
{
"status": "failed",
"class": "class org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException",
"error": "Unknown column 'source.max' in 'order clause'",
"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.exceptionWithQuery(AbstractQueryProtocol.java:178)",
"org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:322)",
"org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)",
"org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)",
"org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)",
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:743)",
"--> driver.sql_jdbc.execute$eval152398$fn__152399.invoke(execute.clj:588)",
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:601)",
"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$eval213993$swap_destination_db__213994$fn__213995.invoke(middleware.clj:30)",
"query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)",
"metabase_enterprise.impersonation.middleware$eval213971$apply_impersonation_postprocessing__213972$fn__213973.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$eval214462$check_download_permissions__214463$fn__214464.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$eval236163$maybe_apply_column_level_perms_check__236164$fn__236165.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$eval236093$handle_audit_app_internal_queries__236094$fn__236095.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.invoke(setup.clj:140)",
"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.card$fn__137909$process_query_for_card_default_qp137908__137910.invoke(card.clj:238)",
"query_processor.card$fn__137909$fn__137912.invoke(card.clj:234)",
"query_processor.card$process_query_for_card_default_run_fn$_AMPERSAND_f__137915$fn__137916.invoke(card.clj:246)",
"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": "42S22"
},
{
"status": "failed",
"class": "class java.sql.SQLSyntaxErrorException",
"error": "(conn=52) Unknown column 'source.max' in 'order clause'",
"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.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)",
"org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)",
"org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)",
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:743)",
"--> driver.sql_jdbc.execute$eval152398$fn__152399.invoke(execute.clj:588)",
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:601)",
"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$eval213993$swap_destination_db__213994$fn__213995.invoke(middleware.clj:30)",
"query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)",
"metabase_enterprise.impersonation.middleware$eval213971$apply_impersonation_postprocessing__213972$fn__213973.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$eval214462$check_download_permissions__214463$fn__214464.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$eval236163$maybe_apply_column_level_perms_check__236164$fn__236165.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$eval236093$handle_audit_app_internal_queries__236094$fn__236095.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.invoke(setup.clj:140)",
"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.card$fn__137909$process_query_for_card_default_qp137908__137910.invoke(card.clj:238)",
"query_processor.card$fn__137909$fn__137912.invoke(card.clj:234)",
"query_processor.card$process_query_for_card_default_run_fn$_AMPERSAND_f__137915$fn__137916.invoke(card.clj:246)",
"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": "42S22"
},
{
"status": "failed",
"class": "class clojure.lang.ExceptionInfo",
"error": "Error executing query: (conn=52) Unknown column 'source.max' in 'order clause'",
"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$eval213993$swap_destination_db__213994$fn__213995.invoke(middleware.clj:30)",
"query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)",
"metabase_enterprise.impersonation.middleware$eval213971$apply_impersonation_postprocessing__213972$fn__213973.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$eval214462$check_download_permissions__214463$fn__214464.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$eval236163$maybe_apply_column_level_perms_check__236164$fn__236165.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$eval236093$handle_audit_app_internal_queries__236094$fn__236095.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.invoke(setup.clj:140)",
"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.card$fn__137909$process_query_for_card_default_qp137908__137910.invoke(card.clj:238)",
"query_processor.card$fn__137909$fn__137912.invoke(card.clj:234)",
"query_processor.card$process_query_for_card_default_run_fn$_AMPERSAND_f__137915$fn__137916.invoke(card.clj:246)",
"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: b03a652823ae8c6cda8da2c6441f79322e287a0fe49bedabea4546e15d382e40",
"SELECT",
" `source`.`entity_id` AS `entity_id`,",
" `source`.`created_at` AS `created_at`,",
" `source`.`name` AS `name`,",
" `source`.`Days since last view` AS `Days since last view`",
"FROM",
" (",
" SELECT",
" `source`.`entity_id` AS `entity_id`,",
" `source`.`entity_qualified_id` AS `entity_qualified_id`,",
" `source`.`entity_type` AS `entity_type`,",
" `source`.`created_at` AS `created_at`,",
" `source`.`name` AS `name`,",
" `source`.`archived` AS `archived`,",
" DATEDIFF(",
" NOW(6),",
" `Last content viewed at - Entity Qualified`.`max`",
" ) AS `Days since last view`,",
" `Last content viewed at - Entity Qualified`.`entity_qualified_id` AS `Last content viewed at - Entity Qualified__entity_q_c439b5a0`,",
" `Last content viewed at - Entity Qualified`.`max` AS `Last content viewed at - Entity Qualified__max`",
" FROM",
" (",
" SELECT",
" `v_content`.`entity_id` AS `entity_id`,",
" `v_content`.`entity_qualified_id` AS `entity_qualified_id`,",
" `v_content`.`entity_type` AS `entity_type`,",
" `v_content`.`created_at` AS `created_at`,",
" `v_content`.`updated_at` AS `updated_at`,",
" `v_content`.`creator_id` AS `creator_id`,",
" `v_content`.`name` AS `name`,",
" `v_content`.`description` AS `description`,",
" `v_content`.`collection_id` AS `collection_id`,",
" `v_content`.`made_public_by_user` AS `made_public_by_user`,",
" `v_content`.`is_embedding_enabled` AS `is_embedding_enabled`,",
" `v_content`.`is_verified` AS `is_verified`,",
" `v_content`.`archived` AS `archived`,",
" `v_content`.`action_type` AS `action_type`,",
" `v_content`.`action_model_id` AS `action_model_id`,",
" `v_content`.`collection_is_official` AS `collection_is_official`,",
" `v_content`.`collection_is_personal` AS `collection_is_personal`,",
" `v_content`.`question_viz_type` AS `question_viz_type`,",
" `v_content`.`question_database_id` AS `question_database_id`,",
" `v_content`.`question_is_native` AS `question_is_native`,",
" `v_content`.`event_timestamp` AS `event_timestamp`,",
" `v_users__via__creator_id`.`full_name` AS `v_users__via__creator_id__full_name`",
" FROM",
" `v_content`",
" LEFT JOIN (",
" SELECT",
" `v_users`.`user_id` AS `user_id`,",
" `v_users`.`entity_qualified_id` AS `entity_qualified_id`,",
" `v_users`.`type` AS `type`,",
" `v_users`.`email` AS `email`,",
" `v_users`.`first_name` AS `first_name`,",
" `v_users`.`last_name` AS `last_name`,",
" `v_users`.`full_name` AS `full_name`,",
" `v_users`.`date_joined` AS `date_joined`,",
" `v_users`.`last_login` AS `last_login`,",
" `v_users`.`updated_at` AS `updated_at`,",
" `v_users`.`is_admin` AS `is_admin`,",
" `v_users`.`is_active` AS `is_active`,",
" `v_users`.`sso_source` AS `sso_source`,",
" `v_users`.`locale` AS `locale`",
" FROM",
" `v_users`",
" ) AS `v_users__via__creator_id` ON `v_content`.`creator_id` = `v_users__via__creator_id`.`user_id`",
" ) AS `source`",
" LEFT JOIN (",
" SELECT",
" `source`.`entity_qualified_id` AS `entity_qualified_id`,",
" `source`.`max` AS `max`,",
" `source`.`v_content__via__entity_qualified_id__name` AS `v_content__via__entity_qualified_id__name`",
" FROM",
" (",
" SELECT",
" `source`.`v_content__via__entity_qualified_id__name` AS `v_content__via__entity_qualified_id__name`,",
" `source`.`entity_qualified_id` AS `entity_qualified_id`,",
" MAX(",
" STR_TO_DATE(",
" DATE_FORMAT(",
" CAST(`source`.`timestamp` AS datetime),",
" '%Y-%m-%d %H:%i'",
" ),",
" '%Y-%m-%d %H:%i'",
" )",
" ) AS `max`",
" FROM",
" (",
" SELECT",
" `v_view_log`.`id` AS `id`,",
" `v_view_log`.`timestamp` AS `timestamp`,",
" `v_view_log`.`user_id` AS `user_id`,",
" `v_view_log`.`entity_type` AS `entity_type`,",
" `v_view_log`.`entity_id` AS `entity_id`,",
" `v_view_log`.`entity_qualified_id` AS `entity_qualified_id`,",
" `v_users__via__user_id`.`full_name` AS `v_users__via__user_id__full_name`,",
" `v_content__via__entity_qualified_id`.`name` AS `v_content__via__entity_qualified_id__name`",
" FROM",
" `v_view_log`",
" LEFT JOIN (",
" SELECT",
" `v_users`.`user_id` AS `user_id`,",
" `v_users`.`entity_qualified_id` AS `entity_qualified_id`,",
" `v_users`.`type` AS `type`,",
" `v_users`.`email` AS `email`,",
" `v_users`.`first_name` AS `first_name`,",
" `v_users`.`last_name` AS `last_name`,",
" `v_users`.`full_name` AS `full_name`,",
" `v_users`.`date_joined` AS `date_joined`,",
" `v_users`.`last_login` AS `last_login`,",
" `v_users`.`updated_at` AS `updated_at`,",
" `v_users`.`is_admin` AS `is_admin`,",
" `v_users`.`is_active` AS `is_active`,",
" `v_users`.`sso_source` AS `sso_source`,",
" `v_users`.`locale` AS `locale`",
" FROM",
" `v_users`",
" ) AS `v_users__via__user_id` ON `v_view_log`.`user_id` = `v_users__via__user_id`.`user_id`",
" LEFT JOIN (",
" SELECT",
" `v_content`.`entity_id` AS `entity_id`,",
" `v_content`.`entity_qualified_id` AS `entity_qualified_id`,",
" `v_content`.`entity_type` AS `entity_type`,",
" `v_content`.`created_at` AS `created_at`,",
" `v_content`.`updated_at` AS `updated_at`,",
" `v_content`.`creator_id` AS `creator_id`,",
" `v_content`.`name` AS `name`,",
" `v_content`.`description` AS `description`,",
" `v_content`.`collection_id` AS `collection_id`,",
" `v_content`.`made_public_by_user` AS `made_public_by_user`,",
" `v_content`.`is_embedding_enabled` AS `is_embedding_enabled`,",
" `v_content`.`is_verified` AS `is_verified`,",
" `v_content`.`archived` AS `archived`,",
" `v_content`.`action_type` AS `action_type`,",
" `v_content`.`action_model_id` AS `action_model_id`,",
" `v_content`.`collection_is_official` AS `collection_is_official`,",
" `v_content`.`collection_is_personal` AS `collection_is_personal`,",
" `v_content`.`question_viz_type` AS `question_viz_type`,",
" `v_content`.`question_database_id` AS `question_database_id`,",
" `v_content`.`question_is_native` AS `question_is_native`,",
" `v_content`.`event_timestamp` AS `event_timestamp`,",
" `v_users__via__creator_id`.`full_name` AS `v_users__via__creator_id__full_name`",
" FROM",
" `v_content`",
" LEFT JOIN `v_users` AS `v_users__via__creator_id` ON `v_content`.`creator_id` = `v_users__via__creator_id`.`user_id`",
" ) AS `v_content__via__entity_qualified_id` ON `v_view_log`.`entity_qualified_id` = `v_content__via__entity_qualified_id`.`entity_qualified_id`",
" ORDER BY",
" `v_view_log`.`timestamp` DESC",
" ) AS `source`",
" GROUP BY",
" `source`.`v_content__via__entity_qualified_id__name`,",
" `source`.`entity_qualified_id`",
" ORDER BY",
" `source`.`v_content__via__entity_qualified_id__name` ASC",
" ) AS `source`",
" ) AS `Last content viewed at - Entity Qualified` ON `source`.`entity_qualified_id` = `Last content viewed at - Entity Qualified`.`entity_qualified_id`",
" ) AS `source`",
"WHERE",
" (`source`.`entity_type` = ?)",
" AND (`source`.`Days since last view` IS NOT NULL)",
" AND (`source`.`archived` = FALSE)",
" AND (`source`.`Days since last view` >= 90)",
"ORDER BY",
" `source`.`Days since last view` DESC",
"LIMIT",
" 100"
],
"params": [
"dashboard"
],
"type": "invalid-query"
}
}
],
"action_id": null,
"state": "42S22",
"error_type": "invalid-query",
"json_query": {
"constraints": {
"max-results": 10000,
"max-results-bare-rows": 2000
},
"type": "query",
"middleware": {
"js-int-to-string?": true,
"ignore-cached-results?": false,
"userland-query?": true
},
"cache-strategy": null,
"viz-settings": {
"table.cell_column": "Days since last view",
"table.pivot_column": "created_at",
"column_settings": {
"[\"ref\",[\"expression\",\"Days since last view\"]]": {
"show_mini_bar": true
},
"[\"ref\",[\"field\",123,{\"base-type\":\"type/Integer\"}]]": {
"column_title": "Dashboard ID",
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
},
"[\"ref\",[\"field\",74,{\"base-type\":\"type/Text\"}]]": {
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
}
}
},
"database": 13371337,
"query": {
"expressions": {
"Days since last view": [
"datetime-diff",
[
"field",
"max",
{
"base-type": "type/DateTimeWithLocalTZ",
"join-alias": "Last content viewed at - Entity Qualified"
}
],
[
"now"
],
"day"
]
},
"fields": [
[
"field",
123,
{
"base-type": "type/Integer"
}
],
[
"field",
122,
{
"base-type": "type/DateTimeWithLocalTZ"
}
],
[
"field",
74,
{
"base-type": "type/Text"
}
],
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
]
],
"filter": [
"and",
[
"=",
[
"field",
112,
{
"base-type": "type/Text"
}
],
"dashboard"
],
[
"not-null",
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
]
],
[
"=",
[
"field",
127,
{
"base-type": "type/Boolean"
}
],
false
]
],
"joins": [
{
"alias": "Last content viewed at - Entity Qualified",
"condition": [
"=",
[
"field",
75,
{
"base-type": "type/Text"
}
],
[
"field",
134,
{
"base-type": "type/Text",
"join-alias": "Last content viewed at - Entity Qualified"
}
]
],
"fields": "none",
"source-table": "card__103",
"strategy": "left-join"
}
],
"limit": 100,
"order-by": [
[
"desc",
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
]
]
],
"source-table": "card__40"
},
"parameters": [
{
"type": "number/>=",
"value": [
90
],
"id": "bdcf71b1",
"target": [
"dimension",
[
"expression",
"Days since last view"
],
{
"stage-number": 0
}
]
}
]
},
"native": {
"query": "SELECT `source`.`entity_id` AS `entity_id`, `source`.`created_at` AS `created_at`, `source`.`name` AS `name`, `source`.`Days since last view` AS `Days since last view` FROM (SELECT `source`.`entity_id` AS `entity_id`, `source`.`entity_qualified_id` AS `entity_qualified_id`, `source`.`entity_type` AS `entity_type`, `source`.`created_at` AS `created_at`, `source`.`name` AS `name`, `source`.`archived` AS `archived`, DATEDIFF(NOW(6), `Last content viewed at - Entity Qualified`.`max`) AS `Days since last view`, `Last content viewed at - Entity Qualified`.`entity_qualified_id` AS `Last content viewed at - Entity Qualified__entity_q_c439b5a0`, `Last content viewed at - Entity Qualified`.`max` AS `Last content viewed at - Entity Qualified__max` FROM (SELECT `v_content`.`entity_id` AS `entity_id`, `v_content`.`entity_qualified_id` AS `entity_qualified_id`, `v_content`.`entity_type` AS `entity_type`, `v_content`.`created_at` AS `created_at`, `v_content`.`updated_at` AS `updated_at`, `v_content`.`creator_id` AS `creator_id`, `v_content`.`name` AS `name`, `v_content`.`description` AS `description`, `v_content`.`collection_id` AS `collection_id`, `v_content`.`made_public_by_user` AS `made_public_by_user`, `v_content`.`is_embedding_enabled` AS `is_embedding_enabled`, `v_content`.`is_verified` AS `is_verified`, `v_content`.`archived` AS `archived`, `v_content`.`action_type` AS `action_type`, `v_content`.`action_model_id` AS `action_model_id`, `v_content`.`collection_is_official` AS `collection_is_official`, `v_content`.`collection_is_personal` AS `collection_is_personal`, `v_content`.`question_viz_type` AS `question_viz_type`, `v_content`.`question_database_id` AS `question_database_id`, `v_content`.`question_is_native` AS `question_is_native`, `v_content`.`event_timestamp` AS `event_timestamp`, `v_users__via__creator_id`.`full_name` AS `v_users__via__creator_id__full_name` FROM `v_content` LEFT JOIN (SELECT `v_users`.`user_id` AS `user_id`, `v_users`.`entity_qualified_id` AS `entity_qualified_id`, `v_users`.`type` AS `type`, `v_users`.`email` AS `email`, `v_users`.`first_name` AS `first_name`, `v_users`.`last_name` AS `last_name`, `v_users`.`full_name` AS `full_name`, `v_users`.`date_joined` AS `date_joined`, `v_users`.`last_login` AS `last_login`, `v_users`.`updated_at` AS `updated_at`, `v_users`.`is_admin` AS `is_admin`, `v_users`.`is_active` AS `is_active`, `v_users`.`sso_source` AS `sso_source`, `v_users`.`locale` AS `locale` FROM `v_users`) AS `v_users__via__creator_id` ON `v_content`.`creator_id` = `v_users__via__creator_id`.`user_id`) AS `source` LEFT JOIN (SELECT `source`.`entity_qualified_id` AS `entity_qualified_id`, `source`.`max` AS `max`, `source`.`v_content__via__entity_qualified_id__name` AS `v_content__via__entity_qualified_id__name` FROM (SELECT `source`.`v_content__via__entity_qualified_id__name` AS `v_content__via__entity_qualified_id__name`, `source`.`entity_qualified_id` AS `entity_qualified_id`, MAX(STR_TO_DATE(DATE_FORMAT(CAST(`source`.`timestamp` AS datetime), '%Y-%m-%d %H:%i'), '%Y-%m-%d %H:%i')) AS `max` FROM (SELECT `v_view_log`.`id` AS `id`, `v_view_log`.`timestamp` AS `timestamp`, `v_view_log`.`user_id` AS `user_id`, `v_view_log`.`entity_type` AS `entity_type`, `v_view_log`.`entity_id` AS `entity_id`, `v_view_log`.`entity_qualified_id` AS `entity_qualified_id`, `v_users__via__user_id`.`full_name` AS `v_users__via__user_id__full_name`, `v_content__via__entity_qualified_id`.`name` AS `v_content__via__entity_qualified_id__name` FROM `v_view_log` LEFT JOIN (SELECT `v_users`.`user_id` AS `user_id`, `v_users`.`entity_qualified_id` AS `entity_qualified_id`, `v_users`.`type` AS `type`, `v_users`.`email` AS `email`, `v_users`.`first_name` AS `first_name`, `v_users`.`last_name` AS `last_name`, `v_users`.`full_name` AS `full_name`, `v_users`.`date_joined` AS `date_joined`, `v_users`.`last_login` AS `last_login`, `v_users`.`updated_at` AS `updated_at`, `v_users`.`is_admin` AS `is_admin`, `v_users`.`is_active` AS `is_active`, `v_users`.`sso_source` AS `sso_source`, `v_users`.`locale` AS `locale` FROM `v_users`) AS `v_users__via__user_id` ON `v_view_log`.`user_id` = `v_users__via__user_id`.`user_id` LEFT JOIN (SELECT `v_content`.`entity_id` AS `entity_id`, `v_content`.`entity_qualified_id` AS `entity_qualified_id`, `v_content`.`entity_type` AS `entity_type`, `v_content`.`created_at` AS `created_at`, `v_content`.`updated_at` AS `updated_at`, `v_content`.`creator_id` AS `creator_id`, `v_content`.`name` AS `name`, `v_content`.`description` AS `description`, `v_content`.`collection_id` AS `collection_id`, `v_content`.`made_public_by_user` AS `made_public_by_user`, `v_content`.`is_embedding_enabled` AS `is_embedding_enabled`, `v_content`.`is_verified` AS `is_verified`, `v_content`.`archived` AS `archived`, `v_content`.`action_type` AS `action_type`, `v_content`.`action_model_id` AS `action_model_id`, `v_content`.`collection_is_official` AS `collection_is_official`, `v_content`.`collection_is_personal` AS `collection_is_personal`, `v_content`.`question_viz_type` AS `question_viz_type`, `v_content`.`question_database_id` AS `question_database_id`, `v_content`.`question_is_native` AS `question_is_native`, `v_content`.`event_timestamp` AS `event_timestamp`, `v_users__via__creator_id`.`full_name` AS `v_users__via__creator_id__full_name` FROM `v_content` LEFT JOIN `v_users` AS `v_users__via__creator_id` ON `v_content`.`creator_id` = `v_users__via__creator_id`.`user_id`) AS `v_content__via__entity_qualified_id` ON `v_view_log`.`entity_qualified_id` = `v_content__via__entity_qualified_id`.`entity_qualified_id` ORDER BY `v_view_log`.`timestamp` DESC) AS `source` GROUP BY `source`.`v_content__via__entity_qualified_id__name`, `source`.`entity_qualified_id` ORDER BY `source`.`v_content__via__entity_qualified_id__name` ASC) AS `source`) AS `Last content viewed at - Entity Qualified` ON `source`.`entity_qualified_id` = `Last content viewed at - Entity Qualified`.`entity_qualified_id`) AS `source` WHERE (`source`.`entity_type` = ?) AND (`source`.`Days since last view` IS NOT NULL) AND (`source`.`archived` = FALSE) AND (`source`.`Days since last view` >= 90) ORDER BY `source`.`Days since last view` DESC LIMIT 100",
"params": [
"dashboard"
]
},
"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:319)",
"org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)",
"org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)",
"org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)",
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:743)",
"--> driver.sql_jdbc.execute$eval152398$fn__152399.invoke(execute.clj:588)",
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:601)",
"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$eval213993$swap_destination_db__213994$fn__213995.invoke(middleware.clj:30)",
"query_processor.middleware.enterprise$swap_destination_db_middleware$fn__123504.invoke(enterprise.clj:73)",
"metabase_enterprise.impersonation.middleware$eval213971$apply_impersonation_postprocessing__213972$fn__213973.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$eval214462$check_download_permissions__214463$fn__214464.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$eval236163$maybe_apply_column_level_perms_check__236164$fn__236165.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$eval236093$handle_audit_app_internal_queries__236094$fn__236095.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.invoke(setup.clj:140)",
"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.card$fn__137909$process_query_for_card_default_qp137908__137910.invoke(card.clj:238)",
"query_processor.card$fn__137909$fn__137912.invoke(card.clj:234)",
"query_processor.card$process_query_for_card_default_run_fn$_AMPERSAND_f__137915$fn__137916.invoke(card.clj:246)",
"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": 113,
"context": "dashboard",
"error": "Unknown column 'source.max' in 'order clause'",
"row_count": 0,
"running_time": 0,
"preprocessed": {
"constraints": {
"max-results": 10000,
"max-results-bare-rows": 2000
},
"type": "query",
"middleware": {
"js-int-to-string?": true,
"ignore-cached-results?": false,
"userland-query?": true
},
"user-parameters": [
{
"value": [
90
],
"type": "number/>=",
"id": "bdcf71b1",
"target": [
"dimension",
[
"expression",
"Days since last view"
],
{
"stage-number": 0
}
]
}
],
"viz-settings": {
"table.cell_column": "Days since last view",
"table.pivot_column": "created_at",
"column_settings": {
"[\"ref\",[\"expression\",\"Days since last view\"]]": {
"show_mini_bar": true
},
"[\"ref\",[\"field\",123,{\"base-type\":\"type/Integer\"}]]": {
"column_title": "Dashboard ID",
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
},
"[\"ref\",[\"field\",74,{\"base-type\":\"type/Text\"}]]": {
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
}
}
},
"qp/source-card-id": 40,
"info": {
"executed-by": 13371339,
"context": "dashboard",
"card-id": 113,
"card-name": "Dashboards without recent views",
"dashboard-id": 10,
"visualization-settings": {
"table.cell_column": "Days since last view",
"table.pivot_column": "created_at",
"column_settings": {
"[\"ref\",[\"expression\",\"Days since last view\"]]": {
"show_mini_bar": true
},
"[\"ref\",[\"field\",123,{\"base-type\":\"type/Integer\"}]]": {
"column_title": "Dashboard ID",
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
},
"[\"ref\",[\"field\",74,{\"base-type\":\"type/Text\"}]]": {
"link_text": "",
"link_url": "/dashboard/{{entity_id}}",
"view_as": "link"
}
}
}
},
"database": 13371337,
"metabase.query-processor.middleware.add-remaps/external-remaps": [
{
"id": 13,
"name": "Creator ID",
"field-id": 115,
"field-name": "creator_id",
"human-readable-field-id": 90,
"human-readable-field-name": "full_name"
}
],
"query": {
"limit": 100,
"source-query": {
"source-table": 12,
"qp/stage-is-from-source-card": 40,
"fields": [
[
"field",
123,
null
],
[
"field",
75,
null
],
[
"field",
112,
null
],
[
"field",
122,
null
],
[
"field",
119,
null
],
[
"field",
115,
{
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 13
}
],
[
"field",
74,
null
],
[
"field",
120,
null
],
[
"field",
110,
null
],
[
"field",
125,
null
],
[
"field",
118,
null
],
[
"field",
126,
null
],
[
"field",
127,
null
],
[
"field",
114,
null
],
[
"field",
113,
null
],
[
"field",
121,
null
],
[
"field",
128,
null
],
[
"field",
111,
null
],
[
"field",
116,
null
],
[
"field",
117,
null
],
[
"field",
124,
null
],
[
"field",
90,
{
"source-field": 115,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 13,
"join-alias": "v_users__via__creator_id"
}
]
],
"joins": [
{
"alias": "v_users__via__creator_id",
"strategy": "left-join",
"qp/is-implicit-join": true,
"fk-field-id": 115,
"condition": [
"=",
[
"field",
115,
null
],
[
"field",
82,
{
"join-alias": "v_users__via__creator_id"
}
]
],
"source-table": 13
}
],
"metabase.query-processor.middleware.add-implicit-joins/reused-join-aliases": []
},
"fields": [
[
"field",
123,
{
"base-type": "type/Integer"
}
],
[
"field",
122,
{
"base-type": "type/DateTimeWithLocalTZ"
}
],
[
"field",
74,
{
"base-type": "type/Text"
}
],
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
]
],
"joins": [
{
"alias": "Last content viewed at - Entity Qualified",
"strategy": "left-join",
"condition": [
"=",
[
"field",
75,
{
"base-type": "type/Text"
}
],
[
"field",
134,
{
"base-type": "type/Text",
"join-alias": "Last content viewed at - Entity Qualified"
}
]
],
"source-metadata": [
{
"database_type": "VARCHAR",
"semantic_type": "type/FK",
"table_id": 14,
"lib/deduplicated-name": "entity_qualified_id",
"lib/original-name": "entity_qualified_id",
"lib/breakout?": false,
"name": "entity_qualified_id",
"lib/card-id": 103,
"lib/source": "source/previous-stage",
"lib/source-column-alias": "entity_qualified_id",
"lib/original-display-name": "Entity Qualified ID",
"lib/model-display-name": "Entity Qualified ID",
"lib/external-remap": {
"lib/type": "metadata.column.remapping/external",
"id": 15,
"name": "Entity Qualified ID",
"field-id": 74
},
"source": "fields",
"fk_target_field_id": 75,
"field_ref": [
"field",
"entity_qualified_id",
{
"base-type": "type/Text"
}
],
"effective_type": "type/Text",
"active": true,
"id": 134,
"lib/desired-column-alias": "entity_qualified_id",
"position": 5,
"visibility_type": "normal",
"options": {
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 15
},
"display_name": "Entity Qualified ID",
"base_type": "type/Text"
},
{
"semantic_type": "type/CreationTimestamp",
"lib/deduplicated-name": "max",
"lib/original-name": "max",
"lib/breakout?": false,
"name": "max",
"lib/card-id": 103,
"lib/source": "source/previous-stage",
"lib/source-column-alias": "max",
"source": "fields",
"field_ref": [
"field",
"max",
{
"base-type": "type/DateTimeWithLocalTZ"
}
],
"effective_type": "type/DateTimeWithLocalTZ",
"lib/desired-column-alias": "max",
"display_name": "Max of Timestamp: Minute",
"base_type": "type/DateTimeWithLocalTZ"
},
{
"database_type": "LONGTEXT",
"semantic_type": "type/Name",
"table_id": 12,
"lib/deduplicated-name": "name",
"lib/original-name": "name",
"lib/breakout?": false,
"name": "name",
"lib/source": "source/previous-stage",
"lib/source-column-alias": "v_content__via__entity_qualified_id__name",
"lib/original-display-name": "Name",
"lib/original-fk-field-id": 134,
"source": "fields",
"field_ref": [
"field",
74,
{
"source-field": 134,
"join-alias": "v_content__via__entity_qualified_id"
}
],
"effective_type": "type/Text",
"active": true,
"id": 74,
"metabase.lib.query/transformation-added-base-type": true,
"lib/desired-column-alias": "v_content__via__entity_qualified_id__name",
"position": 6,
"visibility_type": "normal",
"options": {
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 15
},
"display_name": "Entity Qualified → Name",
"fingerprint": {
"global": {
"distinct-count": 118,
"nil%": 0.0
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 22.27777777777778
}
}
},
"base_type": "type/Text"
}
],
"source-query": {
"qp/stage-had-source-card": 103,
"source-query/model?": false,
"metabase.query-processor.middleware.ensure-joins-use-source-query/dummy-key": true,
"fields": [
[
"field",
"entity_qualified_id",
{
"base-type": "type/Text",
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 15
}
],
[
"field",
"max",
{
"base-type": "type/DateTimeWithLocalTZ"
}
],
[
"field",
74,
{
"source-field": 134,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 15,
"join-alias": "v_content__via__entity_qualified_id"
}
]
],
"metabase.query-processor.middleware.add-implicit-joins/reused-join-aliases": [
"v_content__via__entity_qualified_id"
],
"source-query": {
"source-query": {
"fields": [
[
"field",
133,
{
"base-type": "type/Integer"
}
],
[
"field",
131,
{
"base-type": "type/DateTimeWithLocalTZ"
}
],
[
"field",
130,
{
"base-type": "type/Integer",
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 14
}
],
[
"field",
135,
{
"base-type": "type/Text"
}
],
[
"field",
132,
{
"base-type": "type/Integer"
}
],
[
"field",
134,
{
"base-type": "type/Text",
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 15
}
],
[
"field",
90,
{
"source-field": 130,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 14,
"join-alias": "v_users__via__user_id"
}
],
[
"field",
74,
{
"source-field": 134,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 15,
"join-alias": "v_content__via__entity_qualified_id"
}
]
],
"order-by": [
[
"desc",
[
"field",
131,
{
"base-type": "type/DateTimeWithLocalTZ"
}
]
]
],
"source-table": 14,
"qp/stage-is-from-source-card": 42,
"joins": [
{
"alias": "v_users__via__user_id",
"strategy": "left-join",
"qp/is-implicit-join": true,
"fk-field-id": 130,
"condition": [
"=",
[
"field",
130,
null
],
[
"field",
82,
{
"join-alias": "v_users__via__user_id"
}
]
],
"source-table": 13
},
{
"alias": "v_content__via__entity_qualified_id",
"strategy": "left-join",
"qp/is-implicit-join": true,
"fk-field-id": 134,
"condition": [
"=",
[
"field",
134,
null
],
[
"field",
75,
{
"join-alias": "v_content__via__entity_qualified_id"
}
]
],
"source-table": 12
}
],
"metabase.query-processor.middleware.add-implicit-joins/reused-join-aliases": []
},
"source-metadata": [
{
"description": "View ID, each question, dashboard, model, collection view generated one new sequential ID.",
"database_type": "INT",
"semantic_type": "type/PK",
"table_id": 14,
"lib/deduplicated-name": "id",
"lib/original-name": "id",
"lib/breakout?": false,
"name": "id",
"lib/card-id": 42,
"lib/source": "source/card",
"lib/source-column-alias": "id",
"lib/model-display-name": "ID",
"field_ref": [
"field",
133,
{
"base-type": "type/Integer"
}
],
"effective_type": "type/Integer",
"active": true,
"id": 133,
"lib/desired-column-alias": "id",
"position": 0,
"visibility_type": "normal",
"display_name": "ID",
"base_type": "type/Integer"
},
{
"description": "When the view happened",
"database_type": "TIMESTAMP",
"semantic_type": "type/CreationTimestamp",
"table_id": 14,
"lib/deduplicated-name": "timestamp",
"lib/original-name": "timestamp",
"lib/breakout?": false,
"unit": "default",
"name": "timestamp",
"lib/card-id": 42,
"lib/source": "source/card",
"lib/source-column-alias": "timestamp",
"lib/model-display-name": "Timestamp",
"field_ref": [
"field",
131,
{
"base-type": "type/DateTimeWithLocalTZ",
"temporal-unit": "default"
}
],
"effective_type": "type/DateTimeWithLocalTZ",
"active": true,
"id": 131,
"lib/desired-column-alias": "timestamp",
"position": 1,
"visibility_type": "normal",
"display_name": "Timestamp",
"base_type": "type/DateTimeWithLocalTZ"
},
{
"description": "Who viewed the content",
"database_type": "BIGINT",
"semantic_type": "type/FK",
"table_id": 14,
"lib/deduplicated-name": "user_id",
"lib/original-name": "user_id",
"lib/breakout?": false,
"name": "user_id",
"lib/card-id": 42,
"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": 14,
"name": "User ID",
"field-id": 90
},
"fk_target_field_id": 82,
"field_ref": [
"field",
130,
{
"base-type": "type/Integer"
}
],
"effective_type": "type/Integer",
"active": true,
"id": 130,
"lib/desired-column-alias": "user_id",
"position": 2,
"visibility_type": "normal",
"display_name": "User ID",
"base_type": "type/Integer"
},
{
"description": "card (question, model, metric), table, dashboard or collection",
"database_type": "VARCHAR",
"semantic_type": "type/Category",
"table_id": 14,
"lib/deduplicated-name": "entity_type",
"lib/original-name": "entity_type",
"lib/breakout?": false,
"name": "entity_type",
"lib/card-id": 42,
"lib/source": "source/card",
"lib/source-column-alias": "entity_type",
"lib/model-display-name": "Entity Type",
"field_ref": [
"field",
135,
{
"base-type": "type/Text"
}
],
"effective_type": "type/Text",
"active": true,
"id": 135,
"lib/desired-column-alias": "entity_type",
"position": 3,
"visibility_type": "normal",
"display_name": "Entity Type",
"base_type": "type/Text"
},
{
"description": "The sequential ID of the card, dashboard, collection",
"database_type": "INT",
"table_id": 14,
"lib/deduplicated-name": "entity_id",
"lib/original-name": "entity_id",
"lib/breakout?": false,
"name": "entity_id",
"lib/card-id": 42,
"lib/source": "source/card",
"lib/source-column-alias": "entity_id",
"lib/model-display-name": "Entity ID",
"field_ref": [
"field",
132,
{
"base-type": "type/Integer"
}
],
"effective_type": "type/Integer",
"active": true,
"id": 132,
"lib/desired-column-alias": "entity_id",
"position": 4,
"visibility_type": "normal",
"display_name": "Entity ID",
"base_type": "type/Integer"
},
{
"database_type": "VARCHAR",
"semantic_type": "type/FK",
"table_id": 14,
"lib/deduplicated-name": "entity_qualified_id",
"lib/original-name": "entity_qualified_id",
"lib/breakout?": false,
"name": "entity_qualified_id",
"lib/card-id": 42,
"lib/source": "source/card",
"lib/source-column-alias": "entity_qualified_id",
"lib/model-display-name": "Entity Qualified ID",
"lib/external-remap": {
"lib/type": "metadata.column.remapping/external",
"id": 15,
"name": "Entity Qualified ID",
"field-id": 74
},
"fk_target_field_id": 75,
"field_ref": [
"field",
134,
{
"base-type": "type/Text"
}
],
"effective_type": "type/Text",
"active": true,
"id": 134,
"lib/desired-column-alias": "entity_qualified_id",
"position": 5,
"visibility_type": "normal",
"display_name": "Entity Qualified ID",
"base_type": "type/Text"
}
],
"metabase.query-processor.middleware.add-implicit-joins/reused-join-aliases": [
"v_content__via__entity_qualified_id"
],
"source-query/model?": true,
"breakout": [
[
"field",
74,
{
"source-field": 134,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 15,
"join-alias": "v_content__via__entity_qualified_id"
}
],
[
"field",
"entity_qualified_id",
{
"base-type": "type/Text",
"metabase.query-processor.middleware.add-remaps/original-field-dimension-id": 15
}
]
],
"order-by": [
[
"asc",
[
"field",
74,
{
"source-field": 134,
"metabase.query-processor.middleware.add-remaps/new-field-dimension-id": 15,
"join-alias": "v_content__via__entity_qualified_id"
}
]
]
],
"aggregation": [
[
"aggregation-options",
[
"max",
[
"field",
"timestamp",
{
"base-type": "type/DateTimeWithLocalTZ",
"temporal-unit": "minute",
"original-temporal-unit": "month",
"inherited-temporal-unit": "default"
}
]
],
{
"name": "max"
}
]
],
"qp/stage-had-source-card": 42,
"qp/stage-is-from-source-card": 103
},
"source-metadata": [
{
"database_type": "text",
"semantic_type": "type/FK",
"table_id": 14,
"lib/deduplicated-name": "entity_qualified_id",
"lib/original-name": "entity_qualified_id",
"lib/breakout?": false,
"name": "entity_qualified_id",
"lib/card-id": 103,
"lib/source": "source/card",
"lib/source-column-alias": "entity_qualified_id",
"lib/external-remap": {
"lib/type": "metadata.column.remapping/external",
"id": 15,
"name": "Entity Qualified ID",
"field-id": 74
},
"source": "breakout",
"fk_target_field_id": 75,
"field_ref": [
"field",
"entity_qualified_id",
{
"base-type": "type/Text"
}
],
"effective_type": "type/Text",
"active": true,
"id": 134,
"lib/desired-column-alias": "entity_qualified_id",
"position": 5,
"visibility_type": "normal",
"display_name": "Entity Qualified ID",
"base_type": "type/Text"
},
{
"semantic_type": "type/CreationTimestamp",
"lib/deduplicated-name": "max",
"lib/original-name": "max",
"lib/breakout?": false,
"name": "max",
"lib/card-id": 103,
"lib/source": "source/card",
"lib/source-column-alias": "max",
"source": "aggregation",
"field_ref": [
"aggregation",
0
],
"effective_type": "type/DateTimeWithLocalTZ",
"lib/desired-column-alias": "max",
"display_name": "Max of Timestamp: Minute",
"base_type": "type/DateTimeWithLocalTZ"
}
]
}
}
],
"source-metadata": [
{
"database_type": "int4",
"semantic_type": "type/PK",
"table_id": 12,
"lib/deduplicated-name": "entity_id",
"lib/original-name": "entity_id",
"lib/breakout?": false,
"name": "entity_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "entity_id",
"lib/model-display-name": "Entity ID",
"field_ref": [
"field",
123,
null
],
"effective_type": "type/Integer",
"active": true,
"id": 123,
"lib/desired-column-alias": "entity_id",
"position": 0,
"visibility_type": "normal",
"display_name": "Entity ID",
"base_type": "type/Integer"
},
{
"database_type": "text",
"semantic_type": "type/PK",
"table_id": 12,
"lib/deduplicated-name": "entity_qualified_id",
"lib/original-name": "entity_qualified_id",
"lib/breakout?": false,
"name": "entity_qualified_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "entity_qualified_id",
"lib/model-display-name": "Entity Qualified ID",
"field_ref": [
"field",
75,
null
],
"effective_type": "type/Text",
"active": true,
"id": 75,
"lib/desired-column-alias": "entity_qualified_id",
"position": 1,
"visibility_type": "normal",
"display_name": "Entity Qualified ID",
"base_type": "type/Text"
},
{
"database_type": "text",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "entity_type",
"lib/original-name": "entity_type",
"lib/breakout?": false,
"name": "entity_type",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "entity_type",
"lib/model-display-name": "Entity Type",
"field_ref": [
"field",
112,
null
],
"effective_type": "type/Text",
"active": true,
"id": 112,
"lib/desired-column-alias": "entity_type",
"position": 2,
"visibility_type": "normal",
"display_name": "Entity Type",
"fingerprint": {
"global": {
"distinct-count": 5,
"nil%": 0.0
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 7.785714285714286
}
}
},
"base_type": "type/Text"
},
{
"database_type": "timestamptz",
"semantic_type": "type/CreationTimestamp",
"table_id": 12,
"lib/deduplicated-name": "created_at",
"lib/original-name": "created_at",
"lib/breakout?": false,
"name": "created_at",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "created_at",
"lib/model-display-name": "Created At",
"field_ref": [
"field",
122,
null
],
"effective_type": "type/DateTimeWithLocalTZ",
"active": true,
"id": 122,
"lib/desired-column-alias": "created_at",
"position": 3,
"visibility_type": "normal",
"display_name": "Created At",
"fingerprint": {
"global": {
"distinct-count": 87,
"nil%": 0.0
},
"type": {
"type/DateTime": {
"earliest": "2023-06-08T14:12:32.4457Z",
"latest": "2025-08-19T17:04:55Z"
}
}
},
"base_type": "type/DateTimeWithLocalTZ"
},
{
"database_type": "timestamptz",
"semantic_type": "type/UpdatedTimestamp",
"table_id": 12,
"lib/deduplicated-name": "updated_at",
"lib/original-name": "updated_at",
"lib/breakout?": false,
"name": "updated_at",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "updated_at",
"lib/model-display-name": "Updated At",
"field_ref": [
"field",
119,
null
],
"effective_type": "type/DateTimeWithLocalTZ",
"active": true,
"id": 119,
"lib/desired-column-alias": "updated_at",
"position": 4,
"visibility_type": "normal",
"display_name": "Updated At",
"fingerprint": {
"global": {
"distinct-count": 85,
"nil%": 0.03968253968253968
},
"type": {
"type/DateTime": {
"earliest": "2025-08-19T17:04:55Z",
"latest": "2025-08-19T17:05:18.131024Z"
}
}
},
"base_type": "type/DateTimeWithLocalTZ"
},
{
"database_type": "int4",
"semantic_type": "type/FK",
"table_id": 12,
"lib/deduplicated-name": "creator_id",
"lib/original-name": "creator_id",
"lib/breakout?": false,
"name": "creator_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "creator_id",
"lib/model-display-name": "Creator ID",
"lib/external-remap": {
"lib/type": "metadata.column.remapping/external",
"id": 13,
"name": "Creator ID",
"field-id": 90
},
"fk_target_field_id": 82,
"field_ref": [
"field",
115,
null
],
"effective_type": "type/Integer",
"active": true,
"id": 115,
"lib/desired-column-alias": "creator_id",
"position": 5,
"visibility_type": "normal",
"display_name": "Creator ID",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.03968253968253968
}
},
"base_type": "type/Integer"
},
{
"database_type": "varchar",
"semantic_type": "type/Name",
"table_id": 12,
"lib/deduplicated-name": "name",
"lib/original-name": "name",
"lib/breakout?": false,
"name": "name",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "name",
"lib/model-display-name": "Name",
"field_ref": [
"field",
74,
null
],
"effective_type": "type/Text",
"active": true,
"id": 74,
"lib/desired-column-alias": "name",
"position": 6,
"visibility_type": "normal",
"display_name": "Name",
"fingerprint": {
"global": {
"distinct-count": 118,
"nil%": 0.0
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 22.27777777777778
}
}
},
"base_type": "type/Text"
},
{
"database_type": "text",
"semantic_type": "type/Description",
"table_id": 12,
"lib/deduplicated-name": "description",
"lib/original-name": "description",
"lib/breakout?": false,
"name": "description",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "description",
"lib/model-display-name": "Description",
"field_ref": [
"field",
120,
null
],
"effective_type": "type/Text",
"active": true,
"id": 120,
"lib/desired-column-alias": "description",
"position": 7,
"visibility_type": "normal",
"display_name": "Description",
"fingerprint": {
"global": {
"distinct-count": 73,
"nil%": 0.380952380952381
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 35.833333333333336
}
}
},
"base_type": "type/Text"
},
{
"database_type": "int4",
"table_id": 12,
"lib/deduplicated-name": "collection_id",
"lib/original-name": "collection_id",
"lib/breakout?": false,
"name": "collection_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "collection_id",
"lib/model-display-name": "Collection ID",
"field_ref": [
"field",
110,
null
],
"effective_type": "type/Integer",
"active": true,
"id": 110,
"lib/desired-column-alias": "collection_id",
"position": 8,
"visibility_type": "normal",
"display_name": "Collection ID",
"fingerprint": {
"global": {
"distinct-count": 3,
"nil%": 0.03968253968253968
},
"type": {
"type/Number": {
"min": 2.0,
"q1": 2.5139151602748915,
"q3": 4.0,
"max": 4.0,
"sd": 0.9321322456690241,
"avg": 3.371900826446281
}
}
},
"base_type": "type/Integer"
},
{
"database_type": "int4",
"semantic_type": "type/FK",
"table_id": 12,
"lib/deduplicated-name": "made_public_by_user",
"lib/original-name": "made_public_by_user",
"lib/breakout?": false,
"name": "made_public_by_user",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "made_public_by_user",
"lib/model-display-name": "Made Public By User",
"fk_target_field_id": 82,
"field_ref": [
"field",
125,
null
],
"effective_type": "type/Integer",
"active": true,
"id": 125,
"lib/desired-column-alias": "made_public_by_user",
"position": 9,
"visibility_type": "normal",
"display_name": "Made Public By User",
"fingerprint": {
"global": {
"distinct-count": 1,
"nil%": 1.0
}
},
"base_type": "type/Integer"
},
{
"database_type": "bool",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "is_embedding_enabled",
"lib/original-name": "is_embedding_enabled",
"lib/breakout?": false,
"name": "is_embedding_enabled",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "is_embedding_enabled",
"lib/model-display-name": "Is Embedding Enabled",
"field_ref": [
"field",
118,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 118,
"lib/desired-column-alias": "is_embedding_enabled",
"position": 10,
"visibility_type": "normal",
"display_name": "Is Embedding Enabled",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.03968253968253968
}
},
"base_type": "type/Boolean"
},
{
"database_type": "bool",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "is_verified",
"lib/original-name": "is_verified",
"lib/breakout?": false,
"name": "is_verified",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "is_verified",
"lib/model-display-name": "Is Verified",
"field_ref": [
"field",
126,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 126,
"lib/desired-column-alias": "is_verified",
"position": 11,
"visibility_type": "normal",
"display_name": "Is Verified",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.03968253968253968
},
"type": {
"type/Number": {
"min": 0.0,
"q1": 0.0,
"q3": 0.0,
"max": 0.0,
"sd": 0.0,
"avg": 0.0
}
}
},
"base_type": "type/Boolean"
},
{
"database_type": "bool",
"semantic_type": "type/Enum",
"table_id": 12,
"lib/deduplicated-name": "archived",
"lib/original-name": "archived",
"lib/breakout?": false,
"name": "archived",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "archived",
"lib/model-display-name": "Archived",
"field_ref": [
"field",
127,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 127,
"lib/desired-column-alias": "archived",
"position": 12,
"visibility_type": "normal",
"display_name": "Archived",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.0
}
},
"base_type": "type/Boolean"
},
{
"database_type": "text",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "action_type",
"lib/original-name": "action_type",
"lib/breakout?": false,
"name": "action_type",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "action_type",
"lib/model-display-name": "Action Type",
"field_ref": [
"field",
114,
null
],
"effective_type": "type/Text",
"active": true,
"id": 114,
"lib/desired-column-alias": "action_type",
"position": 13,
"visibility_type": "normal",
"display_name": "Action Type",
"fingerprint": {
"global": {
"distinct-count": 1,
"nil%": 1.0
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 0.0
}
}
},
"base_type": "type/Text"
},
{
"database_type": "int4",
"table_id": 12,
"lib/deduplicated-name": "action_model_id",
"lib/original-name": "action_model_id",
"lib/breakout?": false,
"name": "action_model_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "action_model_id",
"lib/model-display-name": "Action Model ID",
"field_ref": [
"field",
113,
null
],
"effective_type": "type/Integer",
"active": true,
"id": 113,
"lib/desired-column-alias": "action_model_id",
"position": 14,
"visibility_type": "normal",
"display_name": "Action Model ID",
"fingerprint": {
"global": {
"distinct-count": 1,
"nil%": 1.0
}
},
"base_type": "type/Integer"
},
{
"database_type": "bool",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "collection_is_official",
"lib/original-name": "collection_is_official",
"lib/breakout?": false,
"name": "collection_is_official",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "collection_is_official",
"lib/model-display-name": "Collection Is Official",
"field_ref": [
"field",
121,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 121,
"lib/desired-column-alias": "collection_is_official",
"position": 15,
"visibility_type": "normal",
"display_name": "Collection Is Official",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.9603174603174603
},
"type": {
"type/Number": {
"min": 0.0,
"q1": 0.0,
"q3": 0.0,
"max": 0.0,
"sd": 0.0,
"avg": 0.0
}
}
},
"base_type": "type/Boolean"
},
{
"database_type": "bool",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "collection_is_personal",
"lib/original-name": "collection_is_personal",
"lib/breakout?": false,
"name": "collection_is_personal",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "collection_is_personal",
"lib/model-display-name": "Collection Is Personal",
"field_ref": [
"field",
128,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 128,
"lib/desired-column-alias": "collection_is_personal",
"position": 16,
"visibility_type": "normal",
"display_name": "Collection Is Personal",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.9603174603174603
},
"type": {
"type/Number": {
"min": 0.0,
"q1": 0.0,
"q3": 0.0,
"max": 0.0,
"sd": 0.0,
"avg": 0.0
}
}
},
"base_type": "type/Boolean"
},
{
"database_type": "text",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "question_viz_type",
"lib/original-name": "question_viz_type",
"lib/breakout?": false,
"name": "question_viz_type",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "question_viz_type",
"lib/model-display-name": "Question Viz Type",
"field_ref": [
"field",
111,
null
],
"effective_type": "type/Text",
"active": true,
"id": 111,
"lib/desired-column-alias": "question_viz_type",
"position": 17,
"visibility_type": "normal",
"display_name": "Question Viz Type",
"fingerprint": {
"global": {
"distinct-count": 19,
"nil%": 0.1111111111111111
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 4.753968253968254
}
}
},
"base_type": "type/Text"
},
{
"database_type": "text",
"semantic_type": "type/FK",
"table_id": 12,
"lib/deduplicated-name": "question_database_id",
"lib/original-name": "question_database_id",
"lib/breakout?": false,
"name": "question_database_id",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "question_database_id",
"lib/model-display-name": "Question Database ID",
"fk_target_field_id": 73,
"field_ref": [
"field",
116,
null
],
"effective_type": "type/Text",
"active": true,
"id": 116,
"lib/desired-column-alias": "question_database_id",
"position": 18,
"visibility_type": "normal",
"display_name": "Question Database ID",
"fingerprint": {
"global": {
"distinct-count": 3,
"nil%": 0.1111111111111111
},
"type": {
"type/Text": {
"percent-json": 0.0,
"percent-url": 0.0,
"percent-email": 0.0,
"percent-state": 0.0,
"average-length": 13.055555555555555
}
}
},
"base_type": "type/Text"
},
{
"database_type": "bool",
"semantic_type": "type/Category",
"table_id": 12,
"lib/deduplicated-name": "question_is_native",
"lib/original-name": "question_is_native",
"lib/breakout?": false,
"name": "question_is_native",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "question_is_native",
"lib/model-display-name": "Question Is Native",
"field_ref": [
"field",
117,
null
],
"effective_type": "type/Boolean",
"active": true,
"id": 117,
"lib/desired-column-alias": "question_is_native",
"position": 19,
"visibility_type": "normal",
"display_name": "Question Is Native",
"fingerprint": {
"global": {
"distinct-count": 2,
"nil%": 0.1111111111111111
},
"type": {
"type/Number": {
"min": 0.0,
"q1": 0.0,
"q3": 0.0,
"max": 0.0,
"sd": 0.0,
"avg": 0.0
}
}
},
"base_type": "type/Boolean"
},
{
"database_type": "timestamptz",
"table_id": 12,
"lib/deduplicated-name": "event_timestamp",
"lib/original-name": "event_timestamp",
"lib/breakout?": false,
"name": "event_timestamp",
"lib/card-id": 40,
"lib/source": "source/card",
"lib/source-column-alias": "event_timestamp",
"lib/model-display-name": "Event Timestamp",
"field_ref": [
"field",
124,
null
],
"effective_type": "type/DateTimeWithLocalTZ",
"active": true,
"id": 124,
"lib/desired-column-alias": "event_timestamp",
"position": 20,
"visibility_type": "normal",
"display_name": "Event Timestamp",
"fingerprint": {
"global": {
"distinct-count": 1,
"nil%": 1.0
}
},
"base_type": "type/DateTimeWithLocalTZ"
}
],
"filter": [
"and",
[
"=",
[
"field",
112,
{
"base-type": "type/Text"
}
],
[
"value",
"dashboard",
{
"name": "entity_type",
"base_type": "type/Text",
"semantic_type": "type/Category",
"database_type": "VARCHAR"
}
]
],
[
"!=",
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
],
[
"value",
null,
{
"base_type": "type/Integer"
}
]
],
[
"=",
[
"field",
127,
{
"base-type": "type/Boolean"
}
],
[
"value",
false,
{
"name": "archived",
"base_type": "type/Boolean",
"semantic_type": "type/Enum",
"database_type": "BIT"
}
]
],
[
">=",
[
"expression",
"Days since last view"
],
[
"value",
90,
null
]
]
],
"expressions": {
"Days since last view": [
"datetime-diff",
[
"field",
"max",
{
"base-type": "type/DateTimeWithLocalTZ",
"join-alias": "Last content viewed at - Entity Qualified"
}
],
[
"now"
],
"day"
]
},
"source-query/model?": true,
"order-by": [
[
"desc",
[
"expression",
"Days since last view",
{
"base-type": "type/Integer"
}
]
]
],
"qp/stage-had-source-card": 40
}
},
"data": {
"rows": [],
"cols": []
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment