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 bebronze,silver, orgold - From
bronze: next zones can bebronze,silver, orgold - From
silver: next zones can besilverorgold - From
gold: next zone can begold
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 areraw - Destination
silver: allowed sources arerawandbronze - Destination
gold: allowed sources areraw,bronze, andsilver
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.