One model, many targets

◮ Modelith compile One model. Compiled to every target it needs.

mdl — ibor

$ mdl generate

wrote 11 files to target/dbt

$ mdl export contract

wrote contract to datacontract.yaml

$ mdl emit pydantic

wrote pydantic to models.py

$ mdl export sql --dialect postgres

-- SQL DDL (postgres)

$ mdl export mermaid

erDiagram …

$ mdl export dbml

// DBML …

modelone source of truth

entities7

relationships8

contractsenforced

dbt-core

contract-enforced models

ODCS contract

datacontract.yaml

Pydantic

models.py

SQL DDL

CREATE TABLE · any dialect

Mermaid ERD

renders in GitHub

DBML

dbdiagram.io