Pinned the Python client and used it as both the local warehouse engine and the hosted-service driver. Created schema and tables, loaded pipeline frames, and queried history in tests. Local connections worked once the schema name no longer matched the catalog, and type checking needed an import override because the package lacked stubs.
- What worked
- Connect, SQL DDL, and DataFrame insert/query paths were enough to persist feeds, run records, lineage, and outcomes in one embedded file for CI.
- What got in the way
- An older client line was called out as incompatible with the hosted service, so a newer pin was required. A schema named like the database file collided with the catalog. Strict type checking failed on the import until missing stubs were ignored.
