Skip to main content

Varicent ELT Help Center

Performance diagnostics

Abstract

Use the Performance mode tool to review and optimize how your pipe is performing.

The Performance mode tool identifies which tools within a pipe consume the most processing time when building. Users who manage complex data models often face challenges related to pipeline performance and require tools to diagnose and enhance these processes. Use the Performance mode tool within your pipe to review and optimize your pipe performance. Performance mode gives you a comprehensive view of the overall build time with the option to drill down to the specific tool that demands the longest processing time.

For example, you have built your pipe , and it's taking a long time to complete. You want to know which tool is taking the longest time to process, so you can review and update your pipe to perform faster.

When you access your pipe with at least one Export tool available, and go to the Performance mode tool, where you can compare current and previous builds. The current build time for each tool is visible. You can toggle to view the last build, and see the build time and status of the previous build, along with the time each tool took within that build.

You can also download the performance diagnostics into a CSV file. When reviewing a build in the Performance mode tool, you can export the displayed data by clicking the Export button, downloading the CSV of the current view.