Sqlmesh-test-tools is an automated unit-test file builder for SQLMesh projects. It simplifies the process of creating all input, output, and intermediate result datasets for complex SQLMesh pipelines.
It uses dependencies such as Faker, sqlglot, duckdb, and PyYAML to parse SQL code and generate the standard SQLMesh YAML test files. The tool extracts CTEs and corresponding data from SQL code, and then generates all intermediate results based off the provided input data.