RHC

← All projects

Data quality

weather-data-pipeline-great-expectations

A weather data pipeline that collects hourly observations from 50+ global cities via the Open-Meteo API, validates every batch with Great Expectations, and transforms data through dbt into analytics-ready BigQuery tables.

weather-data-pipeline-great-expectations — Concept render
Concept render

Drawing

Diagram: data flows through four quality gates; a failed check halts the pipeline and sends an alert

Highlights

  • Quality gates check schema, null rates under 5%, value ranges, row counts and freshness under 3 hours.
  • Failed checks halt the pipeline and send Slack alerts.
  • 21 unit tests pass across 5 test suites.