Middle — Senior
Mis on veeru taseme päritolu?
sobes.tech AI
Vastus AI-lt
Column-level lineage is the tracking of the origin and transformations of data at the level of individual columns in a database or data pipeline.
This means understanding where the data in a specific column comes from, what operations (e.g., filtering, aggregation, calculations) have been performed on it, and how it relates to the original sources.
Applying column-level lineage is important for:
- Ensuring data quality and reliability.
- Simplifying audit and compliance processes.
- Assisting in debugging and analyzing the impact of changes in data.
For example, if a report contains a column "Total Income," column-level lineage will allow tracing which original tables and columns it is formed from, what calculations are applied, and how changes in the original data will affect the final result.