Show HN: A dbt-first semantic assumption check for SQL changes

Category: devtools

Tags: dbt, sql, ci-cd

Score: 5.8/10 (Innovation: 6, Technical: 6, Documentation: 6, Utility: 5)

SemZero is a Python CLI tool that performs semantic assumption checks on SQL changes in dbt projects, detecting risks like enum domain changes or schema breaks via git diff analysis. It is interesting because it fills a niche gap for data engineers by providing automated PR review for dbt model changes without requiring warehouse access, using both compiled and static SQL fallback.

Target audience: data engineers

Repository: https://github.com/hiteshsundraaa/semzero-public-alpha-launch · Python · MIT · 1 stars

View on Hacker News