You can translate the question and the replies:

Data Dictionary for Denodo Derived views columns field expression

Is there a data dictionary available for listing the columns and its corresponding field expressions.
user
28-11-2022 06:47:23 -0500
code

1 Answer

Hi, There are several ways to access the metadata: To do it programmatically, you can open the VQL Shell and use the **CATALOG_VDP_METADATA_VIEWS()** or **GET_VIEW_COLUMNS()** procedure from the [Predefined Stored Procedures](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures) in the **Virtual Dataport VQL Guide**. To access it manually, you can open the derived view in the server explorer and under the “Edit > Output” tab you can see the columns under *Field name* and hover the mouse cursor over the individual field name to see the field expression. You can refer to the section [Viewing the Schema of a Derived View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/viewing_the_schema_of_a_derived_view/viewing_the_schema_of_a_derived_view) of the **Virtual Dataport Administration Guide** for more information. Hope this helps!
Denodo Team
28-11-2022 20:52:31 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here