Qlik Sense SaaS - Automatic data lineage
Using various data when creating reports in Qlik from many sources may make you feel uncertain about their origin. Fortunately, Dataedo can help you by visualizing their flow process by Data Lineage functionality.
What to expect
Analytic Apps (Reports)
Dataedo imports metadata about Analytic Apps, analyzes them, and builds column-level lineage from them to App Tables that have been created in a given Qlik app.
App Tables (Dataset Tables)
Dataedo analyzes the metadata associated with App Tables, allowing users to trace the origins and locations of their data. There are two possible options for data lineage.
Data flows from Dataset located in the Qlik catalog:
The data exists in an External source that is connected to Qlik, for example, in a Table located in a PostgreSQL database:
In Dataedo Portal, users can view which Analytic Apps reference a given table.
Everything everywhere all at once
Going one step higher, users can browse data lineage from the database level. All data flows from a single object (report, dataset table) can be traced by clicking on it.
Known limitations
- Column-level lineage between some computed measures and columns they use may not be created.
Troubleshooting
I don't see data lineage from External source database
-
Make sure the source object has a Linked Source with a correctly assigned database. If you don't see any Linked Sources, check if you belong to the Shared Space to which the given app is added and have the Can edit role, which is required to view the app script by Dataedo where metadata regarding external connections is located:
You can also assign Linked Sources by hand.
-
Rerun the import of the source - maybe the schema was imported in an older version or the configuration was incorrect.
