Skip to main content
The Transform panel is the main record-shaping surface in the builder. Each branch owns its own script.

​
What the panel controls

  • Branch label
  • Source table
  • Load Example
  • the Python editor
  • Preview with sample data
  • Save Script

​
Required script shape

def transform(record):
    return record
Use that function to return a destination-ready record. Return None only when you intentionally want to drop the record.

​
Step by step

  1. Open the pipeline builder and select the branch transform.
  2. Rename the branch if operators need a clearer label such as Analytics Orders.
  3. Confirm the Source table or resource so preview uses the correct payload shape.
  4. Click Load Example if the current source type has a close starting point.
  5. Edit the script inside transform(record).
  6. Click Preview with sample data.
  7. Review the output columns and rows.
  8. Click Save Script.

​
Real-world example

def transform(record):
    amount_due = (record.get("amount_due") or 0) / 100

    return {
        "invoice_id": record.get("id"),
        "customer_id": record.get("customer"),
        "amount_due": amount_due,
        "currency": (record.get("currency") or "usd").upper(),
        "status": record.get("status"),
        "created": record.get("created"),
    }

​
Current implementation notes

  • Scripts are branch-specific, not global.
  • The editor is meant for record shaping, not external I/O.
  • If the script raises an error, preview and pipeline runs treat that as a failure in the current supported UI flow.