All resources
Topics

OKF vs dbt Exposures vs LookML: How to Describe a Data Model

Three ways to describe a data model — compared on portability, lock-in, and whether an AI can read the result.

Three ways to describe a data model — compared on portability, lock-in, and whether an AI can read the result.

Every data team eventually has to write down its model – not just the tables, but what they mean and how they join. Three common ways to do that are Google's Open Knowledge Format (OKF), dbt exposures, and LookML

They're often mentioned together, but they solve overlapping-but-different problems, and they differ sharply on the thing that matters most in 2026: portability and whether a machine can read the result. 

Here's a fair comparison. New to the idea of a written model? Start with what OKF is and our guide to data modeling.

What each one actually is

  • OKF – an open, vendor-neutral format from Google for describing a data model as plain markdown: one file per table, a schema block, and a joins section. It's a description of the model itself, meant to be portable, git-friendly, and readable by both people and AI agents.
  • dbt exposures – a way, inside a dbt project, to declare the downstream uses of your dbt models (a dashboard, an ML job) so lineage and ownership are explicit. It documents how models are consumed; it lives in your dbt project as YAML.
  • LookML – Looker's language for a semantic model: dimensions, measures, and joins that power consistent metrics across Looker. It's rich and battle-tested – and it lives inside Looker.

Side by side

OKF dbt exposures LookML
Describes The model (tables, columns, joins) Downstream uses of dbt models A semantic layer (metrics, joins)
Format Open markdown YAML in a dbt project LookML in Looker
Portable / tool-agnostic Yes Tied to dbt Tied to Looker
Lives in git Yes Yes (with dbt) Partially
AI-readable Yes (that's a design goal) Somewhat Only via Looker
Lock-in None (open standard) dbt ecosystem Looker ecosystem
Best at A portable, shareable model Lineage & ownership in dbt Governed metrics in Looker

Where dbt exposures fit

If your transformation layer is dbt, exposures are the natural, correct way to close the loop between models and their consumers. They make lineage explicit and help ownership and impact analysis. What they're not is a full, standalone description of your data model that lives independently of dbt – they describe usage within the dbt graph. If dbt is your center of gravity, exposures are the right tool for what they do. For how the design underneath connects, see dimensional data modeling.

Where LookML fits

LookML is excellent at what it's for: a governed semantic layer so every Looker report answers consistently. If Looker is your BI platform, LookML is powerful and worth mastering. The trade-off is portability – the model is expressed in Looker's language and realized inside Looker, so handing it to another tool, or to an external AI agent, isn't straightforward. Great in-ecosystem; limited when you want the model to travel.

Where OKF fits

OKF occupies the space the other two leave open: a portable, open description of the model itself, independent of any transformation tool or BI vendor. 

Because it's plain markdown, it versions in git, reviews in a pull request, and – crucially – reads cleanly as context for an LLM, so text-to-SQL and data agents stop guessing your schema. 

It doesn't replace dbt or Looker; it's the tool-agnostic layer you can keep alongside them and move between stacks. 

You can author it visually and export it from OWOX Model Canvas, which also opens Google's official GA4, Stack Overflow, and Bitcoin samples.

OWOX Model Canvas – an e-commerce data model on the canvas, exportable as OKF

Author the model visually, then export OKF – an open, git-friendly, AI-readable description you can move between tools.

The 2026 tiebreaker: can an AI read it?

For years the choice between these was about your existing stack – dbt shop, Looker shop, or neither. There's now a tiebreaker that cuts across all of them: which of these can an AI agent consume directly? 

Text-to-SQL and "chat with your data" tools fail when they lack a trustworthy, machine-readable model – they invent columns and pick wrong joins. LookML can't leave Looker; dbt exposures describe usage, not the full model; OKF was designed from the start to be a portable, agent-readable description. 

If part of your roadmap is letting an LLM answer questions against your data with zero hallucination, an open format like OKF is the one that ships that context anywhere. This is also why teams pair the model with a governed layer like OWOX Data Marts so dashboards, spreadsheets, and AI all read one definition.

Which should you use?

  • You're a dbt shop and need lineage/ownership → dbt exposures (and keep OKF for a portable model on top).
  • You're a Looker shop standardizing metrics → LookML.
  • You want a portable, open, AI-readable model that isn't locked to one tool → OKF.
  • Most modern stacks → a mix: transform in dbt, serve metrics where you serve them, and keep the model itself in an open format so it travels. Compare the broader toolset in best data modeling tools.
FAQ

Frequently asked questions

What is the difference between OKF and dbt exposures?
+
Is OKF a replacement for LookML?
+
Which is best for AI / LLM context?
+
Can I use OKF with dbt or Looker?
+
Do I need to write OKF by hand?
+
Is OKF tied to Google or any vendor?
+
On this page
What users are saying

Not testimonials. Comment threads.

From people who actually use the product. Each quote is attached to a specific claim.

A1
· re: warehouse integration
KP
Katya P.
BI Manager

Finally, a tool that doesn't ask business users to learn a new dashboarding UI. Our marketing team already knows Sheets. OWOX just delivers the right data.

C3
· re: governance
MR
Marco R.
Head of Data

Joinable data marts concept was the thing that sold us. We can now use the semantic layer without building one.

E7
· re: open source
JC
James C.
Data Analyst

Self-hosted the OSS version on Digital Ocean. Zero vendor lock-in. Contributed a Shopify connector back in week two.

Google Sheets in modern analytics

Google Sheets, powered by governed data marts

Google Sheets were never designed to be a system of record. With OWOX Data Marts, Sheets becomes a trusted analysis layer — powered by governed data marts defined upstream in your warehouse.

Business teams keep the flexibility they love
Data teams retain control over logic and definitions
No more fragile joins duplicated across spreadsheets
See how it works
/* Full Width Images in RichText */