Strata — prototype

Declarative, versioned, immutable data transformations. Compiles to SQL (DuckDB/Postgres/BigQuery/Snowflake), with column-level lineage and 3-phase contract pins.

Working title v0.1 — prototype lives in prototype/. Spec in ../spec/.

Install (dev)

cd prototype
python -m venv .venv
.venv/bin/pip install -e ".[dev]"
strata --help

Or without venv after publish:

pip install strata-lang
strata --help

uv (standalone tool, no venv)

# from PyPI (once published) — package is strata-lang, entry point stays `strata`
uv tool install strata-lang
strata --help

# from Git (before PyPI, or dev)
uv tool install git+https://github.com/Tzinny-dev/strata --from prototype
strata --help

# upgrade
uv tool upgrade strata-lang
pip install --upgrade strata-lang

Quick start

# typecheck + contracts + lineage (no DB)
strata build examples/daily_orders.strata

# emit SQL for a dialect
strata compile examples/daily_orders.strata --dialect postgres

# materialize in DuckDB (with demo fixtures)
strata run examples/daily_orders.strata --seed -o /tmp/demo.duckdb
strata test examples/daily_orders.strata --seed

See docs/getting-started.md and docs/tutorial.md for the full walkthrough (every code block was run against the CLI before writing).

Warehouses

Experimental modules

Docker

# from GHCR (after tag push v0.1.0 triggers docker.yml)
docker pull ghcr.io/tzinny-dev/strata:0.1.0
docker run --rm ghcr.io/tzinny-dev/strata:0.1.0 --help
docker run --rm -v $PWD:/work -w /work ghcr.io/tzinny-dev/strata:0.1.0 build examples/daily_orders.strata
docker run --rm -v $PWD:/work -w /work ghcr.io/tzinny-dev/strata:0.1.0 run examples/daily_orders.strata --seed -o /tmp/demo.duckdb

# local build (no docker daemon required on host for CI build via GHA)
docker build -t ghcr.io/tzinny-dev/strata:0.1.0 -f Dockerfile .

Development

.venv/bin/pytest -q
.venv/bin/pytest --cov=strata --cov-fail-under=80

Coverage gate: 80% (pyproject.toml / pytest.ini).