View a Query

To view the details and configuration properties of a Query:

  1. Select Analytics from the top navigation bar, then select Settings > Queries from the side navigation menu. The Analytics Queries screen is displayed.

  2. Optionally, search for and select the desired Query (see Search for a Query for more information on the available search options). The Query Details screen is displayed, with the Definition tab selected.

  1. The header and the tabs on this screen allow you to view various configuration details. See below for details on each of these areas.

The header area of the Query Details screen displays many of the high-level properties of this Query, including its name, description, and Execution Type.

Definition Tab

The Definition tab of the Query Details screen displays the Query code and any defined parameters.

For Hive Queries only, the platform supports a built-in conversion tool to convert the Hive syntax to the Trino syntax. See Convert Hive Query to Trino for more information.

This tab displays any Parameters defined for this Query. Parameters act like coding variables that can be used in a Query. For example, you could insert a Date parameter that references TODAY and use it multiple times in the Query. Then later, let’s say you need to change the Query to reference the current week, not just today. Instead of having to edit every place where the Query references TODAY, you can simply update the Date parameter, and the platform automatically updates all instances of the parameter, changing TODAY to THIS WEEK. See Define a Parameter for more information.

Results Tab

The Results tab of the Query Details screen displays the results of the Query the last time it was executed.

From this tab, you can refresh the Query. See Refresh a Query for more information.

Also from this tab, you can export the Query results and download them to your local PC. See Export Query Results for more information.