{"repo":"gurmeetsaran/sqltesting","free":true,"listed":false,"github":"https://github.com/gurmeetsaran/sqltesting","clone":"git clone https://github.com/gurmeetsaran/sqltesting.git","description":"Library for Running SQL Unit Test Cases","language":"Python","stars":38,"topics":["athena","bigquery","data-engineering","data-quality","duckdb","etl","python-library","redshift","snowflake","sql"],"license":"MIT","category":"data-pipelines","readme_excerpt":"SQL Testing Library A powerful Python framework for unit testing SQL queries with mock data injection Test SQL queries across BigQuery, Snowflake, Redshift, Athena, Trino, DuckDB, and ClickHouse with type-safe mock data, pytest integration, and automatic table resolution. Perfect for data engineering, ETL pipeline testing, and analytics validation. Quick Links: Installation Quick Start Documentation Examples PyPI Package 🎯 Motivation SQL testing in data engineering can be challenging, especially when working with large datasets and complex queries across multiple database platforms. This library was born from real-world production needs at scale, addressing the pain points of: - Fragile Integration Tests : Traditional tests that depend on live data break when data changes - Slow Feedback Loops : Running tests against full datasets takes too long for CI/CD - Database Engine Upgrades : UDF semantics and SQL behavior change between database versions, causing silent production failures - Database Lock-in : Tests written for one database don't work on another - Complex Setup : Each database requires different mocking strategies and tooling For more details on our journey and the engineering challenges we solved, read the full story: \"Our Journey to Building a Scalable SQL Testing Library for Athena\" 🚀 Key Use Cases Data Engineering Teams - ETL Pipeline Testing : Validate data transformations with controlled input data - Data Quality Assurance : Test data validation rules and bus","default_branch":null,"files":null,"tree":[],"storefront":"/r/gurmeetsaran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gurmeetsaran/sqltesting/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}