You can translate the question and the replies:

EXTERNAL DB DATA LINEAGE

Hi everyone, I would know if there's a way to retrieve the data lineage of views when you use an external DB for the data catalog metadata. If it is not possible, there's at least a fast and easy way to create and store a view with these informations in Denodo, in order to see it in the data catalog metadata? Thanks, Maria

1 Answer

Hi, In general, you could view the Data Lineage of a view under the Data Catalog web tool > navigate to the corresponding view > Data Lineage tab. The Data Lineage for a view can be viewed regardless of the metadata database configured in the Denodo Data Catalog (eg. Derby, External Metadata). I suggest to refer to the [**Lineage of Views**](https://community.denodo.com/docs/html/browse/latest/en/vdp/data_catalog/views/lineage_of_views) documentation for more information. Additionally, please be informed that, the metadata for the [**Data Catalog**](https://community.denodo.com/tutorials/browse/datadiscovery/5metadata) is different as compared to the VDP’s metadata. To view the Data Lineage of a view in VDP (as similar using Data Catalog), you could use the predefined stored procedure [**Column Dependencies**](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/column_dependencies) to view the Data Lineage. This stored procedure gives programmatically the same information that the Virtual Data Port admin Tool displays in the [**Data Lineage**](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_derived_views/data_lineage/data_lineage) dialog (graphically) for the derived views. Hope this helps!
Denodo Team
28-09-2023 08:08:54 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here