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 |