Combining regional order feeds

Context — North and South export the same columns separately

The task is currently manual and its assumptions are not recorded. Hydra turns it into files that can be reviewed and rerun.

Where things stand

• The current result is fragile. Its assumptions are split between tools, clicks and memory.
• Reruns are uncertain. The write mode or orchestration rule is not visible beside the data.
• Evidence is missing. A colleague cannot compare a declared rule with a concrete before and after state.

The question

How do you express this rule with Hydra’s union operation and prove exactly what it changes?

• Use one minimal input fixture
• Declare one operation per step
• Validate the DSL before running
• Compare the complete before and after states

The solution in one line

One union step between a deterministic CSV source and a replaceable CSV destination.

Steps

1. capture the before state

1. Use a minimal fixture that exposes the rule.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

north: O-1,North · O-2,North
south: O-2,North · O-3,South

2. declare the fixture

1. Read the known input.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

version: "1.0"
sources:
  input:
    type: csv
    connection:
      base_path: "data"
    extract:
      table: input.csv

3. add the union step

1. Write one operation with explicit parameters.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

version: "1.0"
steps:
  - union:
      right: south_orders
      distinct: true

4. make the result observable

1. Write a replaceable CSV.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

version: "1.0"
destinations:
  result:
    type: csv
    connection:
      base_path: "out"
    load:
      table: result.csv
      mode: replace

---
version: "1.0"
pipeline:
  from: input
  to: result

5. validate the operation

1. Ask Hydra to parse the step.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

$ hdrctl test union-workshop

ok  transformations.yaml — 1 step(s) valid
Operations: union

✅ All tests pass — ready to execute.

6. run and compare after to before

1. Inspect the exact output.
2. Compare the file with the explanation in the workbench.
3. Record the shown check before moving to the next step.

$ hdrctl run union-workshop

✅ Pipeline completed successfully

order_id,region
O-1,North
O-2,North
O-3,South

Expected result

• The after state matches the stated rule.
• One operation is counted by `hdrctl test`.
• The fixture can be rerun without accumulating rows.

Reading the results

Compare columns, row count and ordering—not just one visible value. `distinct: false` is UNION ALL; `true` removes fully duplicated rows after stacking.

What the counters do—and do not—prove

They prove how many records entered and left this run. They do not replace checking the target schema, the business meaning of values or the reason a workflow step was skipped.

The rule to carry forward

`distinct: false` is UNION ALL; `true` removes fully duplicated rows after stacking.

Did we answer the question?

Before and after

• Before — North and South export the same columns separately requires a person to remember the order, options and checks.
• After — one reviewed manifest and one command produce the same observable result.
• What is really gained — The durable gain is the contract: a colleague can read the configuration, reproduce the run and challenge the assumptions.

Close by

• sources.yaml
• transformations.yaml
• destinations.yaml
• workflow.yaml
• Tutorial — your first job
• All Guide workshops