Stop writing dbt boilerplate by hand — generate a complete staging layer, test YAML and mart skeleton from any schema input in seconds.
Paste a schema, CSV headers, sample JSON or an existing SQL query — get production-ready dbt staging models, schema YAML with tests and an optional mart layer, dialect-aware for BigQuery, Snowflake, Postgres and DuckDB.
Free tier: 3 model generations per month · or unlock forever for $4.99
Models generated for orders
Generates stg_orders.sql, schema.yml with unique + not_null tests and an optional mart layer
Every card is something members actually do inside Datamata — not a vague promise.
Staging CTAs, source() macros, renamed PKs and typed casts — the twenty minutes you skip every new table.
unique and not_null on primary keys, column descriptions in schema.yml — not something you add later.
DDL, CSV headers, a JSON API response or an existing SELECT — the generator handles all four starting points.
Staging model with {{ source() }} macro, renamed PKs, dialect-aware type casts and a clean CTE pattern
Feature deep-dives
See it work
Staging CTAs, source() macros, renamed PKs and typed casts — the twenty minutes you skip every new table.
Try dbt ModelsModels generated for orders
Generates stg_orders.sql, schema.yml with unique + not_null tests and an optional mart layer
Go deeper
unique and not_null on primary keys, column descriptions in schema.yml — not something you add later.
Browse all premium toolsIn practice
DDL, CSV headers, a JSON API response or an existing SELECT — the generator handles all four starting points.
Try dbt ModelsBuilt for Premium outcomes
Real decisions, not generic templates. Every workflow runs on live market data so your moves are backed by what employers are asking for now.
Staging model with {{ source() }} macro, renamed PKs, dialect-aware type casts and a clean CTE pattern
schema.yml with source definition, column descriptions and not_null/unique tests wired to your PK
Optional fact or dimension mart model using {{ ref() }} pointing at the generated staging model
Quick start guide
Paste your schema once, pick a dialect and get copy-pasteable dbt files in seconds — staging model, tests YAML and optional mart layer.
Pick DDL, CSV headers, JSON or SQL — then paste what you have.
Tip: CSV headers work well when you just need to model a file load quickly.
Select your target warehouse and whether you need staging only or full-stack output.
Tip: Full scope adds a mart skeleton with {{ ref() }} — useful to commit as a starting point even if logic changes later.
Switch between the staging SQL, schema YAML and mart tabs — copy each file into your dbt project.
Tip: Review PK detection and cast decisions before committing — the generator is accurate but not a replacement for a schema review.
Pro members get unlimited generations across all dialects — useful when onboarding many new tables at once.
What's included
Staging model with {{ source() }} macro, renamed PKs, dialect-aware type casts and a clean CTE pattern
schema.yml with source definition, column descriptions and not_null/unique tests wired to your PK
Optional fact or dimension mart model using {{ ref() }} pointing at the generated staging model
Supports BigQuery, Snowflake, Postgres and DuckDB — the four dialects data teams actually use
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited generations, all dialects and full-stack output
All 47 premium tools · Cancel anytime
Get ProDatamata Premium
Full depth across tools, higher limits where they apply and a single member hub tied to the same live posting engine.
Get Pro — $9.99/moCancel anytime · No lock-in
Salary, skills, employers and the Match Engine all read the same live posting feed — so you are not comparing a benchmark from 2022 against jobs from this week.
Get started free
Open the tool in your browser — no setup, no credit card. Upgrade to Pro when you want full depth across every Datamata tool.