Stop hand-writing slowly-changing-dimension logic — get a correct Type 2 MERGE or dbt snapshot in seconds.
Describe a table and get slowly-changing-dimension Type 2 logic — a MERGE statement or a dbt snapshot with effective dates, current flags and surrogate keys handled.
Free tier: 3 generations per month · or unlock forever for $4.99
Illustrative snapshot — your output reflects the table and strategy you describe.
Every card is something members actually do inside Datamata — not a vague promise.
Effective dates, current flags and surrogate keys are handled so history stays correct.
Pick a raw SQL MERGE for any warehouse or a dbt snapshot that fits your project layout.
Stop copying last project's SCD pattern and adapting it column by column every time.
Generates a MERGE/UPSERT for SCD Type 2 or a ready-to-run dbt snapshot — your choice
Built 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.
Generates a MERGE/UPSERT for SCD Type 2 or a ready-to-run dbt snapshot — your choice
Handles effective_from, effective_to, is_current flags and surrogate keys correctly
Dialect-aware for Postgres, Snowflake, BigQuery and Databricks
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited SCD2 SQL and dbt snapshot generation across dialects
All 46 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
In action
Effective dates, current flags and surrogate keys are handled so history stays correct.
Try SCD Type 2Go deeper
Pick a raw SQL MERGE for any warehouse or a dbt snapshot that fits your project layout.
Browse all premium toolsSalary, 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.