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
SCD Type 2 merge for dim_customer
Illustrative — generated from your dimension table columns and chosen dialect.
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
Feature deep-dives
See it work
Effective dates, current flags and surrogate keys are handled so history stays correct.
Try SCD Type 2SCD Type 2 merge for dim_customer
Illustrative — generated from your dimension table columns and chosen dialect.
Go deeper
Pick a raw SQL MERGE for any warehouse or a dbt snapshot that fits your project layout.
Browse all premium toolsIn practice
Stop copying last project's SCD pattern and adapting it column by column every time.
Try SCD Type 2Built 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
Quick start guide
Generate SCD2 logic in three steps — describe the table, pick MERGE or dbt snapshot then review the generated keys and flags.
List the natural key and the columns whose changes you want to track over time.
Pick a SQL MERGE for your warehouse or a dbt snapshot block for your project.
Check the surrogate key, effective dates and current flag before you run it.
Modelling the wider warehouse? The Star Schema Designer lays out the facts and dimensions around it.
What's included
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
Free tier includes monthly generations; Pro unlocks unlimited runs
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited SCD2 SQL and dbt snapshot generation across dialects
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.