Skip to main content

Pipeline Creation agent

The Pipeline Creation agent (the Develop / Build agent) turns a request into dbt models. You describe what you want; the agent writes the SQL and schema YAML on a dedicated branch, validates it, and opens a pull request. This is the agent behind Studio.

Input​

  • A natural-language requirement - e.g. "Add a stg_orders staging model from the raw orders source, one row per order."
  • Existing SQL or logic you want turned into a model.
  • The environment (repository + warehouse target) to work in.

Output​

  • New or modified dbt models - SQL plus schema YAML (descriptions, tests).
  • A validation report and a cost estimate.
  • A pull request on a dedicated branch.

How it works​

The agent reads your existing models and columns so new work matches your project's conventions, and it streams its reasoning and changes live as it works.

Human review​

Nothing merges automatically. You review the generated SQL, the diffs, and the validation report, iterate if needed, and merge the pull request yourself. See the Production safety model.