I built a small open-source tool called sqltesting to test SQL transformations using mock tables + assertions. It works with BigQuery, Snowflake, Redshift, Athena, Trino, and DuckDB. Also made mocksmith library to generate realistic test data by simply adding mockable annotation on existing classes
Curious how others test SQL logic today. Do you write tests, or just rely on warehouse runs?
gurmeetsaran•1h ago
Curious how others test SQL logic today. Do you write tests, or just rely on warehouse runs?