Categories
Choosing an operator
The Architect generally picks the right operator from your description. When you’re swapping by hand, two questions matter:- Where does this step sit? Root-only operators (
api_source,file_source,database_query) can only start a branch. Storage (table_sink) can only end one. - Is the operator fusable? Most transforms compile into a single DuckDB query when chained. Operators like
fuzzy_join,cascade_join, andcustom_coderun in isolation. This is a performance detail, not a correctness one.
Custom code
When no operator fits,custom_code lets the Architect generate Python that runs in an isolated sandbox. Prefer a catalog operator when one exists—it’s faster, deterministic, and easier to reason about.