Sobes.tech
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.