Views¶

The purpose of the Data Marketplace is to discover the resources located in a Virtual DataPort by searching or browsing. One of these resources are the views. When you find a view of your interest, click its name. You will see all the available information about it, considering both the metadata retrieved from Virtual DataPort and the metadata added by other users of the Data Marketplace.

The information about a view is organized in the following pills:

• Summary. The summary pill shows the basic information of the view: database, categories, description, etc.

• Schema. In the schema pill you can find the list of view fields, with their types and descriptions.

• Query. The query pill has a wizard to help you build and launch queries on the view.

• Data preparation. The Data preparation pill allows you to build queries by manipulating live data.

• Assisted Query. The assisted query pill allows you to generate a query explaining what you need in your own language.

• Relationships. The relationships pill displays a graph where the view is linked to those views related to it. Two views are related when there is an association between them.

• Data lineage. The data lineage pill displays a diagram with the current view and all the views it depends on. You can check the path that follows the data for each field in the schema, from the data sources to the view, traversing all the intermediate views.

• Reference lineage. The reference lineage pill displays a diagram with the current view and all the reports that use it. You can check the path that follows the data from the view to the report, traversing all the intermediate elements.

• Requests. The requests pill displays the requests created on this view.

• Usage. The usage pill gives information about the queries that Virtual DataPort executed on the view.

• Data profiling. The data profiling pill describes the values you can find for each field in the view: average size, data range, number of distinct values, etc.

• Search. In the same way as the search by content, the search pill allows you to check which tuples of the view match some query terms.

In addition, an administrator of the Data Marketplace can add custom properties to the view to improve the information you have about it. According to the configuration, they will appear inside a new section of the Summary pill or in a new pill.

Options available for a view in the Actions menu¶

In the Actions menu, you will find the following operations for a view, though your available options will vary depending on your permissions:

• If the view is synchronized and the user has permissions to create requests, the corresponding options for creating requests will be displayed.

  Types of requests available for a view:

  • Access request: request type intended to request permissions to execute a view. If the view already has execution permissions this option will not be shown.

  • Change: request type intended for requesting metadata changes.

  • Data quality: request type intended for reporting a problem with the data of the view that needs to be fixed.

  • Question: request type intended for asking something about the view.

• Assign tags, categories or property groups.

• Collaborate through endorsements and warnings.

• Mark as deprecated. Remember that you can only write one deprecation about a view.

  If the view is deprecated you will see the icon next to its name, and a notification will appear every time you access the view or click the icon.

  

  The notification with the deprecation messages has a Show details button. Click it to check all deprecations or edit them if you are allowed to.¶

In the Open in menu you will find the following options for a view:

• Click Connection URLs to obtain the URLs to connect to this view through all the available APIs: JDBC, ODBC, REST, OData and GraphQL.

  

  Click the icon next to each URL to copy it to the clipboard¶

  Note

  The Connection URLs option may have been disabled by the administrator of the Data Marketplace.

• If you have privileges to execute this view, you will find third-party applications options available.

  The following third-party applications are supported:

  • Power BI: Click this option to download a data source file (with .pbids extension). Load this file in Power BI Desktop. Supported since the May 2022 release. It will establish a connection to query this view using the Denodo for Power BI connector.

  • Tableau: Click this option to download a data source file (with .tds extension). Load this file in Tableau Desktop 10.5.0 or later. It will establish a connection to query this view using the named connector for Denodo in Tableau.

  Note

  Third-party application options may have been disabled by the administrator of the Data Marketplace.