Part 4 - The Daily Report and What the Data Told MeHow I built a serverless daily home report using AWS Lambda, Athena, and SES. Five SQL queries that turn smart home sensor data into insights.8 min read·areebakhizer.hashnode.devOct 16
Part 3 - Stage by Stage: Building the Home Assistant ETLThree nightly AWS Glue jobs clean, flatten, and roll up raw Home Assistant events into Parquet tables queryable via Athena.7 min read·areebakhizer.hashnode.devSep 10
Part 2 — Getting Data from Home Assistant to AWS: The HA ForwarderA Python WebSocket forwarder that taps Home Assistant events, filters noise, and ships to AWS Kinesis. Part 2 of building a smart home data platform.9 min read·areebakhizer.hashnode.devAug 21
Unlocking Home Assistant Data: Building a Query Platform Part 1 — The PreludeHA deletes all history after 10 days. I built a pipeline to capture, store, and query it permanently.4 min read·areebakhizer.hashnode.devAug 3