Codes

The data catalog codes window allows you to perform additional operations on a cataloged query. This window is accessible from the object browser's Data catalog  > Codes. The queries grid displays the two types of queries – a built-in query and a manual query. Built-in-query is not editable. 

The Codes home page will display the following information for the crawled connection or profiles. 

Note: To see the list of queries, you may first go to Administration > Crawler > Setting page. Select the checkbox for (1) Table, Views, and Column and (2) Procedure, Functions, Triggers, and View Source Code.

Query Interface

The query interface allows you to view, edit or add a new query. It is divided into five parts.

1. Query Window Editor
2. Summary 
3. Associates
4. Visual Result 
5. Lineages

It will display the code of the query in view mode of the query is the built-in query. If it is a manual query, then you have the option to edit, run and delete the query. 

Summary 

It will display the following information for a query. A description of a data object (Business Description, Technical Description). Tags and terms associated with the query. In addition to the top users, the crawled date, type, last run date, job type, popularity, Catalog toggle button, and quality index are displayed.

Results

When the cataloged query is executed, the results of the cataloged query are displayed in this window.    

Note: You can now download the results data just by clicking on the download button at the right corner bottom

Visualize Result 

Once the query result is displayed in the Results tab, the query result is displayed in the pictorial representation. 

• Visualize result is in disable mode when we use the Param button as enabled. 
• The pie chart in Visualize result tab is dependent on integer values only. When a pie chart is given with an integer value, it will display the result in the pie chart. 
• Based on the result, other charts are displayed in the Visualize Results tab. 

How to Publish the Visual

Once the Query results are viewed graphically, click publish to share and view the results in the All Reports.

1. Click the Publish button. A pop-up window allows the user to input the chart details.
2. Enter a report name.
3. Enter a report description. The report description allows users to get more detail about the chart.
4. Select the Reports group from the drop-down list.
   (If no report group is listed, create a report group using the  Administration>Security>Report group tab or reach your administrator.)
5. The Reports group is a user-defined group name where the selected report must be published. 
6. Click Publish report and Navigate to the timeline dashboard to view the published chart.
   

Associate Object 

The association tab lists all the data objects included in the displayed query. 

To Associate Object, 

1. In the associate tab, click the Associate Object to associate an object (Table/Files/Reports)
2. Select the type of object (Table/Table Column/File/File column/Report/Report Column)
3. Select a corresponding database, schema, and table (respective type of object you initially selected) 
4. Click the Save button. It will display the list of data objects associated with the query.

References

References are like pointers to a data object. Query references provide a list of objects (tables/columns/files/reports/data stories or other queries) from where this query is referenced. In this section, a user can find all the referenced data objects associated with the query.

For Example: Assume a query is written on table A and table B, which includes all the columns from table A and a few columns from table B. You can add this query as a reference object in any data stories/description tabs.

Lineage

A data lineage shows where a particular piece of data originated, where it moved, and how it was transformed over time. It enables the tracking, management, viewing, and editing of data transformations from source to destination.

You can find the existing lineage of this query in this section.

Add a Code

To add a code, 

1. The Add New Code in Nine Dots option allows you to create a new query from this page. 
2. A pop-up window allows you to select a new database, schema, and query name.      
3. Click the Save Query button to navigate to the empty query editor. 
4. You can enter the query and click the Param button. 
5. A pop-up window opens where you can provide the exact parameter for the query. Param button is enabled with a query having criteria. 
6. Enter the param value as 2     
7. Click the Save button, and the respective Parameter value as two is displayed.     

Version: A version history is maintained whenever a query is created or edited. You can use the version dropdown list to select the latest or previous query versions. It shows the Query version no, User name, and Update Date & Time

Reference for Query Sheet Permission

Copyright © 2019, OvalEdge LLC, Peachtree Corners GA USA