Build
The Agent IDE for Data Work
A full development environment for your dbt™, Python and Spark projects that runs in the browser. Admins set up config once that all users and their DinoAI copilot use. Engineers use any model or agent, while enterprises get governance and control to scale AI.
1+{{ config( 2+ materialized='incremental', 3+ unique_key='order_id' 4+) }} 5+ 6with orders as ( 7 select * from {{ ref('stg_orders') }} 8+ {% if is_incremental() %} 9+ where ordered_at > (select max(ordered_at) from {{ this }}) 10+ {% endif %} 11), 12 13payments as ( 14 select * from {{ ref('stg_payments') }} 15) 16 17select 18 orders.order_id, 19 orders.customer_id, 20 orders.ordered_at, 21 payments.amount as order_total, 22+ payments.amount - orders.order_cost as gross_margin, 23 payments.payment_methodTyler, 3 months ago · add payment method 24from orders 25left join payments using (order_id)
$ dbt build --select fct_orders 12:04:11 1 of 7 START sql incremental model analytics.fct_orders 12:04:14 1 of 7 OK created sql incremental model analytics.fct_orders [SUCCESS 1 in 2.91s] 12:04:16 7 of 7 PASS not_null_fct_orders_order_id [PASS in 0.84s] Done. PASS=7 WARN=0 ERROR=0 SKIP=0 TOTAL=7
Features
Everything the Code IDE gives you
Write, run, explore, and ship from one window.
Agentic editing with DinoAI
DinoAI works on files across the project, runs terminal commands like dbt to validate changes. With Full Auto mode, you can let DinoAI drive one Jira ticket at a time fully hands-off.
Column-level lineage
The Lineage tab gives the full column-level lineage, an in-built context for DinoAI copilot. Click any column on any card and trace where its value comes from and where it goes.
Full GitOps in the IDE
Git Lite is the default source control panel offering unparalleled speed to ship changes for both beginner and advanced git users. Writing commits with DinoAI is our most loved feature.
Bring context from all your tools
Attach files, folders, and terminal output with @, or pull in a Jira or Linear issue, connect GitHub, Confluence, OneDrive, and Google Drive, Docs, and Sheets. DinoAI works with the same context that you do.
DinoAI chat history
We save every DinoAI conversation so you can open any thread and continue from where you left of. Your chats are private to you and nobody else can see it.
Inlay hints and autocomplete
You get project-aware inlay hints for Python, dbt™, and Jinja blocks. Move between models, find references, and uses without navigating the folder structure.
Workflows
What you do in the Code IDE
From source data to a pull request with a git-tracked metric and KPI.
Start
Generate sources from your warehouse
Use DinoAI to create ingestion pipelines using dlt and then read warehouse metadata to create accurate source definitions for dbt™ or Python transformation.
Build
Build models for company metrics
Use DinoAI to run, build, and test new or existing data models. Run any dbt™ or Python data models. Use the standalone terminal or let DinoAI handle everything.
Check
Preview CTEs before you commit
Highlight a segment of SQL and preview just that. Read the compiled SQL and associated data. With defer, do data development with production schema.
Tidy
Lint SQL and YAML with one click
Run SQLFluff on .sql files and Prettier on .yml files with the Lint button. Set up your own rules and enforce them on every pull request with pre-commit hooks and TurboCI.
Document
Document models with DinoAI
Click Generate with DinoAI in the Catalog tab for a context-aware description or edit column details inline. We update YAML files in your repo, so you retain control.
Ship
Ship PRs directly from Git Lite
Use DinoAI to generate commit messages from your code changes, and draft your PR while following the conventions you have setup in your repo.
Join industry leaders winning with DinoAI agents
Data engineers and analysts at the most AI-native startups and enterprises use Paradime's DinoAI agents everyday to become market leaders.