Skip to main content

Highlight Related Paths

Overview

Feature Description

The ETL editor provides a Highlight Related Paths feature. When users click a specific ETL node, the system visually highlights the upstream and downstream path of that node. This makes it easier to understand how data flows through the ETL and quickly clarify the relationships between ETL nodes, which improves efficiency when modifying ETL flows or troubleshooting issues.

Use Cases

  1. ETL Flow Changes:

    • Scenario: When users need to change an ETL flow, such as adding, modifying, or deleting a transformation step, they need to understand the impact of that change on the overall flow in advance.
    • How It Helps: Users can enable Highlight Related Paths and click the target ETL node to clearly view its downstream path and understand the impact scope of the change.

  2. Troubleshooting:

    • Scenario: When data anomalies or errors occur in the ETL process, users need to quickly identify the problematic node for investigation and resolution.
    • How It Helps: Click the ETL node related to the issue, and the directly connected upstream and downstream nodes will be highlighted, helping users quickly trace the problem path and troubleshoot more effectively.

  3. Understanding Data Flow Paths:

    • Scenario: For new team members or other stakeholders involved in ETL workflows, understanding how data moves through the process can be challenging.
    • How It Helps: During onboarding or familiarization, users can click different ETL nodes to intuitively understand how data flows through the entire process. This feature can also be used together with Canvas Comments to improve overall system understanding.

This feature is also useful for ETL performance tuning, process optimization, and similar work. In short, it improves the visibility and intuitiveness of ETL operations.

Instructions

  1. Go to the ETL Editor. In the upper-right corner, find the Highlight Related Paths option. This feature is enabled by default.
  2. After the feature is enabled, click any ETL node to highlight its upstream and downstream path.
  3. If path highlighting is no longer needed, you can disable the feature.