Skip to main content

Studio - Build agent

Studio is the primary workspace in Zingle AI. It's where you build and modify dbt models by talking to the Build agent. The agent writes SQL and schema YAML on a dedicated branch, validates it against your warehouse, shows you diffs, and opens a pull request when you're happy.

The build loop​

Starting a session​

  1. Open Studio and start a new session.
  2. Pick the environment (repository + warehouse target) to work in.
  3. Describe the change in plain language - e.g. "Add a stg_orders staging model from the raw orders source, one row per order."

The agent streams its reasoning and tool calls live. It can read your existing models and columns so new work stays consistent with your project's conventions.

Working with models​

As the agent proposes changes, Studio surfaces them as models in the session. For each model you can:

  • View and edit the generated SQL and schema YAML directly (CodeMirror editors with SQL/YAML support).
  • Inspect a diff - SQL diff, schema diff, and a data diff that compares results before and after the change.
  • Validate - run dbt compile/dbt test and see a structured report of what passed or failed, with highlighted issues.
  • Fetch data - preview the model's output against the warehouse.

Validation & cost​

Studio can produce:

  • A validation report covering compilation, tests, schema changes, and data differences.
  • A cost report estimating the warehouse cost of the change, so expensive models are caught before they merge.

Opening a pull request​

When the change looks right, Studio creates a pull request from the session's branch. You can update the PR as you iterate, and Studio tracks its status. Once the PR merges, a sync updates the catalog to reflect the new models.

Files & changes​

Beyond individual models, Studio exposes the session's workspace files and a changes view so you can see every file the agent touched - not just the models it highlighted.

Stopping and resuming​

Long-running agent turns can be stopped, and sessions can be reconnected - if you refresh, Studio reattaches to the live stream so you don't lose progress.