Coverage

CI generates this page from conformance/run.py. Do not edit it.

coverage: 1426/1469 pass on Cube with the ClickHouse dialect (1426 pass, 26 partial, 0 blocked, 17 unsupported, 0 fail of 1469)

Metabase v0.65.3.6, Cube v1.8.20, ClickHouse 26.10.3-alpine, commit 6abec188284a, run, 2026-11-12.

Feature Status Reason
measure.format.abbr partial Limit of Metabase v0.65.3.6. Its formatNumber has the option compact for an abbreviated number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
measure.format.accounting partial Limit of Metabase v0.65.3.6. Its formatNumber has the option negativeInParentheses for parentheses on a negative number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
measure.format.currency pass
measure.format.currency_code pass
measure.format.d3 pass
measure.format.number_n pass
measure.format.percent pass
measure.format.percent_n pass
measure.multi_stage.case_switch pass
measure.multi_stage.filter_exclude pass
measure.multi_stage.grain_exclude pass
measure.multi_stage.grain_include pass
measure.multi_stage.grain_keep_only pass
measure.multi_stage.group_by_legacy pass
measure.multi_stage.share_of_total pass
measure.multi_stage.time_shift_named_calendar pass
measure.multi_stage.time_shift_next pass
measure.multi_stage.time_shift_prior pass
measure.opt.cross_cube_reference pass
measure.opt.description pass
measure.opt.drill_members pass
measure.opt.filters pass
measure.opt.filters_on_count pass
measure.opt.mask pass
measure.opt.meta pass
measure.opt.multi_stage pass
measure.opt.public_false pass
measure.opt.rolling_type_deprecated unsupported year_to_date, quarter_to_date and month_to_date are deprecated and Tesseract does not read them. The demo model uses to_date.
measure.opt.time_shift pass
measure.opt.title pass
measure.rolling.leading_offset pass
measure.rolling.to_date_month pass
measure.rolling.to_date_year pass
measure.rolling.trailing pass
measure.rolling.unbounded pass
measure.type.avg pass
measure.type.boolean pass
measure.type.count pass
measure.type.count_distinct pass
measure.type.count_distinct_approx pass
measure.type.max pass
measure.type.min pass
measure.type.number pass
measure.type.number_agg pass
measure.type.rank pass
measure.type.string pass
measure.type.sum pass
measure.type.time pass
dimension.format.abbr partial Limit of Metabase v0.65.3.6. Its formatNumber has the option compact for an abbreviated number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The field has a decimal format with the same decimals, and the description keeps the text of Cube.
dimension.format.currency pass
dimension.format.currency_code pass
dimension.format.id pass
dimension.format.image_url pass
dimension.format.link pass
dimension.format.link_label pass
dimension.format.percent pass
dimension.format.time pass
dimension.opt.case_label_sql pass
dimension.opt.case_sql pass
dimension.opt.description pass
dimension.opt.links pass
dimension.opt.mask_sql pass
dimension.opt.mask_static pass
dimension.opt.meta pass
dimension.opt.order pass
dimension.opt.primary_key pass
dimension.opt.propagate_filters pass
dimension.opt.public_false pass
dimension.opt.sub_query pass
dimension.opt.synthetic_hidden pass
dimension.opt.time_shift_calendar pass
dimension.opt.title pass
dimension.type.boolean pass
dimension.type.geo pass
dimension.type.geo.map_points pass
dimension.type.geo.map_grid pass
dimension.type.geo.raw_rows pass
dimension.type.geo.filter pass
dimension.type.geo.implicit_join pass
dimension.type.geo.view pass
dimension.type.geo.auto_bin pass
dimension.type.geo.second_stage pass
dimension.type.geo.fingerprint pass
dimension.type.number pass
dimension.type.string pass
dimension.type.switch pass
dimension.type.time pass
granularity.custom.interval_hours pass
granularity.custom.negative_offset pass
granularity.custom.offset partial Cube Store v1.8.20 puts a time before the origin of a custom granularity in months in the wrong bin, and no released Cube has a fix. The fix is a change of Cube Store in Rust (finding gran in cube-image/queue.json, no pull request yet), so cube-clickhouse cannot hold it. The driver stops such a query when a rollup serves the measure and the data starts before the origin. An offset has its origin in the current year, so this stops most offsets on a rollup. A measure that no rollup serves gives the truth. An origin before all rows gives the truth on a rollup.
granularity.custom.origin pass
granularity.custom.title pass
granularity.proxy_default pass
segment.combined pass
segment.description pass
segment.filter pass
segment.second pass
segment.title pass
segment.with_breakout pass
join.alias pass
join.fan_trap_avg pass
join.many_to_one pass
join.one_to_many_child_measure pass
join.one_to_many_no_fanout pass
join.one_to_one pass
join.sql_cube_join_field pass
join.transitive pass
cube.calendar pass
cube.calendar_granularity_sql pass
cube.data_source pass
cube.description pass
cube.extends pass
cube.meta pass
cube.public_false pass
cube.refresh_key pass
cube.sql pass
cube.sql_alias pass
cube.sql_table pass
cube.title pass
context.filter_group pass
context.filter_params pass
context.sql_utils_convert_tz pass
view.access_member_level pass
view.access_row_level pass
view.basic pass
view.default_filters pass
view.derived_measure pass
view.description pass
view.excludes pass
view.extends pass
view.folders pass
view.folders_nested pass
view.group pass
view.includes pass
view.member_alias pass
view.member_description pass
view.member_format pass
view.member_meta pass
view.member_title pass
view.meta pass
view.meta_auto_run unsupported meta.auto_run controls Cube Cloud workbooks. Metabase has no such behaviour.
view.meta_default_ui_filters unsupported meta.default_ui_filters controls Cube Cloud workbooks. Metabase has no such behaviour.
view.prefix pass
view.public_false pass
view.title pass
hierarchy.levels pass
hierarchy.public_false pass
preagg.indexes pass
preagg.original_sql pass
preagg.partitioned pass
preagg.rollup pass
preagg.rollup_join pass
preagg.rollup_lambda pass
sqlapi.aggregate_function pass
sqlapi.date_trunc pass
sqlapi.having pass
sqlapi.measure_function pass
sqlapi.order_limit pass
sqlapi.post_processing pass
sqlapi.pushdown_window pass
sqlapi.segment_in_where pass
sqlapi.ungrouped pass
sqlapi.union pass
sqlapi.where_between pass
sqlapi.where_in pass
sqlapi.where_is_null pass
sqlapi.where_like pass
restapi.compare_date_range partial compareDateRange is an option of the REST API, and Metabase has no request that gives one result for each range. The check proves the two Metabase forms of it. A dashboard date filter gives each range from one card, for each kind of measure. One question with a custom column compares ranges that do not overlap, and only for measures that add up, because the driver stops a distinct count next to a custom column.
restapi.total_query partial total: true is an option of the REST API, and Metabase has no request that gives a page of rows and the number of all rows together. The check proves the Metabase form of it: a second stage with a count on the same query gives the number of all rows, with the filters and with no limit, also over a saved question and through MCP.
clickhouse.bool pass
clickhouse.datetime_utc pass
clickhouse.decimal pass
clickhouse.function_in_measure pass
clickhouse.large_result pass
clickhouse.low_cardinality pass
clickhouse.nullable_expression pass
meta.base_types pass
meta.fingerprint_distinct_count pass
meta.fk_implicit_target pass
meta.measure_is_marked pass
meta.no_internal_columns pass
meta.resync_keeps_metadata pass
meta.semantic_types pass
meta.tables_match_public_members pass
mb.agg.avg_field pass
mb.agg.count_rows pass
mb.agg.count_where pass
mb.agg.cum_count pass
mb.agg.cum_sum pass
mb.agg.custom_expression pass
mb.agg.distinct pass
mb.agg.max_field pass
mb.agg.median pass
mb.agg.min_field pass
mb.agg.offset_window pass
mb.agg.percentile pass
mb.agg.share pass
mb.agg.stddev pass
mb.agg.sum_field pass
mb.agg.sum_where pass
mb.agg.two_measures pass
mb.agg.variance pass
mb.bucket.day pass
mb.bucket.day-of-month pass
mb.bucket.day-of-week pass
mb.bucket.day-of-year pass
mb.bucket.hour pass
mb.bucket.hour-of-day pass
mb.bucket.minute pass
mb.bucket.minute-of-hour pass
mb.bucket.month pass
mb.bucket.month-of-year pass
mb.bucket.quarter pass
mb.bucket.quarter-of-year pass
mb.bucket.week pass
mb.bucket.week-of-year pass
mb.bucket.year pass
mb.breakout.bin_count pass
mb.breakout.bin_width pass
mb.breakout.boolean pass
mb.breakout.limit pass
mb.breakout.sorted_by_measure pass
mb.breakout.two pass
mb.filter.and pass
mb.filter.between_number pass
mb.filter.boolean_false pass
mb.filter.boolean_true pass
mb.filter.contains pass
mb.filter.contains_ci pass
mb.filter.date_after pass
mb.filter.date_before pass
mb.filter.date_between pass
mb.filter.date_month pass
mb.filter.date_on pass
mb.filter.ends_with pass
mb.filter.eq_multi pass
mb.filter.eq_number pass
mb.filter.eq_string pass
mb.filter.exclude_day_of_week pass
mb.filter.exclude_month_of_year pass
mb.filter.gt pass
mb.filter.gte pass
mb.filter.is_empty pass
mb.filter.is_null pass
mb.filter.lt pass
mb.filter.lte pass
mb.filter.neq_number pass
mb.filter.neq_string pass
mb.filter.not pass
mb.filter.not_contains pass
mb.filter.not_empty pass
mb.filter.not_null pass
mb.filter.or pass
mb.filter.relative_current pass
mb.filter.relative_past pass
mb.filter.starts_with pass
mb.filter.starts_with_ci pass
mb.raw.fields_sorted pass
mb.raw.sort_desc pass
mb.expr.abs pass
mb.expr.add pass
mb.expr.case pass
mb.expr.ceil pass
mb.expr.coalesce pass
mb.expr.concat pass
mb.expr.datetime_add pass
mb.expr.datetime_diff pass
mb.expr.div pass
mb.expr.floor pass
mb.expr.get_month pass
mb.expr.get_year pass
mb.expr.length pass
mb.expr.log pass
mb.expr.lower pass
mb.expr.mul pass
mb.expr.power pass
mb.expr.replace pass
mb.expr.round pass
mb.expr.sqrt pass
mb.expr.substring pass
mb.expr.upper pass
mb.join.explicit_inner pass
mb.join.explicit_left pass
mb.join.implicit pass
mb.join.implicit_filter pass
mb.join.measure_across_cubes pass
mb.nested.filter_on_aggregation pass
mb.nested.question_as_source pass
mb.card.metric pass
mb.card.metric_with_breakout pass
mb.card.model pass
mb.card.saved_question pass
mb.entity.measure_custom pass
mb.entity.segment_custom pass
mb.export.csv pass
mb.export.json pass
mb.native.field_filter pass
mb.native.field_filter_date pass
mb.native.optional_clause pass
mb.native.param_date pass
mb.native.param_number pass
mb.native.param_text pass
mb.native.plain pass
mb.native.saved_card_param pass
mb.dashboard.filter_date pass
mb.dashboard.filter_number pass
mb.dashboard.filter_search pass
mb.dashboard.filter_string pass
mb.dashboard.filter_values pass
mb.dashboard.linked_filter pass
mb.dashboard.native_field_filter pass
mb.field_values.boolean pass
mb.field_values.list pass
mb.field_values.search pass
mb.search.by_description pass
mb.search.measure pass
mb.search.segment pass
mb.search.table pass
mb.xray.candidates pass
mb.xray.table pass
mb.xray.view pass
mb.report_timezone pass
mb.other.actions unsupported Metabase actions write data. The Cube SQL API is read only.
mb.other.drill_through_ui pass
mb.other.model_persistence unsupported Model persistence needs CREATE TABLE. The Cube SQL API is read only.
mb.other.uploads unsupported CSV uploads write tables. The Cube SQL API is read only.
mcp.agent_journey_no_cube_knowledge pass
mcp.alert_write pass
mcp.bookmark_content pass
mcp.browse.descriptions_in_get_fields pass
mcp.browse.get_fields_dimensions pass
mcp.browse.get_fields_measures pass
mcp.browse.get_fields_segments pass
mcp.browse.list_databases pass
mcp.browse.list_tables pass
mcp.collection_write pass
mcp.connect_oauth pass
mcp.dashboard_write pass
mcp.dashboard_write.create_and_filter pass
mcp.document_write pass
mcp.duplicate_content pass
mcp.execute_query pass
mcp.execute_query.breakout pass
mcp.execute_query.date_bucket pass
mcp.execute_query.filter pass
mcp.execute_query.implicit_join pass
mcp.execute_query.measure pass
mcp.execute_query.paging pass
mcp.execute_query.segment pass
mcp.execute_query.view pass
mcp.execute_sql pass
mcp.get_content pass
mcp.get_content.question pass
mcp.get_parameter_values pass
mcp.get_parameter_values.dashboard pass
mcp.get_parameter_values.question pass
mcp.get_parameter_values.search pass
mcp.glossary pass
mcp.learn pass
mcp.measure_write pass
mcp.metric_write pass
mcp.question_write pass
mcp.question_write.native pass
mcp.question_write.query pass
mcp.question_write.query_handle pass
mcp.render_drill_through pass
mcp.run_saved_question pass
mcp.search pass
mcp.search.measure pass
mcp.search.segment pass
mcp.search.table_by_description pass
mcp.search.view_description pass
mcp.segment_write pass
mcp.subscription_write pass
mcp.visualize_query pass
inherit.cube.members pass
inherit.cube.override_measure pass
inherit.cube.override_dimension pass
inherit.cube.add_measure pass
inherit.cube.add_dimension pass
inherit.multi_level.rows pass
inherit.multi_level.add_measure pass
inherit.multi_level.override pass
inherit.abstract_base pass
inherit.join pass
inherit.segment pass
inherit.pre_aggregation pass
inherit.view.members pass
inherit.view.adds pass
inherit.view.multi_level pass
view.includes_star pass
view.excludes_star pass
view.public_true pass
view.join_path_transitive pass
view.several_paths pass
view.same_name_two_cubes pass
view.on_extended_cube pass
view.prefix_sync pass
view.member_alias_sync pass
cube.sql_sync pass
cube.sql_alias_sync pass
cube.data_source_default pass
cube.polymorphic_first pass
cube.polymorphic_second pass
cube.polymorphic_base pass
cube.generated_jinja pass
cube.generated_jinja_second pass
cube.generated_async pass
cube.generated_async_second pass
semantic.measure.every_member pass
semantic.measure.in_summarize pass
semantic.measure.type_number pass
semantic.measure.type_string pass
semantic.measure.type_time pass
semantic.measure.type_boolean pass
semantic.segment.every_member pass
semantic.display_names pass
semantic.descriptions pass
semantic.format.currency pass
semantic.format.percent pass
semantic.format.link pass
semantic.fk.from_joins pass
semantic.fk.join_removed pass
semantic.drill_members pass
semantic.agent_reads_notes pass
semantic.resync_no_duplicates pass
semantic.model_change_updates pass
semantic.removed_archived pass
semantic.restored_member pass
semantic.user_edit_kept pass
semantic.user_edit_reset pass
semantic.drill_members_native unsupported Limit of Metabase v0.65.3.6: no object lists the drill columns of a measure. The drill to the rows of a group (src/metabase/lib/drill_thru/underlying_records.cljc) makes a query from the filters and the breakouts of the question, with each visible field of the table, and a driver has no hook in it. The text in the description is the only place, see semantic.drill_members.
semantic.measure.min_on_time_column pass
compile.agg.median_gives_error pass
compile.agg.offset_measure pass
compile.bucket.day pass
compile.bucket.hour pass
compile.bucket.minute pass
compile.bucket.month pass
compile.bucket.quarter pass
compile.bucket.year pass
compile.ch.approx_distinct_high_cardinality pass
compile.ch.approx_distinct_low_cardinality pass
compile.ch.array_as_text pass
compile.ch.array_has pass
compile.ch.array_length pass
compile.ch.array_measure pass
compile.ch.bool_group pass
compile.ch.date32_week pass
compile.ch.date_month pass
compile.ch.date_part_on_ny pass
compile.ch.datetime64_berlin_hour pass
compile.ch.datetime_ny_day pass
compile.ch.datetime_ny_raw pass
compile.ch.decimal_above_double partial Known wrong number. The SQL API of Cube has the type Double for numbers, so a long decimal loses digits. Its value fits the range of a Double, so the driver cannot see this. SELECT dec_big FROM typed_events WHERE id = 3 gives 3000000000000 where the truth is 3000000000000.00000003. A dimension with SQL toString(column) keeps the digits, and the check proves this.
compile.ch.decimal_row pass
compile.ch.decimal_sum pass
compile.ch.enum_group pass
compile.ch.float32 pass
compile.ch.lowcardinality_distinct pass
compile.ch.lowcardinality_group pass
compile.ch.lowcardinality_nullable_group pass
compile.ch.nullable_bool_group pass
compile.ch.nullable_decimal_sum pass
compile.ch.nullable_int_avg pass
compile.ch.nullable_string_distinct pass
compile.ch.nullable_string_group pass
compile.ch.nullable_time_month pass
compile.ch.uint64_above_double pass
compile.ch.uuid_filter pass
compile.empty.breakout pass
compile.empty.count pass
compile.empty.count_measure pass
compile.empty.distinct_measure pass
compile.empty.sum_is_null pass
compile.expr.boolean_is_true pass
compile.expr.case_two_branches pass
compile.expr.count_where_breakout pass
compile.expr.datediff_day pass
compile.expr.datediff_hour pass
compile.expr.datediff_minute pass
compile.expr.datediff_second pass
compile.expr.datediff_week pass
compile.expr.datetime_add_in_aggregated_query_gives_error pass
compile.expr.datetime_diff_month_gives_error pass
compile.expr.distinct_where pass
compile.expr.exp pass
compile.expr.get_day pass
compile.expr.get_day_of_week pass
compile.expr.get_hour pass
compile.expr.get_minute pass
compile.expr.get_quarter pass
compile.expr.get_second pass
compile.expr.in_aggregation pass
compile.expr.in_breakout pass
compile.expr.in_filter pass
compile.expr.in_filter_measure pass
compile.expr.integer_division pass
compile.expr.log_of_expression pass
compile.expr.ltrim pass
compile.expr.measure_arithmetic pass
compile.expr.rtrim pass
compile.expr.sum_of_dimension pass
compile.expr.sum_where pass
compile.expr.trim pass
compile.filter.bool_expr pass
compile.filter.bool_false pass
compile.filter.bool_null pass
compile.filter.bool_nullable_ne pass
compile.filter.bool_nullable_true pass
compile.filter.bool_true pass
compile.filter.not_group pass
compile.filter.number_between pass
compile.filter.number_decimal_eq pass
compile.filter.number_gt_null pass
compile.filter.number_is_null pass
compile.filter.number_multi pass
compile.filter.number_ne_null pass
compile.filter.string_contains pass
compile.filter.string_ends pass
compile.filter.string_ends_ci pass
compile.filter.string_is_empty pass
compile.filter.string_is_null pass
compile.filter.string_multi_ne pass
compile.filter.string_ne_null pass
compile.filter.string_not_contains pass
compile.filter.string_not_empty pass
compile.filter.string_not_null pass
compile.filter.string_starts pass
compile.filter.time_between_minutes pass
compile.filter.time_day_eq pass
compile.filter.time_gte pass
compile.filter.time_is_null pass
compile.filter.time_lte pass
compile.filter.time_month_eq pass
compile.filter.time_ne_day pass
compile.filter.time_next_days pass
compile.filter.time_not_null pass
compile.filter.time_on_berlin_column pass
compile.filter.time_on_date32_column pass
compile.filter.time_on_date_column pass
compile.filter.time_on_ny_column pass
compile.filter_measure.bool_true pass
compile.filter_measure.number_ne_null pass
compile.filter_measure.string_ne_null pass
compile.filter_measure.time_day_eq pass
compile.filter_measure.time_is_null pass
compile.granularity.native pass
compile.granularity.native_fiscal_year pass
compile.granularity.native_sunday pass
compile.granularity.proxy_no_bin pass
compile.join.explicit_two_cubes pass
compile.join.filter_on_both_sides pass
compile.join.implicit_two_tables pass
compile.join.implicit_uses_join_field pass
compile.join.inner_drops_rows_with_no_match pass
compile.join.inner_total pass
compile.join.left_keeps_rows_with_no_match pass
compile.join.no_fan_out pass
compile.join.other_columns_give_error pass
compile.join.subquery_gives_error pass
compile.latency.ten_million_rows pass
compile.native.error_keeps_cube_text pass
compile.native.explain_regular_with_parameter pass
compile.native.field_filter_empty_is_all_rows pass
compile.native.field_filter_multi pass
compile.native.field_filter_number_range pass
compile.native.field_filter_relative_date pass
compile.nested.aggregate_of_grouped_rows pass
compile.nested.custom_column_on_question pass
compile.nested.model_of_a_native_query pass
compile.nested.model_raw_rows_then_group pass
compile.nested.model_with_measure_then_filter pass
compile.nested.more_than_the_default_row_limit pass
compile.nested.raw_rows_with_filter pass
compile.nested.week_on_question_is_clear pass
compile.order.by_measure_desc pass
compile.order.limit pass
compile.order.page_offset pass
compile.order.page_offset_grouped pass
compile.order.two_columns pass
compile.part.day-of-month pass
compile.part.day-of-week pass
compile.part.day-of-year pass
compile.part.filter_measure pass
compile.part.filter_with_breakout pass
compile.part.hour-of-day pass
compile.part.minute-of-hour pass
compile.part.month-of-year pass
compile.part.non_additive_avg pass
compile.part.number_measure pass
compile.part.quarter-of-year pass
compile.part.second-of-minute pass
compile.pivot.date_and_string pass
compile.pivot.two_dimensions pass
compile.rolling.by_week_sunday pass
compile.rolling.with_status_filter pass
compile.rollup.avg_reads_the_table pass
compile.rollup.count_rows pass
compile.rollup.date_range_aligned pass
compile.rollup.date_range_not_aligned_is_right pass
compile.rollup.day_status pass
compile.rollup.filter_status_month pass
compile.rollup.month pass
compile.rollup.small_month_rollup_on_day_filter pass
compile.rollup.total pass
compile.rollup.week_monday pass
compile.rollup.week_sunday pass
compile.segment.two pass
compile.segment.with_breakout pass
compile.segment.with_filter_and_month pass
compile.tz.dst_day_in_new_york_column pass
compile.tz.filter_is_utc pass
compile.tz.set_time_zone_error pass
compile.values.big_table_status pass
compile.values.remapped_nullable pass
compile.values.search_lowcardinality pass
compile.week.day_of_week_monday pass
compile.week.day_of_week_sunday pass
compile.week.monday pass
compile.week.monday_measure pass
compile.week.saturday_without_granularity pass
compile.week.sunday_non_additive pass
compile.week.sunday_with_granularity pass
compile.week.sunday_without_granularity pass
compile.week.sunday_without_granularity_distinct pass
compile.week.week_of_year_monday pass
compile.join.explicit_measure_regular pass
compile.ch.integer_within_double pass
compile.xray.table_all_cards_run pass
compile.xray.field_all_cards_run pass
compile.xray.time_field_all_cards_run pass
compile.xray.typed_table_all_cards_run pass
compile.granularity.native_offset_no_rollup pass
compile.filter.quote_in_value pass
compile.filter.backslash_quote_in_value pass
compile.filter.quote_in_contains pass
compile.filter.backslash_in_case pass
compile.native.cross_join pass
compile.native.join_field pass
mcp.agent.list_tables_without_schema pass
mcp.agent.find_revenue_by_city pass
mcp.agent.search_names_owner_of_measure pass
mcp.agent.find_segment_owner pass
mcp.agent.table_description_lists_members pass
mcp.agent.database_guidance_works pass
mcp.agent.question_from_measure pass
mcp.agent.dashboard_wired_filter pass
mcp.agent.filter_values pass
mcp.agent.error_unknown_column pass
mcp.agent.error_join_on pass
isolation.other_db_field_fingerprint pass
native.not_like_in_select pass
native.not_like_three_values partial Cube reads NOT, <>, NOT IN, NOT LIKE, NOT BETWEEN, IS TRUE and IS DISTINCT FROM with another meaning for NULL. The driver proved its corrections only at the top of WHERE, HAVING and FILTER, so these forms stop with a message in CASE, as a value, in a function and in GROUP BY or ORDER BY. The same condition in FILTER or WHERE gives the truth.
legacy.view_default_filters partial With CUBEJS_TESSERACT_SQL_PLANNER=false, Cube drops the default_filters of a view with no error, and /v1/meta does not show which views have them, so the driver stops each query on a view there, also on a view with no default_filters. The Tesseract planner, the default since Cube v1.7.0, has none of this.
isolation.other_db_card_fingerprint pass
native.view_joined_dimension_weighted partial Native SQL stops on SUM of a dimension of a view from a joined cube, because Cube reads each row of that cube once. The message gives the weighted form, which is exact. The driver does not rewrite the native text into it.
native.row_limit pass
native.date_function pass
mcp.execute_query.paging_measure pass
dimension.opt.propagate_filters_next_to_another_sub_query partial Cube v1.8.20 with the Tesseract planner reads the first subquery for two sub_query dimensions with equal SQL when the query has a filter. The fix is a change of the planner in Rust, cube-js/cube#12502, so cube-clickhouse cannot hold it. The driver stops a query that groups by both, and raw rows show NULL in the later column. With other SQL, such as {orders.count} + 0, both work, and each is right alone, see dimension.opt.propagate_filters.
measure.multi_stage.time_shift_no_bucket_limit pass
clickhouse.datetime64_millis pass
compile.rolling.by_day_on_boundaries pass
compile.rolling.no_time_bucket_gives_error pass
compile.rolling.filter_inside_bucket_gives_error pass
compile.rolling.no_date_filter_gives_clear_error pass
compile.agg.other_aggregation_of_measure pass
compile.agg.count_of_measure pass
compile.agg.other_aggregation_can_give_error pass
compile.bound.strict_lower_with_upper pass
compile.bound.grid_measures pass
compile.bound.grid_date_types pass
compile.bound.grid_boundary_values pass
compile.bound.grid_view_and_join pass
compile.bound.grid_model_by_name pass
compile.bound.grid_mcp pass
compile.bound.fraction_of_a_second pass
native.bound.strict_lower_refused pass
nested.outer_date_filter.keeps_inner_rows pass
nested.outer_date_filter.rolling pass
nested.outer_date_filter.grid pass
nested.outer_filter.multi_stage_measure pass
nested.outer_stage.grid_breakout_and_aggregation pass
nested.outer_date_filter.native_source pass
nested.outer_date_filter.week_numbers pass
mb.dashboard.date_filter_on_question pass
measure.rolling.through_model pass
measure.rolling.through_model_whole_buckets pass
measure.rolling.filter_in_the_model pass
measure.rolling.strict_bound_on_boundary pass
nested.measure_column.filter_gives_row_values pass
nested.measure_column.breakout_gives_row_values pass
compile.filter.hidden_measure_column_refused pass
nested.measure_column.right_shapes_stay pass
nested.measure_column.other_aggregation pass
nested.model_of_model.measure_column pass
nested.model.raw_rows_of_a_measure_are_null pass
view.two_paths_in_one_query_refused pass
view.two_paths_one_column_stays pass
view.two_paths_with_join_alias pass
measure.rolling.native_refused pass
measure.rolling.native_whole_buckets pass
native.between_date_text_refused pass
native.between_date_parameter pass
docs.install.plugins_directory_writable pass
docs.known_wrong_numbers pass
nested.model_date_filter pass
nested.model_date_filter_on_expression pass
compile.week.default_with_date_filter pass
mcp.query.count_in_a_date_range pass
compile.week.relative_on_each_first_day pass
compile.error.segment_errors_are_clear pass
docs.fan_out_rule pass
measure.rolling.unbounded_one_bucket pass
demo.lambda_cube_is_hidden pass
build.package_with_no_java pass
build.load_check_sends_the_api_secret pass
docs.query_compilation_agrees_with_code pass
compile.bound.datetime64_whole_seconds_limit pass
native.count_on_no_rows pass
nested.model.multi_stage_measure_column pass
nested.question.multi_stage_outer_date_filter pass
nested.model.measure_column_bounds pass
nested.model.relative_and_bucket_filters pass
compile.bound.relative_strict pass
compile.case.date_bounds_in_an_aggregation pass
nested.measure_column.expression pass
nested.model.segment_column pass
nested.question_on_question.date_filter pass
nested.measure_column.filter_with_no_key_refused pass
mcp.query.between_keeps_time pass
isolation.other_driver_mcp_between pass
isolation.other_driver_cache pass
isolation.other_driver_sync pass
native.semantics.each_construct pass
native.semantics.in_a_stage pass
native.semantics.parameters_and_snippets pass
compile.join.fan_out_of_each_aggregation pass
compile.stage.name_reference_of_a_joined_column pass
compile.filter.long_lists pass
compile.join.total_of_dimension_refused pass
compile.expr.measure_with_expression_breakout pass
dialect.variant pass
dialect.b1_strict_lower_bound pass
dialect.interval_in_native_sql pass
dialect.n2_legacy_planner pass
native.subquery_filter_refused pass
native.bound.alias_in_a_subquery pass
native.bound.datetime64_upper_and_strict_lower pass
native.bound.datetime64_last_second_limit pass
compile.raw.switch_dimension_keeps_one_row pass
measure.rolling.window_shorter_than_bucket pass
grid.compact.dataset pass
fuzz.cases pass
fuzz.sample pass
clickhouse.aggregate_on_no_rows pass
filter.case_dimension_on_raw_rows pass
filter.fraction_beyond_the_scale_of_a_decimal pass
filter.aggregation_on_a_join_of_a_view_refused pass
measure.time_type_in_a_report_zone pass
grid.compact.mcp pass
grid.compact.report_zone pass
grid.compact.mcp_report_zone pass
grid.compact.start_of_week pass
metric.business.average_order_value pass
metric.business.churn pass
metric.business.conversion pass
metric.business.cube_measure_through_two_joins pass
metric.business.distinct_key_over_join pass
metric.business.distinct_over_join pass
metric.business.extended_base_hidden pass
metric.business.inherited_ratio_reads_override pass
metric.business.median pass
metric.business.month_over_month pass
metric.business.moving_average pass
metric.business.non_additive pass
metric.business.on_a_view pass
metric.business.on_an_extended_cube pass
metric.business.percentile pass
metric.business.ratio_on_a_view pass
metric.business.ratio_zero_null_denominator pass
metric.business.repeat_rate pass
metric.business.retention pass
metric.business.revenue pass
metric.business.running_total pass
metric.business.share_of_total pass
metric.business.through_two_joins pass
metric.business.weighted_average pass
metric.business.year_over_year pass
metric.composite.avg_of_ratio pass
metric.composite.cross_cube_count_ratio pass
metric.composite.cross_cube_sum_ratio pass
metric.composite.difference_over_base pass
metric.composite.distinct_over_count pass
metric.composite.filtered_numerator pass
metric.composite.nested_ratio pass
metric.composite.product pass
metric.composite.ratio_of_avgs pass
metric.composite.ratio_of_sums pass
metric.composite.rolling_over_plain pass
metric.composite.sum_of_row_ratios pass
metric.composite.sum_over_distinct pass
metric.composite.value_over_prior pass
metric.composite.value_over_total pass
metric.dimension.boolean pass
metric.dimension.case pass
metric.dimension.geo pass
metric.dimension.geo_with_a_joined_metric pass
metric.dimension.joined_string pass
metric.dimension.number pass
metric.dimension.ratio_by_sub_query pass
metric.dimension.string pass
metric.dimension.sub_query pass
metric.dimension.time pass
metric.edge.avg_ignores_null pass
metric.edge.avg_of_row_ratios pass
metric.edge.change_over_base pass
metric.edge.filtered_share pass
metric.edge.filtered_sum pass
metric.edge.max_negative pass
metric.edge.min_negative pass
metric.edge.ratio_with_no_guard pass
metric.edge.rows pass
metric.edge.sum_of_denominator pass
metric.edge.sum_of_numerator pass
metric.edge.sum_of_row_ratios pass
metric.expression.avg_over_avg pass
metric.expression.distinct_over_count pass
metric.expression.filtered_over_plain pass
metric.expression.ratio_of_two_sums pass
metric.expression.same_as_the_cube_metric pass
metric.expression.sum_over_count pass
metric.expression.sum_over_distinct pass
metric.expression.zero_and_null_denominator pass
metric.format.abbr partial Limit of Metabase v0.65.3.6. Its formatNumber has the option compact for an abbreviated number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
metric.format.abbr_1 partial Limit of Metabase v0.65.3.6. Its formatNumber has the option compact for an abbreviated number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
metric.format.accounting partial Limit of Metabase v0.65.3.6. Its formatNumber has the option negativeInParentheses for parentheses on a negative number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
metric.format.accounting_0 partial Limit of Metabase v0.65.3.6. Its formatNumber has the option negativeInParentheses for parentheses on a negative number (frontend/src/metabase/utils/formatting/numbers.tsx), but no column setting sets it: getComputedSettings (frontend/src/metabase/viz-core/lib/settings.ts) keeps only the settings that viz-core/lib/settings/column.ts defines, so each other key of the field settings is lost. The column has a decimal format with the same decimals, and the description keeps the text of Cube.
metric.format.currency pass
metric.format.currency_0 pass
metric.format.currency_3 pass
metric.format.currency_code pass
metric.format.d3 pass
metric.format.d3_percent pass
metric.format.id pass
metric.format.number pass
metric.format.number_0 pass
metric.format.number_3 pass
metric.format.percent pass
metric.format.percent_0 pass
metric.format.percent_2 pass
metric.mcp.discovery pass
metric.model.stock_form pass
metric.opt.add_group_by pass
metric.opt.drill_members pass
metric.opt.drill_members_text pass
metric.opt.filter_on_sum pass
metric.opt.filter_one pass
metric.opt.filter_or pass
metric.opt.filter_several pass
metric.opt.group_by pass
metric.opt.meta pass
metric.opt.multi_stage pass
metric.opt.public_false pass
metric.opt.reduce_by pass
metric.opt.rolling_leading pass
metric.opt.rolling_leading_offset_end pass
metric.opt.rolling_offset_end pass
metric.opt.rolling_offset_start pass
metric.opt.rolling_shorter_than_bucket_refused pass
metric.opt.rolling_to_date pass
metric.opt.rolling_to_date_year pass
metric.opt.rolling_trailing pass
metric.opt.rolling_unbounded pass
metric.opt.time_shift_calendar pass
metric.opt.time_shift_needs_a_range pass
metric.opt.time_shift_prior pass
metric.rollup.additive_at_rollup_grain_hit pass
metric.rollup.additive_coarser_hit pass
metric.rollup.additive_finer_miss pass
metric.rollup.day_window_by_month_refused pass
metric.rollup.non_additive_at_rollup_grain_hit pass
metric.rollup.non_additive_coarser_miss pass
metric.rollup.non_additive_finer_miss pass
metric.rollup.ratio_of_sums_coarser_hit pass
metric.rollup.ratio_of_sums_finer_miss pass
metric.rollup.ratio_of_sums_status_hit pass
metric.rollup.sum_over_distinct_coarser_miss pass
metric.semi_additive.closing_at_rollup_grain_hit pass
metric.semi_additive.closing_by_month_refused pass
metric.semi_additive.closing_finer_miss pass
metric.semi_additive.closing_region_at_rollup_grain_hit pass
metric.semi_additive.daily_average_at_rollup_grain_hit pass
metric.semi_additive.daily_average_coarser_miss pass
metric.semi_additive.is_not_additive_over_time pass
metric.semi_additive.last_day_at_day_and_total pass
metric.semi_additive.last_day_coarser_miss pass
metric.semi_additive.total_of_one_day_over_regions_hit pass
metric.type.avg pass
metric.type.boolean pass
metric.type.count pass
metric.type.count_distinct pass
metric.type.count_distinct_approx pass
metric.type.max pass
metric.type.min pass
metric.type.number pass
metric.type.number_agg pass
metric.type.rank pass
metric.type.string pass
metric.type.sum pass
metric.type.time pass
metric.composite.value_over_total_with_a_filter pass
metric.rollup.day_window_by_day_hit pass
metric.rollup.month_window_by_month_hit pass
metric.rollup.to_date_by_month_hit pass
metric.rollup.unbounded_by_month_hit pass
preagg.additive.count.coarser_dimension_hit pass
preagg.additive.count.coarser_time_hit pass
preagg.additive.count.finer_miss pass
preagg.additive.count.other_dimension_miss pass
preagg.additive.count.same_grain_hit pass
preagg.additive.count.total_hit pass
preagg.additive.max_amount.coarser_dimension_hit pass
preagg.additive.max_amount.coarser_time_hit pass
preagg.additive.max_amount.finer_miss pass
preagg.additive.max_amount.other_dimension_miss pass
preagg.additive.max_amount.same_grain_hit pass
preagg.additive.max_amount.total_hit pass
preagg.additive.min_amount.coarser_dimension_hit pass
preagg.additive.min_amount.coarser_time_hit pass
preagg.additive.min_amount.finer_miss pass
preagg.additive.min_amount.other_dimension_miss pass
preagg.additive.min_amount.same_grain_hit pass
preagg.additive.min_amount.total_hit pass
preagg.additive.paid_count.coarser_dimension_hit pass
preagg.additive.paid_count.coarser_time_hit pass
preagg.additive.paid_count.finer_miss pass
preagg.additive.paid_count.other_dimension_miss pass
preagg.additive.paid_count.same_grain_hit pass
preagg.additive.paid_count.total_hit pass
preagg.additive.paid_revenue.coarser_dimension_hit pass
preagg.additive.paid_revenue.coarser_time_hit pass
preagg.additive.paid_revenue.finer_miss pass
preagg.additive.paid_revenue.other_dimension_miss pass
preagg.additive.paid_revenue.same_grain_hit pass
preagg.additive.paid_revenue.total_hit pass
preagg.additive.per_order.coarser_dimension_hit pass
preagg.additive.per_order.coarser_time_hit pass
preagg.additive.per_order.finer_miss pass
preagg.additive.per_order.other_dimension_miss pass
preagg.additive.per_order.same_grain_hit pass
preagg.additive.per_order.total_hit pass
preagg.additive.revenue.coarser_dimension_hit pass
preagg.additive.revenue.coarser_time_hit pass
preagg.additive.revenue.finer_miss pass
preagg.additive.revenue.other_dimension_miss pass
preagg.additive.revenue.same_grain_hit pass
preagg.additive.revenue.total_hit pass
preagg.build_range.date_range_over_the_end_reads_only_the_range partial The docs warn that Cube does not return rows out of the build range. On the REST API of Cube, buckets after the end are not in the result, with no error, and no driver stands in front of it. In Metabase, preagg.build_range.metabase_gives_rows_out_of_the_range gives the truth.
preagg.build_range.inside_hit pass
preagg.build_range.whole_table_reads_only_the_range partial The docs warn that Cube does not return rows out of the build range. The REST API of Cube gives the sum of the range with no error, and no driver stands in front of it. In Metabase, preagg.build_range.metabase_gives_rows_out_of_the_range gives the truth.
preagg.granularity.day_hit pass
preagg.granularity.hour_hit pass
preagg.granularity.minute_hit pass
preagg.granularity.month_hit pass
preagg.granularity.quarter_hit pass
preagg.granularity.second_hit pass
preagg.granularity.week_hit pass
preagg.granularity.week_rollup_day_miss pass
preagg.granularity.week_rollup_month_miss pass
preagg.granularity.week_rollup_week_hit pass
preagg.granularity.week_rollup_year_miss pass
preagg.granularity.year_hit pass
preagg.latency.big_orders_hit_is_faster_than_a_miss pass
preagg.metabase.coarser_hit pass
preagg.metabase.date_range_inside_a_bucket_miss pass
preagg.metabase.date_range_on_a_boundary_hit pass
preagg.metabase.extended_cube_hit pass
preagg.metabase.filter_on_a_rollup_dimension_hit pass
preagg.metabase.filter_on_another_dimension_miss pass
preagg.metabase.finer_miss pass
preagg.metabase.join_through_a_view_hit pass
preagg.metabase.non_additive_coarser_miss pass
preagg.metabase.non_additive_same_grain_hit pass
preagg.metabase.other_dimension_miss pass
preagg.metabase.same_grain_hit pass
preagg.metabase.time_zone_day_hit pass
preagg.metabase.time_zone_finer_miss pass
preagg.metabase.time_zone_month_hit pass
preagg.metabase.view_hit pass
preagg.metabase.view_miss pass
preagg.model.stock_form pass
preagg.multi_stage.grand_total_hit pass
preagg.multi_stage.time_shift_hit pass
preagg.non_additive.any_completed.coarser_dimension_miss pass
preagg.non_additive.any_completed.coarser_time_miss pass
preagg.non_additive.any_completed.same_grain_hit pass
preagg.non_additive.any_completed.total_miss pass
preagg.non_additive.avg_amount.coarser_dimension_miss pass
preagg.non_additive.avg_amount.coarser_time_miss pass
preagg.non_additive.avg_amount.same_grain_hit pass
preagg.non_additive.avg_amount.total_miss pass
preagg.non_additive.buyers.coarser_dimension_miss pass
preagg.non_additive.buyers.coarser_time_miss pass
preagg.non_additive.buyers.same_grain_hit pass
preagg.non_additive.buyers.total_miss pass
preagg.non_additive.first_status.coarser_dimension_miss pass
preagg.non_additive.first_status.coarser_time_miss pass
preagg.non_additive.first_status.same_grain_hit pass
preagg.non_additive.first_status.total_miss pass
preagg.non_additive.last_at.coarser_dimension_miss pass
preagg.non_additive.last_at.coarser_time_miss pass
preagg.non_additive.last_at.same_grain_hit pass
preagg.non_additive.last_at.total_miss pass
preagg.non_additive.median_amount.coarser_dimension_miss pass
preagg.non_additive.median_amount.coarser_time_miss pass
preagg.non_additive.median_amount.same_grain_hit pass
preagg.non_additive.median_amount.total_miss pass
preagg.non_additive.mixed_with_additive_miss pass
preagg.non_additive.ratio_with_a_distinct_leaf_miss pass
preagg.option.external_false_coarser_hit pass
preagg.option.external_false_hit pass
preagg.option.external_false_miss pass
preagg.option.index_aggregate_hit pass
preagg.option.index_on_a_null_column_hit pass
preagg.option.index_regular_hit pass
preagg.option.no_index pass
preagg.option.non_strict_inside_a_bucket_reads_whole_buckets partial allow_non_strict_date_range_match: true on a rollup is the slight discrepancy of the docs. With a range inside a bucket, the rollup gives other rows than the truth, with no error. The env var that this stack and docs/query-compilation.md set to false does not change a rollup with this key. No driver stands in front of the REST API. In Metabase, preagg.option.non_strict_metabase_gives_a_range_inside_a_bucket gives the truth.
preagg.option.non_strict_on_a_boundary_hit pass
preagg.option.read_only_hit pass
preagg.option.scheduled_refresh_false_hit pass
preagg.option.strict_date_range_inside_a_bucket_miss pass
preagg.option.strict_date_range_on_a_boundary_hit pass
preagg.option.two_time_dimensions_hit pass
preagg.option.unique_key_hit pass
preagg.option.use_original_sql_coarser_hit pass
preagg.option.use_original_sql_same_grain_hit pass
preagg.partition.day_hit pass
preagg.partition.hour_hit pass
preagg.partition.month_hit pass
preagg.partition.quarter_hit pass
preagg.partition.range_inside_a_day_miss pass
preagg.partition.range_over_two_partitions_hit pass
preagg.partition.week_hit pass
preagg.partition.year_hit pass
preagg.refresh.every_old_number_ends_in_time pass
preagg.refresh.incremental_keeps_a_partition_out_of_the_window pass
preagg.refresh.incremental_refreshes_the_update_window pass
preagg.refresh.long_key_keeps_the_old_number_inside_its_time pass
preagg.refresh.no_update_window_refreshes_only_the_last_partition pass
preagg.refresh.sql_key_old_number_ends_in_time pass
preagg.refresh.through_metabase pass
preagg.rolling.finer_miss pass
preagg.rolling.running_same_grain_hit pass
preagg.rolling.to_date_coarser_time_hit pass
preagg.rolling.to_date_same_grain_hit pass
preagg.rolling.trailing_coarser_time_hit pass
preagg.rolling.trailing_same_grain_hit pass
preagg.shape.date_range_inside_a_bucket_miss pass
preagg.shape.date_range_on_day_boundary_hit pass
preagg.shape.date_range_on_month_boundary_hit pass
preagg.shape.extended_cube_hit pass
preagg.shape.extended_cube_miss pass
preagg.shape.filter_on_a_rollup_dimension_hit pass
preagg.shape.filter_on_another_dimension_miss pass
preagg.shape.join_dimension_in_the_rollup_coarser_hit pass
preagg.shape.join_dimension_in_the_rollup_hit pass
preagg.shape.join_dimension_not_in_the_rollup_miss pass
preagg.shape.join_with_fan_out_miss pass
preagg.shape.month_bucket_with_a_day_range_hit pass
preagg.shape.segment_in_the_rollup_hit pass
preagg.shape.segment_not_in_the_rollup_miss pass
preagg.shape.view_finer_miss pass
preagg.shape.view_hit pass
preagg.shape.view_joined_dimension_hit pass
preagg.shape.view_joined_dimension_miss pass
preagg.shape.view_non_additive_coarser_miss pass
preagg.shape.view_other_dimension_miss pass
preagg.time_zone.boundary_of_a_local_day_hit pass
preagg.time_zone.coarser_hit pass
preagg.time_zone.finer_miss pass
preagg.time_zone.inside_a_local_day_miss pass
preagg.time_zone.partitioned_hit pass
preagg.time_zone.same_grain_hit pass
preagg.type.count_distinct_approx_stops partial Cube has no sketch that ClickHouse can write and Cube Store can read. A rollup of count_distinct_approx stops each query on that measure, and each run of the refresh worker, so all other rollups go stale. No number is wrong while the query stops. The driver shows a clear message. The live model has no such rollup. A query with no such rollup reads the table.
preagg.type.original_sql_in_clickhouse pass
preagg.type.original_sql_in_cube_store pass
preagg.type.rollup_join_coarser_hit pass
preagg.type.rollup_join_filter_hit pass
preagg.type.rollup_join_finer_miss pass
preagg.type.rollup_join_other_dimension_miss pass
preagg.type.rollup_join_other_measure_miss pass
preagg.type.rollup_join_same_grain_hit pass
preagg.type.rollup_join_through_metabase pass
preagg.type.rollup_join_total_hit pass
preagg.type.rollup_lambda_after_the_batch_with_source pass
preagg.type.rollup_lambda_filter_hit pass
preagg.type.rollup_lambda_inside_the_batch_hit pass
preagg.type.rollup_lambda_miss_on_a_finer_grain pass
preagg.type.rollup_lambda_over_the_batch_with_source pass
preagg.metabase.time_zone_one_bound_miss pass
preagg.metabase.time_zone_range_next_to_a_filter_hit pass
preagg.metabase.time_zone_range_without_a_bucket_hit pass
preagg.refresh.scheduled_refresh_false_stays_old_until_a_job pass
preagg.shape.segment_left_out_hit pass
preagg.type.rollup_lambda_gap_loses_the_last_partition partial Cube reads each rollup of a rollup_lambda only up to the start of its last partition. If the next rollup does not hold that partition, those rows are not in the result, with no error. The docs say that the speed layer must hold the newer data. The model must overlap, see preagg.type.rollup_lambda_of_two_rollups_with_overlap_hit. No driver stands in front of the REST API. In Metabase, preagg.type.rollup_lambda_gap_metabase_gives_the_last_partition gives the truth.
preagg.type.rollup_lambda_of_two_rollups_with_overlap_hit pass
preagg.type.original_sql_in_cube_store_with_an_index_stops partial An index on an original_sql table in Cube Store names a column that the table does not have, so Cube stops with an error on each Cube. See cube-js/cube#7420. No number is wrong. The docs advise against this form.
preagg.refresh.cron_key_keeps_the_old_number_inside_its_time pass
preagg.metabase.time_zone_relative_range_hit pass
zone.ny.a.report.day pass
zone.ny.a.report.coarse pass
zone.ny.a.report.filter pass
zone.ny.a.report.stages pass
zone.ny.a.report.rolling pass
zone.ny.a.rest.day pass
zone.ny.a.rest.coarse pass
zone.ny.a.rest.filter pass
zone.ny.a.rest.stages pass
zone.ny.a.rest.rolling pass
zone.ny.a.plain.day pass
zone.ny.a.plain.coarse pass
zone.ny.a.plain.filter pass
zone.ny.a.plain.stages pass
zone.ny.a.plain.rolling pass
zone.ny.a64.report.day pass
zone.ny.a64.report.coarse pass
zone.ny.a64.report.filter pass
zone.ny.a64.report.stages pass
zone.ny.a64.report.rolling pass
zone.ny.a64.rest.day pass
zone.ny.a64.rest.coarse pass
zone.ny.a64.rest.filter pass
zone.ny.a64.rest.stages pass
zone.ny.a64.rest.rolling pass
zone.ny.a64.plain.day pass
zone.ny.a64.plain.coarse pass
zone.ny.a64.plain.filter pass
zone.ny.a64.plain.stages pass
zone.ny.a64.plain.rolling pass
zone.ny.b.report.day pass
zone.ny.b.report.coarse pass
zone.ny.b.report.filter pass
zone.ny.b.report.stages pass
zone.ny.b.report.rolling pass
zone.ny.b.rest.day pass
zone.ny.b.rest.coarse pass
zone.ny.b.rest.filter pass
zone.ny.b.rest.stages pass
zone.ny.b.rest.rolling pass
zone.ny.b.plain.day pass
zone.ny.b.plain.coarse pass
zone.ny.b.plain.filter pass
zone.ny.b.plain.stages pass
zone.ny.b.plain.rolling pass
zone.ny.c.report.day pass
zone.ny.c.report.coarse pass
zone.ny.c.report.filter pass
zone.ny.c.report.stages pass
zone.ny.c.report.rolling pass
zone.ny.c.rest.day pass
zone.ny.c.rest.coarse pass
zone.ny.c.rest.filter pass
zone.ny.c.rest.stages pass
zone.ny.c.rest.rolling pass
zone.ny.c.plain.day pass
zone.ny.c.plain.coarse pass
zone.ny.c.plain.filter pass
zone.ny.c.plain.stages pass
zone.ny.c.plain.rolling pass
zone.ny.cs.report.day pass
zone.ny.cs.report.coarse pass
zone.ny.cs.report.filter pass
zone.ny.cs.report.stages pass
zone.ny.cs.report.rolling pass
zone.ny.cs.rest.day pass
zone.ny.cs.rest.coarse pass
zone.ny.cs.rest.filter pass
zone.ny.cs.rest.stages pass
zone.ny.cs.rest.rolling pass
zone.ny.cs.plain.day pass
zone.ny.cs.plain.coarse pass
zone.ny.cs.plain.filter pass
zone.ny.cs.plain.stages pass
zone.ny.cs.plain.rolling pass
zone.ny.d.report.day pass
zone.ny.d.report.coarse pass
zone.ny.d.report.filter pass
zone.ny.d.report.stages pass
zone.ny.d.report.rolling pass
zone.ny.d.rest.day pass
zone.ny.d.rest.coarse pass
zone.ny.d.rest.filter pass
zone.ny.d.rest.stages pass
zone.ny.d.rest.rolling pass
zone.ny.d.plain.day pass
zone.ny.d.plain.coarse pass
zone.ny.d.plain.filter pass
zone.ny.d.plain.stages pass
zone.ny.d.plain.rolling pass
zone.kol.a.report.day pass
zone.kol.a.report.coarse pass
zone.kol.a.report.filter pass
zone.kol.a.report.stages pass
zone.kol.a.report.rolling pass
zone.kol.a.rest.day pass
zone.kol.a.rest.coarse pass
zone.kol.a.rest.filter pass
zone.kol.a.rest.stages pass
zone.kol.a.rest.rolling pass
zone.kol.a.plain.day pass
zone.kol.a.plain.coarse pass
zone.kol.a.plain.filter pass
zone.kol.a.plain.stages pass
zone.kol.a.plain.rolling pass
zone.kol.a64.report.day pass
zone.kol.a64.report.coarse pass
zone.kol.a64.report.filter pass
zone.kol.a64.report.stages pass
zone.kol.a64.report.rolling pass
zone.kol.a64.rest.day pass
zone.kol.a64.rest.coarse pass
zone.kol.a64.rest.filter pass
zone.kol.a64.rest.stages pass
zone.kol.a64.rest.rolling pass
zone.kol.a64.plain.day pass
zone.kol.a64.plain.coarse pass
zone.kol.a64.plain.filter pass
zone.kol.a64.plain.stages pass
zone.kol.a64.plain.rolling pass
zone.kol.b.report.day pass
zone.kol.b.report.coarse pass
zone.kol.b.report.filter pass
zone.kol.b.report.stages pass
zone.kol.b.report.rolling pass
zone.kol.b.rest.day pass
zone.kol.b.rest.coarse pass
zone.kol.b.rest.filter pass
zone.kol.b.rest.stages pass
zone.kol.b.rest.rolling pass
zone.kol.b.plain.day pass
zone.kol.b.plain.coarse pass
zone.kol.b.plain.filter pass
zone.kol.b.plain.stages pass
zone.kol.b.plain.rolling pass
zone.kol.c.report.day pass
zone.kol.c.report.coarse pass
zone.kol.c.report.filter pass
zone.kol.c.report.stages pass
zone.kol.c.report.rolling pass
zone.kol.c.rest.day pass
zone.kol.c.rest.coarse pass
zone.kol.c.rest.filter pass
zone.kol.c.rest.stages pass
zone.kol.c.rest.rolling pass
zone.kol.c.plain.day pass
zone.kol.c.plain.coarse pass
zone.kol.c.plain.filter pass
zone.kol.c.plain.stages pass
zone.kol.c.plain.rolling pass
zone.kol.cs.report.day pass
zone.kol.cs.report.coarse pass
zone.kol.cs.report.filter pass
zone.kol.cs.report.stages pass
zone.kol.cs.report.rolling pass
zone.kol.cs.rest.day pass
zone.kol.cs.rest.coarse pass
zone.kol.cs.rest.filter pass
zone.kol.cs.rest.stages pass
zone.kol.cs.rest.rolling pass
zone.kol.cs.plain.day pass
zone.kol.cs.plain.coarse pass
zone.kol.cs.plain.filter pass
zone.kol.cs.plain.stages pass
zone.kol.cs.plain.rolling pass
zone.kol.d.report.day pass
zone.kol.d.report.coarse pass
zone.kol.d.report.filter pass
zone.kol.d.report.stages pass
zone.kol.d.report.rolling pass
zone.kol.d.rest.day pass
zone.kol.d.rest.coarse pass
zone.kol.d.rest.filter pass
zone.kol.d.rest.stages pass
zone.kol.d.rest.rolling pass
zone.kol.d.plain.day pass
zone.kol.d.plain.coarse pass
zone.kol.d.plain.filter pass
zone.kol.d.plain.stages pass
zone.kol.d.plain.rolling pass
zone.ny.rollup.tables pass
zone.ny.rollup.job pass
zone.ny.rollup.metabase pass
zone.ny.rollup.rolling pass
zone.ny.rollup.stored_day pass
zone.ny.rollup.text_day pass
zone.kol.rollup.tables pass
zone.kol.rollup.job pass
zone.kol.rollup.metabase pass
zone.kol.rollup.rolling pass
zone.kol.rollup.stored_day pass
zone.kol.rollup.text_day pass
zone.ny.stored_day_other_zone pass
zone.ny.time_measure pass
zone.ny.native pass
zone.ny.mcp pass
zone.ny.catalog pass
zone.kol.stored_day_other_zone pass
zone.kol.time_measure pass
zone.kol.native pass
zone.kol.mcp pass
zone.kol.catalog pass
zone.rolling.sunday_week_with_no_granularity_refused pass
inherit.js.join_by_column_of_parent pass
inherit.js.raw_text_dimension pass
inherit.js.raw_case_dimension pass
inherit.multi_level.raw_text_dimension pass
inherit.js.rolling_with_no_bucket_refused pass
inherit.js.time_shift_with_no_bucket_refused pass
filter_params.value.date_range pass
filter_params.value.date_range_by_month pass
filter_params.value.date_range_in_a_zone pass
filter_params.value.date_range_with_two_bounds_in_a_zone pass
filter_params.value.one_bound_refused pass
filter_params.value.no_filter_refused pass
filter_params.value.or_refused pass
filter_params.value.expression_in_a_zone_refused pass
filter_params.value.native_strict_lower_refused pass
filter_params.value.native_date_range pass
filter_params.value.native_one_bound_refused pass
filter_params.value.one_text_value pass
filter_params.value.other_text_filter_refused pass
filter_params.condition.other_operator pass
preagg.empty_text_stays_apart_from_null pass
nested.model.count_keeps_rows_with_a_null_key pass
nested.model.row_value_with_a_null_key_refused pass
measure.count_with_a_null_key_refused pass
preagg.build_range.metabase_gives_rows_out_of_the_range pass
preagg.option.non_strict_metabase_gives_a_range_inside_a_bucket pass
preagg.type.rollup_lambda_gap_metabase_gives_the_last_partition pass
sync.private_primary_key_keeps_the_foreign_key pass
preagg.rollup_lambda_under_a_report_zone pass
compile.two_stages.default_filters_month_of_year pass
compile.two_stages.default_filters_day_of_week pass
compile.two_stages.default_filters_text_filter pass
compile.two_stages.default_filters_distinct_next_to_a_measure pass
compile.two_stages.count_where_on_a_joined_column pass
compile.two_stages.count_where_on_a_view_of_a_join pass
compile.two_stages.share_on_a_view_of_a_join pass
compile.two_stages.case_with_two_branches pass
compile.two_stages.case_next_to_a_measure pass
compile.expr.datetime_diff_from_a_literal pass
compile.expr.substring_in_a_breakout pass
compile.filter.long_list_of_values pass
compile.expr.function_of_no_plan_gets_a_clear_message pass
zone.distinct_time_with_no_repeated_hour pass
zone.time_measure_has_an_offset pass
compile.filter.fraction_list_keeps_digits pass
mcp.query.fraction_list_keeps_digits pass
mb.dashboard.fraction_list_parameter_keeps_digits pass
compile.join.each_aggregation_of_a_joined_column pass
mcp.query.count_of_a_joined_column pass
compile.join.no_join_path_has_a_clear_message pass
native.grammar.analyst_queries pass
native.grammar.sample pass
native.grammar.new_york_time_shapes pass
native.grammar.docs_list_each_construct pass
native.grammar.mutations_refuse pass
compile.raw.custom_column_next_to_each_column pass
native.scan.adversarial_private_member pass
zone.time_measure_repeated_hour_limit partial The SQL API gives a time as text with no offset, so a value in the repeated hour reads as the first pass: 01:00-04:00 where the truth is 01:00-05:00 in New York. README lists this under Known wrong numbers.
measure.type.count_with_sql pass
dimension.opt.cross_cube_reference pass
cube.sql_function_of_another_cube pass
segment.public_false pass
view.segment pass
view.rolling_measure pass
join.legacy_relationship_name pass
segment.meta pass
hierarchy.level_of_a_joined_cube pass
mb.expr.text pass
mb.expr.integer pass
mb.expr.float pass
mb.expr.date pass
mb.expr.datetime_subtract pass
mb.expr.get_week_iso pass
mb.expr.get_week_us pass
mb.expr.get_day_of_week_iso pass
mb.expr.now pass
mb.expr.today pass
mb.expr.literal pass
mb.filter.in pass
mb.filter.not_in pass
mb.filter.exclude_hour_of_day pass
mb.filter.exclude_quarter_of_year pass
mb.filter.not_date_between pass
mb.filter.during pass
mb.filter.relative_with_offset pass
mb.filter.relative_include_current pass
mb.filter.inside pass
mb.breakout.bin_default pass
mb.dashboard.filter_relative_date pass
mb.dashboard.filter_month_year pass
mb.dashboard.filter_quarter_year pass
mb.dashboard.filter_string_contains pass
mb.dashboard.filter_boolean pass
mb.dashboard.filter_id pass
mb.dashboard.filter_time_grouping pass
mb.native.time_grouping_param pass
mb.native.param_boolean pass
mb.native.card_reference pass
mb.export.xlsx pass
mcp.browse_collection pass
mcp.browse.list_models pass
mcp.browse.list_tables_search pass
mcp.browse.get_fields_values pass
mcp.execute_query.expression pass
mcp.execute_query.order_limit pass
mcp.execute_query.explicit_join pass
mcp.execute_query.two_stages pass
mcp.execute_query.binning pass
mcp.execute_query.validate_only pass
mcp.execute_sql.template_tag_values pass
mcp.run_saved_question.parameters pass
mb.expr.host unsupported Metabase writes this function as a regular expression with a lookbehind. ClickHouse reads a pattern with RE2, which has no lookbehind, and stock Cube has no form for a regular expression. The driver gives a message that tells to add a dimension with that SQL to the data model. See compile.expr.url_function_gets_a_clear_message.
mb.expr.domain unsupported Metabase writes this function as a regular expression with a lookbehind. ClickHouse reads a pattern with RE2, which has no lookbehind, and stock Cube has no form for a regular expression. The driver gives a message that tells to add a dimension with that SQL to the data model. See compile.expr.url_function_gets_a_clear_message.
mb.expr.subdomain unsupported Metabase writes this function as a regular expression with a lookbehind. ClickHouse reads a pattern with RE2, which has no lookbehind, and stock Cube has no form for a regular expression. The driver gives a message that tells to add a dimension with that SQL to the data model. See compile.expr.url_function_gets_a_clear_message.
mb.expr.path unsupported Metabase writes this function as a regular expression with a lookbehind. ClickHouse reads a pattern with RE2, which has no lookbehind, and stock Cube has no form for a regular expression. The driver gives a message that tells to add a dimension with that SQL to the data model. See compile.expr.url_function_gets_a_clear_message.
mb.expr.split_part pass
mb.expr.regex_match_first partial The query builder gives the truth for a pattern with a match and for no match. A pattern that matches empty text gives NULL, and Metabase on Postgres gives empty text: extract() of ClickHouse gives empty text also for no match, so the dialect cannot tell them apart. See mb.expr.regex_match_first.empty_match.
mb.expr.convert_timezone unsupported The SQL API of Cube has no form for a time in another zone. The driver turns off :convert-timezone, so Metabase does not offer convertTimezone. The report time zone of Metabase works, see mb.report_timezone and zone.*.
compile.expr.url_function_gets_a_clear_message pass
measure.type.running_total unsupported Cube v1.8.20 rejects the type when it compiles the model: measures.x.type must be one of [count, number, string, boolean, time, sum, avg, min, max, countDistinct, countDistinctApprox]. Use rolling_window with trailing: unbounded, see measure.rolling.unbounded.
mb.join.explicit_right unsupported Cube joins are left joins from the cube where the join is in the data model. The driver turns off :right-join, so Metabase does not offer this join type. A left join and an inner join work, see mb.join.explicit_left and mb.join.explicit_inner.
mb.join.explicit_full unsupported Cube joins are left joins from the cube where the join is in the data model. The driver turns off :full-join, so Metabase does not offer this join type. A left join and an inner join work, see mb.join.explicit_left and mb.join.explicit_inner.
graphql.api unsupported The GraphQL API is another way for a client to read Cube. The driver reads the SQL API and /v1/meta, and no Metabase query shape maps to GraphQL.
mb.expr.date_from_text pass
mb.expr.regex_match_first.empty_match partial With cube-clickhouse a pattern that matches empty text gives NULL, and Metabase on Postgres gives empty text. The check proves the NULL, and it fails when the limit goes away.
context.compile_context pass
security.access_policy_groups pass
security.compile_context pass
security.security_context_row_filter pass
security.sql_user_impersonation unsupported The driver does not use CUBEJS_SQL_SUPER_USER, SET user or __user. A live test on Cube v1.8.15 shows that a session of the super user accepts __user from native SQL, so a person who writes SQL reads as anybody. SET user works in one direction, so a pool cannot give the connection back. The driver connects as the person instead. See docs/security.md.
security.row_filter.measure_with_no_dimension pass
security.row_filter.native pass
security.row_filter.push_down pass
security.row_filter.mcp pass
security.row_filter.saved_question pass
security.row_filter.filter_values pass
security.row_filter.no_fingerprint_of_all_rows pass
security.no_switch.native_user_filter pass
security.no_switch.native_set_user pass
security.no_mixing_of_people pass
security.unknown_person_fails pass
security.user_attribute pass
security.public_link_fails pass
security.secret.not_in_api pass
security.secret.rest_requires_it pass
security.secret.not_in_logs pass
security.metabase_cache pass
security.card_fingerprints pass
security.card_fingerprints_cleared pass
security.field_fingerprints pass
security.dev_mode_warning_for_hidden_members partial Limit of Cube: with CUBEJS_DEV_MODE=true the SQL API reads hidden cubes and members (m6). A Cube with dev mode off refuses this query. docs/security.md warns about it.
security.validate_echoes_the_request_limit partial Limit of Metabase: this admin endpoint repeats the request body with the secret that the admin sent, for each driver (m7). No driver hook applies. Each read of a stored database gives the mask.
security.private_member_gives_no_value pass
security.attribute_added_later_clears_the_lists pass
security.saved_native_question_infers_no_private_member pass