Exploring the features of Data Catalog:

We’ll now look at the features in the Data Catalog that allow for more in-depth interrogation of a view. This includes the following:

• Filtering and querying results from a view
• Results are being saved to a file.
• Developing new fields
• Queries saved
• Investigating viewpoint relationships
• Investigating data ancestry
• Views with related fields can be queried

Exploration of Data Catalog Views:

We chose our client view from the previous section. We can now look through the contents of this view.

Summary Tab:

We could see a summary of the selected view under the Summary Tab. It will display the metadata of the selected view, such as the database name, the list of categories, the list of tags, and collaboration information provided by the user, such as Endorsement and Warnings. You can edit the view’s description by clicking the Edit button next to the Description option. If the view is deprecated, an indication will appear at the top of the summary tab.

Furthermore, the Summary tab includes buttons such as Add Tags/Categories , Collaborative effort possibilities further to create custom the view, and Connection URLs, Tableau to display different opportunities to link to the view/datasource.

Schema tab:

Under the Schema Tab, we can see the view’s schema, which includes the view description as well as all of the fields and types. We can add a field description by clicking the Edit button next to the column. We can also use the search option at the top of each section to look for fields, data types, and descriptions.

Query Tab:

The Query Tab is the following tab. Ad-hoc queries can be run against the view here (the query is created graphically).

Subscribe to our YouTube channel to get new updates..!

Select all of the following fields for our view and drag them into the Output columns area.

client_id

name

surname

Client_type

Click on the execute to get the results.

Editing of data catalog metadata:

In this segment, we would then look at the metadata characteristics of the Data Catalog. Users could use Denodo Data Catalog to append tags and categories to views, and also keep updating the view as well as field descriptions, with such a function.

In our instance, we will: (1) add explanations to the customer fields in addition to allowing for more particular discovery of such a view, (2) add tags and categories, and (3) implement those to our client view.

Data catalog Metadata:

The capacity to exhibit view metadata, such as the View Description and Field Descriptions, is a good feature of the Data Catalog. Then see how we can make that data more modifiable.

Editing view and field descriptions:

• Browse to the Client View’s Summary page and click the Edit option beside Description.
• Add the necessary descriptions to the View and then click Ok.
• Similarly, you can add a description to fields by going to the Schema tab and clicking on the Edit button next to each one.
• The new descriptions are now visible in the view. These descriptions are saved as metadata in the Data Catalog.

Adding of tags and categories in data catalog metadata:

Tags and Categories are useful for allowing users to search the Data Catalog more precisely. While the number of Data Sources and Views in our tutorial is small, maintaining good Categorization and Tagging habits will pay off in the long run by allowing users to navigate the Data Catalog more easily.

In order to add categories follow the below mentioned points.

• Navigate to Administration > Configuration and Management.
• Click the Categories option in the Administration window’s Catalog Management section.
• Select the + Add Category option.
• Make a category with the following information:
  • Customer’s name
  • Customer data sources
• Make a new category with the following information:
  • CRM (Customer Relationship Management)
  • Customer is the parent of the Acme crm System.
• Make a final category with the following information:
  • Name: Billing 
  • Description: Billing
  • Parent:customer

Adding tags:

• Navigate to Administration > Configuration and Management.
• Click the Tags option in the Administration window’s Catalog Management section.
• Click the + Add Tag icon to add a new Tag with the following information:
  • Name:JDBC 
  • Description: JDBC data sources
• Creating another tag with the following data.
  • Name:SOAP
  • Description:SOAP data sources

We can easily modify the views for adding tags and categories as well.

                            Get ahead in your career with our Denodo Tutorial!

Recommendation and collaboration in data catalog:

Recommendations in data catalog:

The AI Feature Package includes Automatic recommendation of datasets in the Data Catalog to assist you in discovering new elements among your company’s data resources.

This feature displays individualized recommendations based on earlier activity in the Data Catalog, like datasets which are most utilised, lately used, suggested, and so on.

Go to the Data Catalog’s homepage to see the recommendations.

The homepage displays a collection of products provided by various topics, such as one titled Recommended to you. This dataset recommendation is really only accessible only with the AI Feature Pack.

Collaboration in data catalog:

In the collaboration there are 3 options such as endorsements, warnings and decrepation notes.

Endorsements seem to be comments made by users on a view or a webservice to express their support. A user can only endorse a perspective or web service once, which means whenever a new comment is added, the prior endorsement is removed.

Warnings have been used by customers to write and exhibit “advise against” texts on opinions and web services. A consumer could only add one warning to a view as well as web service.

Deprecations have been used to notify people that a feature has become outdated and should no longer be used. A consumer could only write one deprecation for a perspective as well as web application.

Conclusion:

In the above blog post we had clearly discussed the dendo data catalog, data catalog metadata, adding of tags and categories, recommendations, collaboration etc in a more detailed way. If you have any doubts please drop your query in the comments section to get them clarified.

Other Related Articles: