๐ Pipeline Editor is live
A safer, faster way to build and ship transforms just landed.
Weโre releasing the new Pipeline Editor โ a fully sandboxed environment where you can create, edit, test and version-control transforms without touching anything in production.
Letโs dive in ๐

๐งช Build in a sandbox, ship when ready
Every change you make lives in an isolated workspace until you commit to live. Preview outputs, test logic, rebase with the latest version, and iterate without worrying about breaking downstream pipelines.
Whatโs new:
- Rebase โ sync your sandbox with the latest live version
- Sandbox Changes Summary โ reset, stash, or publish changes
- Load Version โ retrieve or delete previously stashed versions
- Safe commit flow โ only admins + users with edit permissions can publish
- Full version control โ track changes, stash drafts, manage iterations
This workflow is built for safe experimentation and predictable releases.
๐ ๏ธ How it works
Create a new transformOpen the Pipeline Editor โ create a transform โ edit SQL โ save. Everything is stored in your sandbox until you commit.
Experiment safelyPreview SQL outputs before publishing. Rebase to pull the latest live updates. Use versioning to stash or reset your work.
Publish with confidenceOnce tested and validated, commit your changes to live. Pipelines update instantly, with full version transparency.
๐ Permissions
Admins and users with edit rights can commit. View-only roles see everything but cannot publish changes. Permissions are managed in Settings โ Roles.
๐ Known limitations (for now)
We keep it transparent โ hereโs what weโre improving next:
- Transforms can still be edited from the Transforms page โ rebasing required
- Queries referencing warehouse tables outside Kleeneโs ecosystem need refactoring
- Creating a transform from a siloed table may show SQL Preview errors in edge cases
- Bug: stashing/resetting a brand-new transform before first commit may behave inconsistently
- Pipeline Viewer currently shows executions for live transforms only
- First-time sandbox load may take a moment
๐งญ Example workflows
1. Safely test changes
- Open Pipeline Editor
- Modify a transform
- Save โ preview SQL
- Rebase if needed
- Stash or commit
Result: Live pipelines stay untouched until you ship.
2. Publish a validated update
- Edit SQL
- Save to sandbox
- Preview output
- Review in Version Summary
- Commit to live
Result: A clean, verified update goes live with full version control.
๐ฏ Why this matters
Teams ship faster when they can experiment without fear. The new Pipeline Editor gives you a safer development loop and tighter control over how changes move from idea โ draft โ production.
More updates coming soon. If you want a walkthrough, your CSM can set it up anytime.