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 (tested against ephemeral Postgres 16) — adapters.get_adapter("postgres") remains stub E095 intentionally |
pip install strata[postgres] |
| BigQuery | ✅ | ✅ BigQueryWarehouse → dbcompat.BigQueryConn (bigquery://project/dataset?location=US) + get_adapter("bigquery") |
pip install strata[bigquery] |
| Snowflake | ✅ | ✅ SnowflakeWarehouse → dbcompat.SnowflakeConn (snowflake://user:pass@account/db/schema?warehouse=WH&role=ROLE) + get_adapter("snowflake") |
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.6 --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 triggers docker.yml)
docker pull ghcr.io/tzinny-dev/strata:0.1.6
docker run --rm ghcr.io/tzinny-dev/strata:0.1.6 --help
docker run --rm -v $PWD:/work -w /work ghcr.io/tzinny-dev/strata:0.1.6 build examples/daily_orders.strata
docker run --rm -v $PWD:/work -w /work ghcr.io/tzinny-dev/strata:0.1.6 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.6 -f Dockerfile .
VS Code extension
# marketplace (id: Tzinny-dev.strata-tzinny, version aligned with strata-lang)
code --install-extension Tzinny-dev.strata-tzinny
Syntax highlighting for .strata + LSP client over strata lsp:
diagnostics (the same Checker as strata check), completion of
models/sources/columns, type hover and go-to-definition for
columns. Requires strata on the PATH or the setting
strata.binaryPath. Local rebuild: cd vscode && npm install && npm run compile && npx vsce package. See docs-site/guide/vscode.md.
Development
.venv/bin/pytest -q
.venv/bin/pytest --cov=strata --cov-fail-under=80
Coverage gate: 80% (pyproject.toml / pytest.ini).
Metadata
Release files for strata-lang 0.1.6
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| strata_lang-0.1.6.tar.gz | 285.1 kB | With provenance | Details for strata_lang-0.1.6.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| strata_lang-0.1.6-py3-none-any.whl | Python 3 | none | any | Details for strata_lang-0.1.6-py3-none-any.whl |
Total release size: 477.0 kB
Release files / strata_lang-0.1.6.tar.gz
| Download URL | strata_lang-0.1.6.tar.gz |
|---|---|
| Size | 285.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
7e5c968fdc63c63a767bcef2f2c42f1db88ed456c4ada13dc75b70864af72e76
|
|
BLAKE2b-256 checksum How to use checksums |
c62b1f04d169b0dc93da462d1b0df2ab728efc9a0bde8f5be485e4d5baf53b56
|
| 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 Oct 9, 2026.
Transparency logRelease files / strata_lang-0.1.6-py3-none-any.whl
| Download URL | strata_lang-0.1.6-py3-none-any.whl |
|---|---|
| Size | 191.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
663f0b7ef8636f84fb0bf0d13f5d97ffdbb4b1c487a2e770ce844612d1dd2c3b
|
|
BLAKE2b-256 checksum How to use checksums |
dfd710c57a3a91d9c644bdca5a604e3b8a886dfc4d555bebd3fa8609c697fc3a
|
| 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 Oct 9, 2026.
Transparency logSecurity for strata-lang 0.1.6
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.
Full provenance
Both files in this release have been uploaded with provenance metadata.
Attestation for strata_lang-0.1.6.tar.gz
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 Oct 9, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.