You can translate the question and the replies:

Find Field References

Hi , is there a way to find if base view column is being used in any other view?i want to find list of views that are using a column from base view. i know COLUMN_DEPENDENCIES() gives track back report of the field but i need something that can give me track forward report.so instead of where the field is coming from i need to know where it is going. thanks
user
03-05-2023 18:49:40 -0400
code

6 Answers

Greetings, Hope you are doing well. You could make use of the stored procedure [CATALOG_VDP_METADATA_VIEWS](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_vdp_metadata_views) and filter by input_database_name and column_name. Resulted records will show the list of all views in the selected database and other output information such as type of the view( 0: base view or 1: derived view) , type of column, description, length, precision in case of numbers, etc… Example: ``` SELECT * FROM CATALOG_VDP_METADATA_VIEWS() where input_database_name ='denodo_training' and column_name = 'productid'; ``` Take note that results can be exported as a Delimited file using the Save as option in VQL shell. Hope this helps !
Denodo Team
04-05-2023 08:50:18 -0400
code
thanks for the answer. it works fine when that field is directly mapped in another view however it doesn't work if the field is used in an expression(calculation). i have one field in derived view which is using base view field in calculation to derive a different field .so it is being referenced in another field as it is part of the calculation but this above function(CATALOG_VDP_METADATA_VIEWS()) is not capturing that view . example Base View : BV(col1,col2,col3) Derived View: DV(col4,col5,col6) . Expression for col6=case when col3 is null then 'N' else 'Y' expectation : when searching col3 reference it should show DV; thanks
user
04-05-2023 12:42:06 -0400
also i noticed if referred field is named differently in derived view it doesn't capture that either example Base View : BV(col1,col2,col3) Derived View: DV(col4,col5,col6) . Expression for col6= BV.col3 expectation : when searching col3 reference it should show DV;
user
04-05-2023 13:14:39 -0400
Hi, Above mentioned procedure can be tailored using different filtering options. For instance, the LIKE operator can be used instead of equal. Adding other conditions to search for aliases can be used as well. More importantly, using unified naming conventions, descriptions of your fields as well as assigning tags to your columns can be implemented to leverage the search catalog mechanism used by Denodo as well as the Data Catalog component. Please refer to the following , for more information: [Metadata Search in Data Catalog](https://community.denodo.com/docs/html/browse/latest/en/vdp/data_catalog/search/metadata_search/metadata_search#dc-metadata-search) [Creating and Managing Tags](https://community.denodo.com/tutorials/browse/securitypolicy/1assigningtags#:~:text=To%20create%20a%20tag%20click,and%20its%20description%20as%20shown) [Lineage of Views](https://community.denodo.com/docs/html/browse/latest/en/vdp/data_catalog/views/lineage_of_views#dc-views-lineage) Hope this helps !
Denodo Team
08-05-2023 03:55:37 -0400
code
so what i am getting from your respose is "Denodo Currently doesn't have any feature that gives us the lineage which shows where the object is being used(track forward).current Lineage feature gives us track back report but we are missing track forward" . please confirm if this is correct . thanks
user
08-05-2023 15:59:15 -0400
Hi, [Data linage](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/data_lineage) is among Denodo features that generate interactive graphical output of information about elements in the DV platform. More specifically, it displays information about data sources , views , operations used to build the current view. It also displays the source where the information of each field comes from. If you are focusing on graphical features, then in this case, other features could be relevant to your inquiry such as the [Used By](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/viewing_the_schema_of_a_base_view/viewing_the_schema_of_a_base_view#used-by) feature which displays information about views that make use of the current view (or track forward as you have described). Since your ultimate objective is to search about specific columns, above mentioned techniques (i.e. stored procedures referenced) can be tailored to optimize such process. I would stress on using the Data catalog search and data management capabilities (e.g., using tags and categories), since this would definitely improve your search process. If you have a valid support account, I recommend opening a support ticket for further assistance and information. Hope this helps!
Denodo Team
14-05-2023 04:44:23 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here