Data Query dashboard
Zuora System Health dashboard for Data Query (Data Query dashboard) collects and displays data about usage, failures, and performance of the Data Query service in near real time. It enables you to view all the submitted queries within the last 30 days in your Zuora tenant. You can leverage this dashboard to identify and troubleshoot query issues.
For more information about the System Health feature, see Zuora System Health.
Prerequisites
For more information, see Zuora System Health prerequisites.
Access the Data Query dashboard
To access the Data Query dashboard, navigate to Administration > System Health > Data Query in the left navigation menu.
Data Query metrics
The following table provides descriptions of the Data Query metrics:
| Metric | Description |
|---|---|
| Data Query Usage |
The number of submitted queries within a specified time range, including accepted, completed, failed, and in-progress queries. When hovering over each time interval bar, you can view the breakdown data of that time range.
|
| Data Query Failures |
The number and detailed information of failed queries within a specified time range. When hovering over each time interval bar, you can view the breakdown data of that time range. |
| Data Query Performance |
The execution time and detailed information of submitted queries within a specified time range. When hovering over each time interval bar, you can view the breakdown data of that time range. |
View data in the Data Query dashboard
The Data Query dashboard is located under the Administration > System Health section in the left navigation menu. The dashboard contains a Data Summary section and three tabs that display the usage, failure, and performance data related to Data Query separately.
The Data Summary section provides an overview of the Data Query data within the last 30 days and the change percentage compared to the previous interval.
After you open a tab in the dashboard, perform the following to view the data:
Configure filters
You can customize the data to be displayed by using the filters.
- In the upper right of the dashboard, click the Filters icon.
- Use the Timeframe, Start Time, and End Time fields to specify the time range.
- Use the Status field to specify the query status.
- Use the Query ID field to filter a specific query.
This field is available only on the Overview and Failures tabs. - Use the Error Type and Error Code fields to specify the error information.
These fields are available only on the Failures tab. - Use the Execution Time Range field to specify the execution time.
This field is available only on the Performance tab. - Click Apply to apply the filter or click Reset to go back to the default filter configuration.
View the trend chart
- Select the time interval of the charts by using the interval radio buttons in the upper right of the chart.
Note that available interval options vary based on the length of the selected time range. - When hovering over each bar, you can view the breakdown data of that time range, which contains the change percentage compared to the previous interval.
- The data in the Data Query Usage chart is categorized by status.
- The data in the Data Query Failures chart is categorized by error code.
- The data in the Data Query Performance chart is categorized by execution time.
- Use the table below the trend chart to view detailed data within the selected time range.
- By default, the table displays all the items within the specified time range. To narrow down the scope to a specific interval, click a bar in the chart. To go back to the global time-range set in the filter, click Reset next to the specific time range displayed above the chart.
- Click the number in the status column of the Data Query Usage table to display all the items of this query status.
- Click the link in the Query column to open the corresponding Data Query page.
- Click the download icon
to download the table as a CSV file. - Click a header field to sort the data.