Skip to main content

Data Query dashboard

Zuora

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 seven 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.

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.

  • Accepted: queries that are accepted by the query service, or cancelled by the user.
  • Success: queries that are processed successfully by the query service.
  • Failed: queries that are unable to be processed by the query service.
  • In Progress: queries that are being processed by the query service.
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 System Health section in the left navigation. 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 seven days and the change percentage compared to the previous interval.

After you open a tab in the dashboard, take the following steps to view the data:

  1. 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.
  2. 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.
  3. 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 download.png to download the table as a CSV file.
    • Click a header field to sort the data.