requirements.txt

# Pinned versions verified May 2026 against PyPI metadata.
# Kit lesson L2 says always pin; L3 says match dbt-core ↔ dbt-duckdb minor (note: dbt-duckdb 1.10
# is the current stable adapter and works against dbt-core >= 1.8, so the strict-minor rule from
# the kit relaxes here — the adapter is intentionally a release behind core).
# All packages confirmed to ship cp313 wheels — install will not require a C/Rust toolchain
# and will not trigger Windows Smart App Control.

# --- dbt + warehouse ---
dbt-core==1.11.8
dbt-duckdb==1.10.1
duckdb==1.4.3        # 1.4.x LTS line — stable and well-tested with dbt-duckdb 1.10

# --- SQL lint ---
sqlfluff==4.1.0
sqlfluff-templater-dbt==4.1.0

# --- pre-commit framework ---
pre-commit==4.0.1

# --- ingestion (raw load + seed prep) ---
# pandas/pyarrow needed for the raw load and the decision-extract build.
pandas==2.2.3
pyarrow==18.0.0
requests==2.32.3
chardet==5.2.0       # keep requests import compatibility check quiet when chardet is present
openpyxl==3.1.5      # read the ONS PIPR .xlsx in scripts/prepare_ons_rent_seed.py
fastapi==0.138.1     # api/ service (deployed via api/requirements.txt; here for tests)
httpx==0.28.1        # FastAPI TestClient in tests/test_api.py

# --- orchestration (Dagster) ---
# Models the monthly refresh as an asset graph — see orchestration/ + its README.
# dagster-dbt 0.29.12 pins dagster==1.13.12 and needs dbt-core<1.12 (1.11.8 fits).
dagster==1.13.12
dagster-dbt==0.29.12
dagster-webserver==1.13.12
# Pin the grpc/protobuf stack: grpcio-health-checking>=1.82 ships a protobuf-7.x
# gencode that fails against dbt's protobuf<7.0 cap. 1.74.0 uses 6.x gencode and
# resolves cleanly with protobuf 6.33.6.
grpcio==1.74.0
grpcio-health-checking==1.74.0
protobuf==6.33.6