Skip to content

Instantly share code, notes, and snippets.

@escherize

escherize/bla

Created August 19, 2025 18:14
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save escherize/fa2cfcf01c6c8cf025e1ff82ad6c7bab to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bla
2025-08-19 18:13:31,761 ERROR middleware.catch-exceptions :: Error processing query: Unknown column 'source.max' in 'order clause'
{:database_id 13371337,
:parameterized true,
:started_at #t "2025-08-19T18:13:20.097556Z[UTC]",
:via
[{:status :failed,
: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)"
ePreparedStatement.java:149)"idePreparedStatement.execute(ClientSid
"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)"
val152223$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)"
mpersonation_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)"
ocessor.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)"
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)"
$fn__128228.invoke(catch_exceptions.clj:127)"ons$fn__128211$catch_exceptions128210__128212
"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)"
49.invoke(setup.clj:122)"p$fn__126944$do_with_resolved_database126943__126945$fn__1269
"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)"
aming.clj:189)"essor.streaming$do_with_streaming_rff.invoke(stre
"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 java.sql.SQLSyntaxErrorException,
:error "(conn=42) 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)"
nt.java:149)"adb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStateme
"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)"
2224.invoke(execute.clj:421)"eval152223$fn__15
"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)"
tprocessing__213972$fn__213973.invoke(middleware.clj:25)"971$apply_impersonation_pos
"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)"
re.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)"
keStatic(query_processor.clj:50)"y_STAR__STAR_.invo
"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)"
ke(catch_exceptions.clj:127)"re.catch_exceptions$fn__128211$catch_exceptions128210__128212$fn__128228.invo
"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)"
clj:122)"y_processor.setup$fn__126944$do_with_resolved_database126943__126945$fn__126949.invoke(setup.
"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$_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 clojure.lang.ExceptionInfo,
:error "Error executing query: (conn=42) 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)"
.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)"
71$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)"
s.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)"
ess_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)"
10__128212$fn__128228.invoke(catch_exceptions.clj:127)"8211$catch_exceptions1282
"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)"
5$fn__126949.invoke(setup.clj:122)"44$do_with_resolved_database126943__12694
"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)"
nvoke(streaming.clj:189)"aming$do_with_streaming_rff.i
"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`,"
AS `name`," `v_content`.`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`,"
` AS `locale`" `v_users`.`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`"
= `v_users__via__user_id`.`user_id`"__via__user_id` ON `v_view_log`.`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`,"
d`," " `v_content`.`is_verified` AS `is_verifie
" `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`"
ator_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 nil,
: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 nil,
: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,
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_idt - 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 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)"
atement.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)"
e$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)"
essing__213972$fn__213973.invoke(middleware.clj:25)"213971$apply_impersonation_postproc
"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)"
4462$check_download_permissions__214463$fn__214464.invoke(permissions.clj:97)"ions$eval21
"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)"
uery_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)"
_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)"
7009.invoke(setup.clj:232)"__127008$do_with_qp_setup127007__12
"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)"
ver.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\"}]]"
le "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,
ernal-remapsquery-processor.middleware.add-remaps/ext
[{: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 nil]
[:field 75 nil]
[:field 112 nil]
[:field 122 nil]
[:field 119 nil]
[:field 115 {:metabase.query-processor.middleware.add-remaps/original-field-dimension-id 13}]
[:field 74 nil]
[:field 120 nil]
[:field 110 nil]
[:field 125 nil]
[:field 118 nil]
[:field 126 nil]
[:field 127 nil]
[:field 114 nil]
[:field 113 nil]
[:field 121 nil]
[:field 128 nil]
[:field 111 nil]
[:field 116 nil]
[:field 117 nil]
[:field 124 nil]
[:field
90
{:source-field 115,
:metabase.query-processor.middleware.add-remaps/new-field-dimension-id 13,
via__creator_id"}]],v_users__
:joins
[{:alias "v_users__via__creator_id",
:strategy :left-join,
:qp/is-implicit-join true,
:fk-field-id 115,
:condition [:= [:field 115 nil] [: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,
ied_id",lib/deduplicated-name "entity_qualif
: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}
CreationTimestamp,ype :type/
: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 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
_qualified_id"y
{: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
ase.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 nil] [: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 nil] [: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,
ity_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,
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},
d_id 75, :fk_target_fiel
: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,
base.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
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}]}}],
ce-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 nil],
: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",
Qualified ID",-display-name "Entity
:field_ref [:field 75 nil],
: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 nil],
: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
0.0, {:percent-json
: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 nil],
: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}
abase_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 nil],
: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",
ib/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 nil],
: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 nil],
: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 nil],
:effective_type :type/Text,
:active true,
:id 120,
ion",:lib/desired-column-alias "descript
: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 nil],
:effective_type :type/Integer,
:active true,
:id 110,
:lib/desired-column-alias "collection_id",
:position 8,
:visibility_type :normal,
:display_name "Collection ID",
:fingerprint
nct-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 nil],
: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}
"bool",tabase_type
: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 nil],
: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,
ource :source/card,
:lib/source-column-alias "is_verified",
:lib/model-display-name "Is Verified",
:field_ref [:field 126 nil],
: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 nil],
:effective_type :type/Boolean,
:active true,
:id 127,
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 nil],
: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 nil],
: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,
ce/card,b/source :sour
:lib/source-column-alias "collection_is_official",
:lib/model-display-name "Collection Is Official",
:field_ref [:field 121 nil],
: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",
_ref [:field 128 nil],
: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 nil],
:effective_type :type/Text,
:active true,
:id 111,
:lib/desired-column-alias "question_viz_type",
n 17,:positio
: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 nil],
:effective_type :type/Text,
:active true,
:id 116,
:lib/desired-column-alias "question_database_id",
:position 18,
:normal,ibility_type
: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 nil],
: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 nil],
: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
board""dash
{:name "entity_type", :base_type :type/Text, :semantic_type :type/Category, :database_type "VARCHAR"}]]
[:!= [:expression "Days since last view" {:base-type :type/Integer}] [:value nil {: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 nil]]],
: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