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
| Warehouse | SQL emit (compile --dialect) |
Engine run (run -o / exec) |
Driver |
|---|---|---|---|
| DuckDB | ✅ | ✅ DuckDBWarehouse + dbcompat (duckdb default dep) |
duckdb |
| Postgres | ✅ | ✅ cli.open_warehouse("postgres://...") → dbcompat.PGConn (probado vs Postgres 16 efímero) — adapters.get_adapter("postgres") sigue stub E095 a propósito |
pip install strata[postgres] |
| BigQuery | ✅ | ❌ stub E095 | pip install strata[bigquery] |
| Snowflake | ✅ | ❌ stub E095 | pip install strata[snowflake] |
Experimental modules
| Module | Status | Notes |
|---|---|---|
strata.integrations |
scaffolding only | airflow_dag_factory/prefect_flow_factory return strings of Python source; airflow/prefect not installed by default (pip install strata[airflow] / [prefect]). No real DAG/flow is instantiated — see plan-hito-2.md §B. |
strata.testing |
fixture helpers only | create_test_source/FreshnessTestHelper emit .strata text or temp tables; not wired to the executor for e2e. Use strata.exec for real freshness gates. |
strata.observability |
connected | MetricsCollector is imported by strata.exec._run_locked and exposed via get_metrics(); exporters are formatters (Prometheus/StatsD/JSON) without external deps. |
Standalone binary
# curl | bash (detects OS/arch, pulls from GH Releases)
curl -fsSL https://raw.githubusercontent.com/Tzinny-dev/strata/main/install.sh | bash
strata --help
# or pin version / custom dir
curl -fsSL .../install.sh | bash -s -- --version 0.1.1 --to /usr/local/bin
# Homebrew (tap — formula in homebrew/strata-lang.rb, sha256 replaced on release)
brew tap Tzinny-dev/strata # or: brew tap Tzinny-dev/homebrew-strata if split
brew install strata-lang
strata --help
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).
1 maintainer
Release files for strata-lang 0.1.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| strata_lang-0.1.2.tar.gz | 220.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| strata_lang-0.1.2-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 374.1 kB
Release files / strata_lang-0.1.2.tar.gz
| Download URL | strata_lang-0.1.2.tar.gz |
|---|---|
| Size | 220.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f835f832816b73666ed8df67ddb655738279f3f7e8e0e803e0b0aac2dfad68fe
|
|
BLAKE2b-256 checksum How to use checksums |
cabf3633d4b62887cde61d4bbe305cc7fb062317453e2c2b16486af9255af807
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 23, 2026.
Transparency logRelease files / strata_lang-0.1.2-py3-none-any.whl
| Download URL | strata_lang-0.1.2-py3-none-any.whl |
|---|---|
| Size | 153.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
1d586b5a2a6777fd1d99711ab6902fb668b3766c40152d8f36c09627e7f19609
|
|
BLAKE2b-256 checksum How to use checksums |
c8a9f9843cfc22553a60b1808d28bbeea2630bca961fcce9d39de2d2cee59235
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 23, 2026.
Transparency log
