Introducing the Data Marketplace¶

The default URL for accessing the Denodo Data Marketplace from a local machine is http://localhost:9090/denodo-data-catalog. Type it in your favorite browser and you will see the login page.

Login page of the Data Marketplace¶

In the data infrastructure of your company you may have several Virtual DataPort servers, each one with a different catalog to discover. Select the Virtual DataPort server you want to connect to and sign in with your credentials. The Data Marketplace will welcome you with its new home page.

Home page of the Data Marketplace¶

From the home page of the Data Marketplace you can start discovering new data resources of your organization. Just enter a query in the search bar to find views, web services and external elements by their metadata (name, description, fields…). You can also browse your data resources by category, tag, or database/folder using the links below the search bar.

To help you discover new elements among the data resources of your company, the home page presents you with a selection of items organized by different topics:

Browse The Marketplace: This section shows the number of items of each type managed by the Data Marketplace.

Popular Assets: This section highlights frequently used and recently updated data resources.

• Most used lists the views and web services most requested by all the people in your company.

• Recently added shows you which elements are new in the catalog.

• Recently endorsed is the list of views and web services that have recently received an endorsement from someone in your company.

For You: This section personalizes recommendations based on your activity:

• Recommended by Denodo Assistant shows you a ranking of elements from the catalog that can be of your interest according to your interactions with the Data Marketplace and the Virtual DataPort. Your activity in Virtual DataPort is analyzed from the same data used to compile the usage statistics. If you have not configured the gathering of usage statistics, only your activity in the Data Marketplace will be taken into account.

• Most used by you shows the views and web services most visited or executed by you.

• Recently used by you is the list of views and web services that you have recently requested.

• Most used queries by you shows the queries that you use the most.

• Recently used queries is the list of queries that you have recently requested.

Make the most of your Data Marketplace in home page¶

Make the most of your Data Marketplace by accessing a variety of learning resources such as tutorials, courses, videos and articles from the Denodo Community, making it easier to understand and use the Data Marketplace. Just pick the resource that interests you and start learning!

The menu at the top gives you access to all the features in the Data Marketplace:

• Click and write a query to make an advanced search. You can query the data resources in your catalog by their metadata and even by their actual data.

• The Data Marketplace allows you to organize your data resources by hierarchical categories or tags. From the Browse menu you can navigate through all the elements that belongs to a specific category or tag, or inspect the catalog by the databases and folders in Virtual DataPort.

• You can execute queries on the views or web services of the catalog to retrieve specific data from them. If a query is important to you, you can save it for later. Check and share all your saved queries from the My queries option.

• If you have the proper permissions, you will see the Administration menu. From there, an administrator can configure the Data Marketplace server, define new tags or categories, synchronize the catalog with Virtual DataPort, and more.

• From the Help menu you will get direct access to reference materials about the Data Marketplace: online documentation, tutorials, training courses, videos, and more.

• Use the Profile menu to configure your locale or to close your session in the Data Marketplace.

Every time you want to go back to the home page, just click the Data Marketplace logo at the upper left corner.

Search Data Assets or Query Their Content¶

In the Data Marketplace, the Global Assisted Query feature allows users to perform natural language queries across multiple views and to query their content. Powered by AI, it automatically identifies the most relevant views and generates a VQL query based on the user’s needs.

Note

This feature is only available with the subscription bundle Enterprise Plus. To find out the bundle you have, open the About dialog of Design Studio. See more about this in the section Denodo Platform - Subscription Bundles.

Important

Prior to using this feature, you will need to configure LLM configuration API Configuration, Vector database Configuration and the Denodo Assistant Assisted Query Configuration

Enter your question a query your data assets¶

You can express your needs in natural language through the search bar. Providing more details not only refines the search results but also improves the quality of the information displayed. This applies as well to the metadata of the views. To process your query, certain data is sent to the AI model (LLM), including, among other details, the following for each relevant view considered:

1. The name of the view.

2. The name of the view’s database.

3. For each field, the following information:

   1. The name of the field.

   2. The type of the field.

   3. The description of the field.

   4. Information regarding if the field is a primary key.

   5. Information regarding if the field is nullable.

   6. If the data usage is enabled, data samples of the view are also included.

4. The description of the view.

5. The associations of the view.

Warning

• Generating a query will send metadata information to the LLM. Only if the data usage is enabled, data of the view is also going to be processed and sent to the LLM in order to improve the results. Make sure your organization is aware and agrees on this.

• Data Marketplace collects and sends the metadata of Denodo views to the LLM for processing. Only if the data usage is enabled, data of the view is also collected and sent. This metadata includes information such as view names, view descriptions, field names, field descriptions, data types, and relationships.

Note

The Natural language query accepts text to a maximum of 1000 characters.

Once the Natural language query is set, click Generate VQL query option.

In the VQL Shell, the query explanation will appear first as a comment, with the automatically generated VQL query displayed immediately below.

Generated query and explanation¶

Role and permission needed¶

To use the Global Assisted Query feature the user must have the data_catalog_assisted_query role. See the Default Roles section for more information. In addition, the user must have a role that allows executing the VQL Shell. See the VQL Shell section for more details.