What breaks if I change this column?
Read our technical deep-dive into how Recce constructs column-level lineage from #dbt models
- How we track column origins and transformations using SQLGlot
- How we classify columns as pass-through, renamed, derived, or source
- How we handle tricky edge cases like SELECT *, name collisions, and macro expansion
Read more:
https://datarecce.io/blog/column-level-lineage-internals/
#SQLGlot is a #Python #SQL #parser and transpiler.
SQLGlot is a parser as well as translator for various SQL dialects. SQLGlot offers multiple ways of parsing and dealing with SQL, including high level translation and low-level tokenizing and tree constructing interfaces. SQLGlot is the fastest pure-Python SQL parser, with performance comparable to Python bindings of sqlparser-rs for large queries.
Website 🔗️: https://github.com/tobymao/sqlglot
