date_created_tsmost_recent_status_tsEvery test recorded for the latest run, sorted
failures-first. Two test families: baseline.* compares
live row counts to a frozen expected value; dbt_test.*
surfaces every dbt test from run_results.json. Rows
tagged by design are
intentionally-inactive baselines (e.g. the current-year row count,
which grows daily and would trip the drift tolerance); they're
held as warn, not fail, so the pipeline
guardrail stays green. See limitation
drift-fail-current-year-baseline-unstable.
| Status | Test | Target | Actual | Expected | Variance | Message |
|---|---|---|---|---|---|---|
| fail | baseline.dim_date.all.row_count | dim_date | 4146 | 3994 | +3.81% | variance 3.81% exceeds tolerance 1.00% |
| fail | baseline.dim_request_type.all.row_count | dim_request_type | 354 | 342 | +3.51% | variance 3.51% exceeds tolerance 1.00% |
| fail | baseline.fct_311_requests.all.row_count | fct_311_requests | 1227208 | 1169569 | +4.93% | variance 4.93% exceeds tolerance 1.00% |
| fail | baseline.raw_311_requests.all.row_count | raw_311_requests | 1227208 | 1169569 | +4.93% | variance 4.93% exceeds tolerance 1.00% |
| warn by design | baseline.raw_311_requests.year_2026.row_count | raw_311_requests | 107055 | baseline intentionally inactive -- current-year row count is unstable by design (see drift-fail-current-year-baseline-unstable) | ||
| pass | baseline.dim_status.all.row_count | dim_status | 4 | 4 | +0.00% | |
| pass | baseline.raw_311_requests.year_2015.row_count | raw_311_requests | 47686 | 47686 | +0.00% | |
| pass | baseline.raw_311_requests.year_2016.row_count | raw_311_requests | 102790 | 102790 | +0.00% | |
| pass | baseline.raw_311_requests.year_2017.row_count | raw_311_requests | 103520 | 103520 | +0.00% | |
| pass | baseline.raw_311_requests.year_2018.row_count | raw_311_requests | 100192 | 100192 | +0.00% | |
| pass | baseline.raw_311_requests.year_2019.row_count | raw_311_requests | 98758 | 98758 | +0.00% | |
| pass | baseline.raw_311_requests.year_2020.row_count | raw_311_requests | 106267 | 106267 | +0.00% | |
| pass | baseline.raw_311_requests.year_2021.row_count | raw_311_requests | 111442 | 111442 | +0.00% | |
| pass | baseline.raw_311_requests.year_2022.row_count | raw_311_requests | 101477 | 101477 | +0.00% | |
| pass | baseline.raw_311_requests.year_2023.row_count | raw_311_requests | 115207 | 115207 | +0.00% | |
| pass | baseline.raw_311_requests.year_2024.row_count | raw_311_requests | 113961 | 113961 | +0.00% | |
| pass | baseline.raw_311_requests.year_2025.row_count | raw_311_requests | 118853 | 118853 | +0.00% | |
| pass | dbt_test.accepted_values_dim_offense_category_offense_category__Crimes_against_Property__Crimes_against_Person__Crimes_against_Society__Other | 0 | 0 | |||
| pass | dbt_test.accepted_values_dim_offense_code_offense_category__Crimes_against_Property__Crimes_against_Person__Crimes_against_Society__Other | 0 | 0 | |||
| pass | dbt_test.accepted_values_dim_status_status__Open__Closed__In_Progress__On_Hold | 0 | 0 | |||
| pass | dbt_test.accepted_values_dim_survey_question_topic__core_wellbeing__neighborhood__city_services__community_education__civic_information | 0 | 0 | |||
| pass | dbt_test.accepted_values_dim_survey_wave_wave_year__2011__2013__2015__2017__2019__2021__2023__2025 | 0 | 0 | |||
| pass | dbt_test.accepted_values_fct_crime_incidents_offense_category__Crimes_against_Property__Crimes_against_Person__Crimes_against_Society__Other | 0 | 0 | |||
| pass | dbt_test.accepted_values_fct_happiness_survey_geography_level__city__ward | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_311_requests_classification__Service__Information__Feedback | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_somerville_at_a_glance_geography__Somerville__Massachusetts | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_somerville_happiness_survey_ward__True__1__2__3__4__5__6__7 | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_somerville_happiness_survey_year__2011__2013__2015__2017__2019__2021__2023__2025 | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_somerville_traffic_citations_ward__1__2__3__4__5__6__7 | 0 | 0 | |||
| pass | dbt_test.accepted_values_raw_somerville_traffic_citations_warning__Y__N | 0 | 0 | |||
| pass | dbt_test.not_null_dim_date_date_dt | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_first_year | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_geography_count | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_has_massachusetts_benchmark | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_has_somerville_data | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_latest_year | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_observation_count | 0 | 0 | |||
| pass | dbt_test.not_null_dim_kpi_topic_topic | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_category_offense_category | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_category_severity_rank | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_is_active | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_is_multi_offense_grouping | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_offense | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_offense_category | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_offense_code | 0 | 0 | |||
| pass | dbt_test.not_null_dim_offense_code_offense_type | 0 | 0 | |||
| pass | dbt_test.not_null_dim_request_type_request_type | 0 | 0 | |||
| pass | dbt_test.not_null_dim_request_type_request_type_id | 0 | 0 | |||
| pass | dbt_test.not_null_dim_status_status | 0 | 0 | |||
| pass | dbt_test.not_null_dim_status_status_id | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_column_name | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_first_wave_asked | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_last_wave_asked | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_question_label | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_scale_max | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_scale_min | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_survey_question_id | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_topic | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_question_waves_asked_count | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_wave_respondent_count | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_wave_survey_wave_id | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_wave_ward_coverage_pct | 0 | 0 | |||
| pass | dbt_test.not_null_dim_survey_wave_wave_year | 0 | 0 | |||
| pass | dbt_test.not_null_dim_ward_ward | 0 | 0 | |||
| pass | dbt_test.not_null_dim_ward_ward_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_311_requests_date_created_dt | 0 | 0 | |||
| pass | dbt_test.not_null_fct_311_requests_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_citations_citation_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_citations_citation_number | 0 | 0 | |||
| pass | dbt_test.not_null_fct_citations_citation_ts | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_case_number | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_incident_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_incident_year | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_incident_year_only | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_multi_offense_flag | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_offense_category | 0 | 0 | |||
| pass | dbt_test.not_null_fct_crime_incidents_offense_code | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_geography_level | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_mean_score | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_respondent_count | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_survey_observation_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_survey_question_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_happiness_survey_survey_wave_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_permits_application_date | 0 | 0 | |||
| pass | dbt_test.not_null_fct_permits_permit_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_permits_permit_number | 0 | 0 | |||
| pass | dbt_test.not_null_fct_somerville_kpi_kpi_id | 0 | 0 | |||
| pass | dbt_test.not_null_fct_somerville_kpi_topic | 0 | 0 | |||
| pass | dbt_test.not_null_fct_somerville_kpi_year | 0 | 0 | |||
| pass | dbt_test.not_null_raw_311_requests_classification | 0 | 0 | |||
| pass | dbt_test.not_null_raw_311_requests_date_created | 0 | 0 | |||
| pass | dbt_test.not_null_raw_311_requests_id | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_description | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_geography | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_topic | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_units | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_value | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_at_a_glance_year | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_crime_incnum | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_happiness_survey_id | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_happiness_survey_year | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_permits_application_date | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_permits_id | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_traffic_citations_citationnum | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_traffic_citations_dtissued | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_traffic_citations_warning | 0 | 0 | |||
| pass | dbt_test.not_null_raw_somerville_wards_ward_number | 0 | 0 | |||
| pass | dbt_test.relationships_dim_offense_code_offense_category__offense_category__ref_dim_offense_category_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_311_requests_request_type_id__request_type_id__ref_dim_request_type_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_311_requests_status_id__status_id__ref_dim_status_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_311_requests_ward__ward__ref_dim_ward_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_citations_ward__ward__ref_dim_ward_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_crime_incidents_offense_category__offense_category__ref_dim_offense_category_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_crime_incidents_offense_code__offense_code__ref_dim_offense_code_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_crime_incidents_ward__ward__ref_dim_ward_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_happiness_survey_survey_question_id__survey_question_id__ref_dim_survey_question_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_happiness_survey_survey_wave_id__survey_wave_id__ref_dim_survey_wave_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_permits_ward__ward__ref_dim_ward_ | 0 | 0 | |||
| pass | dbt_test.relationships_fct_somerville_kpi_topic__topic__ref_dim_kpi_topic_ | 0 | 0 | |||
| pass | dbt_test.unique_dim_date_date_dt | 0 | 0 | |||
| pass | dbt_test.unique_dim_kpi_topic_topic | 0 | 0 | |||
| pass | dbt_test.unique_dim_offense_category_offense_category | 0 | 0 | |||
| pass | dbt_test.unique_dim_offense_category_severity_rank | 0 | 0 | |||
| pass | dbt_test.unique_dim_offense_code_offense_code | 0 | 0 | |||
| pass | dbt_test.unique_dim_request_type_request_type_id | 0 | 0 | |||
| pass | dbt_test.unique_dim_status_status_id | 0 | 0 | |||
| pass | dbt_test.unique_dim_survey_question_column_name | 0 | 0 | |||
| pass | dbt_test.unique_dim_survey_question_survey_question_id | 0 | 0 | |||
| pass | dbt_test.unique_dim_survey_wave_survey_wave_id | 0 | 0 | |||
| pass | dbt_test.unique_dim_ward_ward | 0 | 0 | |||
| pass | dbt_test.unique_dim_ward_ward_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_311_requests_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_citations_citation_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_citations_citation_number | 0 | 0 | |||
| pass | dbt_test.unique_fct_crime_incidents_case_number | 0 | 0 | |||
| pass | dbt_test.unique_fct_crime_incidents_incident_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_happiness_survey_survey_observation_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_permits_permit_id | 0 | 0 | |||
| pass | dbt_test.unique_fct_permits_permit_number | 0 | 0 | |||
| pass | dbt_test.unique_fct_somerville_kpi_kpi_id | 0 | 0 | |||
| pass | dbt_test.unique_raw_311_requests_id | 0 | 0 | |||
| pass | dbt_test.unique_raw_somerville_crime_incnum | 0 | 0 | |||
| pass | dbt_test.unique_raw_somerville_happiness_survey_id | 0 | 0 | |||
| pass | dbt_test.unique_raw_somerville_permits_id | 0 | 0 | |||
| pass | dbt_test.unique_raw_somerville_traffic_citations_citationnum | 0 | 0 | |||
| pass | dbt_test.unique_raw_somerville_wards_ward_number | 0 | 0 |
0 of the last 30 runs passed all tests. Each tile below is one pipeline run, oldest on the left — green is all-pass, amber is warn-only, red is any-fail.
| Run completed | Tests | Pass | Fail | Warn | Status |
|---|---|---|---|---|---|
| 2026-10-07 06:18 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-10-05 06:18 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-10-04 06:19 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-10-03 06:18 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-10-02 06:18 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-10-01 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-30 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-29 22:07 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-29 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-28 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-27 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-26 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-25 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-24 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-22 06:15 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-21 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-20 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-18 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-16 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-15 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-14 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-13 06:17 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-12 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-11 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-10 06:16 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-09 06:15 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-09-08 22:31 ET | 146 | 141 | 4 | 1 | 4 failed |
| 2026-07-08 06:14 ET | 146 | 142 | 3 | 1 | 3 failed |
| 2026-07-07 06:15 ET | 146 | 142 | 3 | 1 | 3 failed |
| 2026-07-06 06:15 ET | 146 | 142 | 3 | 1 | 3 failed |
Median run time across the last 29 completed runs: 16m 56s. Times in ET. Records-fetched columns are populated from Plan 1a onward; older runs show —.
| Started (ET) | Completed (ET) | Duration | Status | Records fetched | New | Updated |
|---|---|---|---|---|---|---|
| 2026-10-07 06:00 | — | — | in_progress | — | — | — |
| 2026-10-05 06:00 | 2026-10-05 06:18 | 18m 36s | partial | — | — | — |
| 2026-10-04 06:00 | 2026-10-04 06:19 | 19m 34s | partial | — | — | — |
| 2026-10-03 06:00 | 2026-10-03 06:19 | 18m 45s | partial | — | — | — |
| 2026-10-02 06:00 | 2026-10-02 06:18 | 18m 22s | partial | — | — | — |
| 2026-10-01 06:00 | 2026-10-01 06:17 | 17m 11s | partial | — | — | — |
| 2026-09-30 06:00 | 2026-09-30 06:17 | 16m 49s | partial | — | — | — |
| 2026-09-29 21:51 | 2026-09-29 22:08 | 16m 33s | partial | — | — | — |
| 2026-09-29 06:00 | 2026-09-29 06:17 | 17m 26s | partial | — | — | — |
| 2026-09-28 06:00 | 2026-09-28 06:17 | 17m 39s | partial | — | — | — |
| 2026-09-27 06:00 | 2026-09-27 06:17 | 17m 27s | partial | — | — | — |
| 2026-09-26 06:00 | 2026-09-26 06:17 | 16m 54s | partial | — | — | — |
| 2026-09-25 06:00 | 2026-09-25 06:16 | 16m 13s | partial | — | — | — |
| 2026-09-24 06:00 | 2026-09-24 06:17 | 16m 49s | partial | — | — | — |
| 2026-09-22 06:00 | 2026-09-22 06:16 | 16m 7s | partial | — | — | — |
| 2026-09-21 06:00 | 2026-09-21 06:17 | 17m 19s | partial | — | — | — |
| 2026-09-20 06:00 | 2026-09-20 06:16 | 16m 30s | partial | — | — | — |
| 2026-09-18 06:00 | 2026-09-18 06:17 | 16m 58s | partial | — | — | — |
| 2026-09-17 06:00 | 2026-09-17 06:00 | 1s | failed at dlt_ingest_311 |
— | — | — |
| 2026-09-16 06:00 | 2026-09-16 06:16 | 16m 17s | partial | — | — | — |
| 2026-09-15 06:00 | 2026-09-15 06:17 | 17m 24s | partial | — | — | — |
| 2026-09-14 06:00 | 2026-09-14 06:17 | 17m 2s | partial | — | — | — |
| 2026-09-13 06:00 | 2026-09-13 06:17 | 17m 23s | partial | — | — | — |
| 2026-09-12 06:00 | 2026-09-12 06:17 | 16m 56s | partial | — | — | — |
| 2026-09-11 06:00 | 2026-09-11 06:17 | 16m 48s | partial | — | — | — |
| 2026-09-10 06:00 | 2026-09-10 06:17 | 17m 0s | partial | — | — | — |
| 2026-09-09 06:00 | 2026-09-09 06:15 | 15m 49s | partial | — | — | — |
| 2026-09-08 22:15 | 2026-09-08 22:31 | 16m 41s | partial | — | — | — |
| 2026-07-09 06:00 | 2026-07-09 06:00 | 1s | failed at dlt_ingest_311 |
— | — | — |
| 2026-07-08 06:00 | 2026-07-08 06:15 | 15m 0s | partial | — | — | — |