Case Study: Pittsburgh achieves reliable, real-time civic data pipelines with Astro from Astronomer

Pittsburgh transforms 4M rows of data near real-time with Astronomer, Inc.

The City of Pittsburgh faced a challenge with its brittle public data pipelines, which were crumbling under the weight of expanding demands. Their existing Google Cloud Composer orchestrator required extensive manual maintenance, draining the small Data Services Team's time and jeopardizing a new transparency project called OneStopPGH Insights. They turned to the vendor Astronomer, Inc. and its product Astro for a more solid data foundation.

By implementing Astronomer's Astro platform, the city migrated its critical data pipelines and gained a unified orchestration layer. The solution provided stability and scale, resulting in over 4 million rows of data being transformed in near real-time and a 15% savings in engineering time. Astronomer's Astro eliminated the headaches of Airflow configuration, allowing the team to focus on delivering data products that increased government transparency and operational efficiency for residents.

Pittsburgh