tudor

tudor pushed to main at tudor/school_compare

2026-03-27 12:50:59 +00:00

5d8b319451 fix(dbt): stub rc_* columns as NULL in stg_ofsted_inspections

tudor pushed to main at tudor/school_compare

2026-03-27 12:16:37 +00:00

77f75fb6e5 fix(dbt): deduplicate predecessor KS2 rows and downgrade orphan test to warn

tudor pushed to main at tudor/school_compare

2026-03-27 12:00:32 +00:00

b41e6c250e fix(dbt): filter non-numeric URNs and trim whitespace in EES staging models

tudor pushed to main at tudor/school_compare

2026-03-27 11:42:42 +00:00

6e720feca4 perf(dbt): collapse stg_ees_ks2 to single-pass pivot

tudor pushed to main at tudor/school_compare

2026-03-27 11:20:21 +00:00

ae9fd26eba perf(dbt): materialize stg_ees_ks2 and stg_ees_ks4 as tables

tudor pushed to main at tudor/school_compare

2026-03-27 10:41:31 +00:00

33b395d2bd fix(dbt): apply safe_numeric macro to fix EES suppression code 'c' errors

tudor pushed to main at tudor/school_compare

2026-03-27 10:13:19 +00:00

8e8d1bd8c5 fix(ees-tap): filter out rows with null URN before emitting

tudor pushed to main at tudor/school_compare

2026-03-27 10:03:18 +00:00

c7357336e3 fix(ees-tap): fix BOM handling for admissions CSV

tudor pushed to main at tudor/school_compare

2026-03-27 09:54:16 +00:00

b8ecc5c58b fix(ees-tap): strip UTF-8 BOM from CSV column names

tudor pushed to main at tudor/school_compare

2026-03-27 09:41:47 +00:00

f4f0257447 fix(ees-tap): add latin-1 encoding for census/admissions, default utf-8 for others

ca351e9d73 feat: migrate backend to marts schema, update EES tap for verified datasets

Compare 2 commits »

tudor pushed to main at tudor/school_compare

2026-03-26 23:08:52 +00:00

d82e36e7b2 feat(ees): rewrite EES tap and KS2 models for actual data structure

tudor pushed to main at tudor/school_compare

2026-03-26 22:45:04 +00:00

719f06e480 fix(pipeline): make total_pupils non-optional for Typesense, add lat/lng to dim_location

tudor pushed to main at tudor/school_compare

2026-03-26 22:16:22 +00:00

5e44d88d23 fix(sync): use numeric default_sorting_field, dynamic KS2/KS4 joins, populate geopoints

tudor pushed to main at tudor/school_compare

2026-03-26 22:11:01 +00:00

cc481aa00c fix(airflow): remove PostGIS init from airflow, rely on postgis image initdb

tudor pushed to main at tudor/school_compare

2026-03-26 22:08:14 +00:00

613a030c95 fix(airflow): ensure PostGIS extension exists during init

tudor pushed to main at tudor/school_compare

2026-03-26 21:47:02 +00:00

72cbbf7778 fix(dbt): simplify search_path to just public for PostGIS

tudor pushed to main at tudor/school_compare

2026-03-26 21:45:55 +00:00

03256fed41 fix(dbt): add search_path to profile so PostGIS functions resolve in all schemas

tudor pushed to main at tudor/school_compare

2026-03-26 21:45:04 +00:00

b7cc01f26f fix(dbt): schema-qualify PostGIS functions in dim_location

tudor pushed to main at tudor/school_compare

2026-03-26 21:29:18 +00:00

28ba2fd0a6 fix(dbt): cast easting/northing to double precision for ST_MakePoint

tudor pushed to main at tudor/school_compare

2026-03-26 21:28:05 +00:00

03cd1de6af fix(airflow): delete and reimport DAGs on init to clear stale task refs