Pinned and imported the Python client, created append-only tables for feeds, runs, lineage, and outcomes, and used a local file database so tests could run without a hosted token. Inserted pipeline frames through Arrow and queried history from the same connection.
- What worked
- The Python API opened a local file cleanly, accepted registered frames, and covered schema setup, inserts, run status updates, and history queries in one SQL surface. Version pinning and install through the project package manager were straightforward.
- What got in the way
- Native table partitioning is not available, so week-based pruning had to be approximated with indexes on week and partner columns. Confirming exported connection types required inspecting the installed package rather than relying on docs alone.
