SQL Test Generator

소개

This skill automates the creation and maintenance of unit test fixtures for BigQuery SQL queries, ensuring transformation logic is validated on small, synthetic datasets rather than production data. It provides standardized templates for input fixtures, expected results, and query parameters while enforcing critical safety checks to prevent accidental production queries. By integrating with the bigquery-etl ecosystem, it helps developers implement robust testing strategies for complex scenarios like Glean events, multi-source unions, and intricate aggregations, ultimately strengthening the reliability of data pipelines within CI/CD workflows.

주요 기능

• Standardized templates for complex SQL patterns including UNION ALL and array-based telemetry
• Seamless integration with pytest for local development-time validation
• Production query prevention logic via source table identification and fixture verification
• 0 GitHub stars
• Automated generation of synthetic test fixtures for BigQuery tables and Glean events
• Support for ISO 8601 timestamp formatting and BigQuery-specific parameter configurations

사용 사례

• Migrating legacy telemetry queries to updated schemas with verified logic consistency
• Establishing safe testing environments that guarantee no production data is touched during CI/CD
• Creating unit test fixtures to validate new BigQuery transformation logic during development