slug: /transforms

Transforms Overview

Transforms sit between source and sink. They are used for field mapping, filtering, SQL processing, table routing, and other mid-pipeline operations. New users do not need to read every transform first; come here after you already know what you want to read and where you want to write it.

Pick A Starting Point

GoalStart here
Understand how transforms connect datasetsTransform Common Options
Filter rows or trim fieldsFilter and Field Mapper
Use SQL-style expressionsSQL and SQL Functions
Rename or reshape fieldsField Rename and Split
Work with multiple tablesTransform Multi Table and Table Merge

Recommended Order For New Users

  1. Read the common options page first so plugin_input and plugin_output are clear.
  2. Choose the simplest transform that matches your goal before moving to SQL or multi-table orchestration.
  3. Add transforms one step at a time and keep the pipeline readable while you validate the job.