Data Lineage

Problem

A business dashboard is displaying incorrect revenue numbers. To find the source of the bug, you need to trace the data back through all stages of processing. Write a query that outputs definition with the value: "Data lineage maps the life cycle of data, showing its origins, intermediate pipeline transformations, and final destinations for auditing and debugging."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution