Skip to main content

Data Source Export dashboard

Zuora

Data Source Export dashboard

  1. Last updated
  2. Save as PDF

Zuora System Health dashboard for Data Source Export (Data Source Export dashboard) collects and displays data about usage, failures, performance, processing jobs, and top executed queries of the Data Source Exports (DSE) service in near real time. It enables you to view all the DSE query jobs in your Zuora tenant within the last 30 days. 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 Source Export dashboard

To access the Data Source Export dashboard, navigate to Administration > System Health > Data Source Export in the left navigation menu.

Data Source Export metrics

The following table provides descriptions of the Data Source Export metrics:

Metric Description
DSE Usage The number and detailed information of processed DSE query jobs within a specified time range, including jobs with the following status types:
  • Completed: query jobs that are processed successfully.
  • Failed: query jobs that are unable to be processed.
When hovering over each time interval bar, you can view the breakdown data of that time range.
The table below the chart presents the following metrics for each query job:
  • Job ID: the ID of this query job.
  • Job Status: the status of this query job, such as Completed or Failed.
  • Query: the query expression this query job uses to export data.
  • Record Counts: the number of records in the query result of this query job.
  • Execution Time: the execution time of this query job.
DSE Failures The number and detailed information of failed DSE query jobs within a specified time range.
When hovering over each time interval bar, you can view the breakdown data of that time range.
The table below the chart presents the following metrics for each failed query job:
  • Job ID: the ID of this query job.
  • Job Status: the status of this query job.
  • Error Message: the error message that describes the reason for failure.
DSE Performance The execution time and detailed information of processed DSE query jobs within a specified time range.
When hovering over each time interval bar, you can view the breakdown data of that time range.
The table below the chart presents the following metrics for each query job:
  • Job ID: the ID of this query job.
  • Job Status: the status of this query job, such as Completed or Failed.
  • Query: the query expression this query job uses to export data.
  • Record Counts: the number of records in the query result of this query job.
  • Execution Time: the execution time of this query job.
Processing Jobs The detailed information of DSE query jobs that are pending or being processed:
  • Pending: query jobs that are submitted successfully and not being processed yet.
  • Processing: query jobs that are being processed.
The table presents the following metrics for each query job:
  • Job ID: the ID of this query job.
  • Job Status: the status of this query job, such as Pending or Processing.
  • Query: the query expression this query job uses to export data.
  • Record Counts: the number of records that have been exported.
Top Executed Queries The detailed information of the top ten executed queries within a specified time range.
The table presents the following metrics for each query:
  • Execution Count: the number of executions of this query.
  • Percentage: the percentage of execution count of this query compared to the total number of queries executed.
  • Query: the query expression that is used by query jobs to export data.

View data in the Data Source Export dashboard

The Data Source Export dashboard is located under the Administration > System Health section in the left navigation menu. The dashboard contains a Data Summary section and five tabs that display the usage, failures, performance, processing jobs, and top executed queries data separately.

The Data Summary section provides an overview of the DSE query data within the last seven 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.
    These fields are available only on the Overview, Failures, Performance and Top Executed Queries tabs.
  • Use the Job Status field to specify the query job status.
    This field is available only on the Overview, Performance, and Processing Jobs tabs.
  • Use the Job ID field to filter a specific query job.
    This field is available only on the Overview, Failures, and Processing Jobs tabs.
  • Use the Execution Time Range field to specify the execution time.
    This field is available only on the Performance tab.
  • Use the Query field to specify the query expression.
    This field is available only on the Top Executed Queries 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.
  • Each bar in the chart represents query jobs issued in that time interval. The bar might be divided into multiple colored segments based on a subcategory that varies depending on the tab. The subcategory values can be seen at the bottom of the chart. You can click the subcategory values to filter query jobs as needed.
    The following table describes details of the trend chart on different tabs:
    Tab name Value in each bar Subcategory Available subcategory values
    Overview Processed DSE query jobs Job status
    • Completed
    • Failed
    Failures Failed DSE query jobs Job status Failed is the only available value.
    Performance Processed DSE query jobs Execution time range
    • < 10 mins
    • 10 - 30 mins
    • 30 - 60 mins
    • 60 - 180 mins
    • >= 180 mins
  • 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 Processing Jobs and Top Executed Queries tabs do not provide a trend chart.
  • 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 Execution Count column of the table on the Top Executed Queries tab to view all query jobs based on a specific query expression.
    • Click the download icon download.png to download the table as a CSV file.
    • Click a header field to sort the data.