Denodo: Using Data Marketplace Tools

This document describes the tools available in the Denodo Data Marketplace, including data view Summary, Schema, Query, Data Preparation, Relationships, Data Lineage, and Reference Lineage.

Denodo's Data Marketplace has a set of tools that allow the users to explore data views, create and save queries, perform data preparation, and trace the data lineage of views. This document will help users navigate the tools and elements within a view. For help connecting to the Catalog, please refer to Denodo: Connect to Data Marketplace. 

In the diagram below, the left list of databases (number 1) will bring up the Summary View (number 2) when you click on the name of the view.   The Open In control (number 3) will allow you to get connection strings to open the view in Tableau or Power BI.  The question mark icon (number 4) allows you to get additional context-sensitive help. 
Select data view in Denodo Data Marketplace. Once a view is selected, its Summary page is loaded along with other tools.

Locate the sub-menu of tools. These will include Summary, Schema, Query, Data Preparation, Relationships, Data Lineage, and Reference Lineage. The tools are further explained below. 

Summary

This tool provides basic information about the view including its description and subdomain, and may contain links to additional view documentation.
Denodo Data Marketplace - Data Tools

Schema

This tool provides an inventory of the data columns, data types, and column-level descriptions.
Denodo Data Marketplace showing the view Schema

Query

This tool provides a drop-and-drag query builder to select, filter, and order data within a query, as well as allow you to save your query setup.

  1. Fields - click to select all the items you wish to bring into the other sections of the query, and then drag them to that region of the screen. 
  2. Output - Include the fields you wish as output fields in this region
  3. Filters - include the fields on which you want to filter the results
  4. Order By - include the fields and sort order (ascending / descending) you wish for the results
  5. Execute - when you are ready to view your results. 
    Denodo Data Marketplace showing the create Query tool with the first section being a list of fields, the next section being output columns, the next section being filters, and the final section indicating how the data should be sorted.

    After you click Execute, your query results will appear in a new screen. 
    If you wish to modify your query, click on the (1) DEFINITION link above the query results. 
    Denodo Data Marketplace showing the Query Results as a table with the data column names in the first row and the row values for each column in the rest of the rows.

Data Preparation 

This tool provides additional enhancements to the Query tool by allowing you to create additional columns, transformations, aggregations, and filters.
In addition to selecting fields (as with Query), you can also create new fields by selecting Add Column. 

Denodo Data Marketplace showing the Data Preparation tool which allows users to add additional columns and transformations to their query

When you create a new column, the column can have a constant values, a column value, a transformation, an expression value, or be empty.
Denodo Data Marketplace Data Preparation New Column Types, which including a Constant value, or a Column value, or a Transformation, or an Expression value, or nothing (it will be empty).

If you wish to enter a VQL expression (similar to SQL), then choose the option for "an expression value". In the example below, the new column titled "distinct_terms_per_year" contains a distinct count of the terms - which is what creates the second column in the data prep view.
Denodo Data Marketplace - Data Preparation - showing the creation of a new column of "an expression value" with the edit box showing "count(distinct term)"

Once you have added the additional columns and filters desired, click [NEXT] in the main Data Preparation panel, and then your results will be displayed. 

Denodo Data Marketplace showing the Data Preparation tool with the newly added column


At this point you can click the VQL tool to copy and paste the VQL source code, you can Export the results of your Data Preparation, or you can Save the query for later use.
Denodo Data Marketplace - Data Preparation Results showing the tools for VQL, Export, and Save

Relationships

This tool provides a diagram showing how the data view is related to other Data Views.  In this example, it shows that acad_car_term_dim has not yet been coded as being related to other views. 
Denodo Data Marketplace - showing the View Relationships tool

Data Lineage

This tool provides a diagram showing the data lineage, from the source system up until the view currently open. In this example, the current view of acad_car_term_dim traces back to a view called biv_ia_dm_acad_car_term_dim, which then traces back to a view called bv_ia_dm_acad_car_term_dim, which then traces back to the data source ds_ia.  
Denodo Data Marketplace - showing the Data Lineage tool which traces back how a view was created and the parent views that went into the creation of this view

Reference Lineage

This tool provides a diagram showing all of the data views, objects, and apps that reference this view.  
In this example, no other views or apps are based on the view acad_car_term_dim. 
Denodo Data Marketplace - showing the View Reference Lineage tool, which indicates which other data views reference the current data view.

Related Articles

Denodo: Connect to Data Marketplace

Denodo: Connect DBeaver to Denodo

Denodo: Connect Tableau Desktop to Denodo

Need More Information?

If you have questions about this document, please contact Data, Academic Planning and Institutional Research (DAPIR, https://data.wisc.edu/) at badgerdata@wisc.edu.


Keywords:
Denodo Data Marketplace tools VQL Export data-preparation InfoAccess Snowflake EAP Redshift 
Doc ID:
152773
Owned by:
James F. in Data KB
Created:
2025-06-26
Updated:
2025-11-25
Sites:
Data, Academic Planning & Institutional Research