ODA User Guide

Data Destinations

Learn how data destinations work in Optra Data Studio, including zone rules, destination configuration, and lineage tracking.

Data destinations are the zone nodes that receive transformation output in a project. They define where transformed data is written and how it progresses through the Medallion layers.

How Destinations Are Defined

Add a transformation from a zone, then select a valid downstream zone as its destination. A transformation can combine multiple source zones and may produce output for more than one destination, such as when working with semantic layers.

Zone-to-Zone Destination Rules

The zone add flow enforces destination progression like this:

  • From raw: next zones can be bronze, silver, or gold
  • From bronze: next zones can be bronze, silver, or gold
  • From silver: next zones can be silver or gold
  • From gold: next zone can be gold

So, same-zone refinement is supported (bronze -> bronze, silver -> silver, gold -> gold) in addition to forward progression.

Source Eligibility by Destination

Available upstream sources depend on the destination zone:

  • Destination bronze: allowed sources are raw
  • Destination silver: allowed sources are raw and bronze
  • Destination gold: allowed sources are raw, bronze, and silver

Data Studio offers only the sources supported for the selected destination.

Destination and Lineage Metadata

The project canvas visualizes how data moves from source zones through transformations to destination zones, helping users understand pipeline lineage and available upstream or downstream connections.