The OneData Playbook

A practical guide to running the agents on Snowflake Cortex Code — from installing the tooling, to producing a governed, reviewed, production-ready pipeline. OneData isn't a one-shot prompt; it's a staged delivery system with approval gates at every step.

What OneData actually is

OneData turns business rules and technical metadata into a governed data pipeline — mappings, Snowflake code, dbt assets, and validation scorecards — running as a team of specialist agents inside Snowflake Cortex Code. The difference from a plain "write me some SQL" prompt is control: every phase produces a reviewable artifact, and nothing advances without a human sign-off.

👥

You provide the inputs. OneData produces the outputs. Drop your business requirements and metadata into the project's input/ folder; the agents create and update everything under output/ — with approval gates and validation along the way.

6
Pipeline phases
4
Engagement scenarios
10
Scoring dimensions
0
Steps run against prod

Set up, run, and govern

Work through them in order the first time, then use them as reference

The six phases

Each phase is owned by a specialist agent — click through to see any of them in detail

  1. Requirements Generation AgentRaw inputs become clear business requirements, KPIs, and key questions. View agent →
  2. Design AgentRequirements become the blueprint — data layers, tables, and relationships. View agent →
  3. STTM Generation AgentField-by-field source-to-target mappings, delivered as a review-ready sheet. View agent →
  4. Code Generation AgentApproved mappings become production-ready Snowflake code, in the right order. View agent →
  5. dbt Pipeline Generator AgentA ready-to-run dbt project with reusable logic, marts, and quality tests. View agent →
  6. Incremental Updates/Enhancements AgentLater changes update only what's affected — no full rebuild. View agent →

Ready to run it?

Start with setup and installation, or talk to the team about a guided walkthrough on your own environment.