Worked on the getsentry/snuba repository to implement a denormalized group_first_seen column in the errors table, enabling direct sorting of error groups by their first appearance time. This feature was developed across local, distributed, and read-only table variants, leveraging ClickHouse for database operations and SQL for schema changes. The approach included a rollback mechanism to ensure safe schema evolution and minimize risk during deployment. By adjusting query paths and supporting faster group-based sorting, the work reduced query latency and improved the efficiency of error triage and investigation, contributing to more responsive reliability dashboards and streamlined analytics for engineering teams.