Data lineage is defined as a type of data life cycle. It is a detailed representation of any data over time: its origin, processes, and transformations. Although this isn’t a brand new concept, a paradigm shift is taking place…

Obtaining data lineage from a Data Warehouse, for example, was a pretty simple task. This centralized storage system allowed, “by design,” you to obtain data lineage from the data stored in the same place.

The data ecosystem has been evolving at a very rapid pace since the emergence of Big Data due to the appearance of various technologies and storage systems that complicate information systems in enterprises. It has become impossible both to keep and to impose a single centralized tool in organizations. Softwares and methods used by urbanists and IS architects of the “old world” have become less and less maintainable, making their work obsolete and illegible.

SO, HOW CAN YOU VISUALIZE AN EFFICIENT DATA LINEAGE IN A BIG DATA ENVIRONMENT?

In order to have a global vision of an enterprise’s IS data, new tools are emerging. We are talking about a data catalog. It allows for a maximum amount of metadata from all data storages to be treated via a user-friendly interface. By centralizing all of this information, it is possible to create data lineage in a Big Data environment at different levels:

  • At Datasets level. It can be a table in Oracle, a topic in Kafka or even a directory in the data lake. A data catalog highlights the processes and datasets that made it possible to create the final dataset.

However, this data lineage standard on its own does not make it possible for data users to answer all of their questions. Among others, these questions remain: what about sensitive data? What columns were created and with what processes? etc.

  • At Column level. A more granular way to approach this topic is to represent the different transformation stages of a dataset in a timeline of actions/events. By selecting a specific field, users will be able to see what columns and actions created it.