• Joined on 2025-10-07
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
tudor pushed to main at tudor/school_compare 2026-03-26 21:19:00 +00:00
54df58746e feat(pipeline): use GIAS easting/northing for all geocoding, drop postcode step
tudor pushed to main at tudor/school_compare 2026-03-26 21:17:09 +00:00
d3e655abdb fix(dbt): compute geom from easting/northing in dim_location
tudor pushed to main at tudor/school_compare 2026-03-26 21:09:24 +00:00
45f3e4d9fc fix(dbt): override generate_schema_name to use direct schema names
tudor pushed to main at tudor/school_compare 2026-03-26 20:59:30 +00:00
d25e333826 fix(dbt): remove invalid relationship test on map_school_lineage
tudor pushed to main at tudor/school_compare 2026-03-26 20:51:41 +00:00
7f82088d53 fix(pipeline): use to_date for DD-MM-YYYY GIAS dates, exclude EES models from daily DAG
tudor pushed to main at tudor/school_compare 2026-03-26 20:43:28 +00:00
e7b1ab9f37 fix(pipeline): expand GIAS schema, handle empty strings, scope DAG selectors
tudor pushed to main at tudor/school_compare 2026-03-26 20:26:00 +00:00
24cfb83144 fix(dbt): fix GIAS source column quoting and remove tests on unloaded sources