Table level or Columns level lineage

Hi Kuladeep​,

Recommended: For table level lineage use Fabric Lineage view.

Fabric can provide lineage across items such as:

Source → Bronze → Silver → Gold → Semantic Model → Report

This is the easiest way to understand dependencies between tables, notebooks, semantic models, and reports.

If you need column level lineage then you need to build meta data table across your workflow, this is where things will become difficult.

 you can create this by using DAX studio but

However, DAX Studio will not give you complete lineage back through your PySpark notebooks, it will only limit up to sematic layer, for lineage back to pyspark you must create techinal meta data table in your workspace using pyspark. Something like this

Target   LayerTarget  TableTarget  Column  Source  TableSource 

If this helps, ✓ Mark as Kudos | Help Other