Skip to main content

Strata — prototype

CI Binary Publish PyPI Python License: MIT Coverage 80%

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)

Source distribution for strata-lang 0.1.6
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)

Table of built distributions (wheels) for strata-lang 0.1.6
File Interpreter ABI Platform Actions
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 log

Release 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 log

Security 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.

Select from 2 files

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 log

A 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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page