Turn a SQL query into a LookML view or Power BI DAX measures without translating every aggregation by hand.
Paste a SQL query or table and get a Looker LookML view or a set of Power BI DAX measures — dimensions, measures and aggregations mapped from your SQL.
Free tier: 3 generations per month · or unlock forever for $4.99
Semantic layer generated
Illustrative — one SQL query in, one target out per run: a LookML view or Power BI DAX measures.
Every card is something members actually do inside Datamata — not a vague promise.
Turn a query into a LookML view with dimensions and measures wired up for you.
Convert SQL aggregations into clean DAX measures you can paste straight into a model.
GROUP BY columns become dimensions and aggregates become measures automatically.
Generates a Looker LookML view with dimensions, measures and SQL blocks
Feature deep-dives
See it work
Turn a query into a LookML view with dimensions and measures wired up for you.
Try LookML and DAXSemantic layer generated
Illustrative — one SQL query in, one target out per run: a LookML view or Power BI DAX measures.
Go deeper
Convert SQL aggregations into clean DAX measures you can paste straight into a model.
Browse all premium toolsIn practice
GROUP BY columns become dimensions and aggregates become measures automatically.
Try LookML and DAXBuilt 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 Looker LookML view with dimensions, measures and SQL blocks
Or converts your SQL aggregations into clean, reusable Power BI DAX measures
Maps GROUP BY columns to dimensions and aggregates to measures automatically
Quick start guide
Generate in three steps — paste your SQL, pick LookML or DAX then copy the view or measures into your project.
Drop in the query or a representative SELECT over the table you are modelling.
Choose Looker LookML or Power BI DAX depending on your stack.
Take the generated view or measures and drop them into your project.
Need the underlying table first? The JSON to SQL Schema Generator turns sample data into DDL.
What's included
Generates a Looker LookML view with dimensions, measures and SQL blocks
Or converts your SQL aggregations into clean, reusable Power BI DAX measures
Maps GROUP BY columns to dimensions and aggregates to measures automatically
Free tier includes monthly generations; Pro unlocks unlimited runs
Start free, upgrade when you need more.
Pro
$9.99/moUnlimited LookML views and DAX measures from SQL
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.