Used as the interchange layer: built explicit target schemas from the table column specs and cast each batch to them so column order and types could not drift from the physical tables during append-mode ingest.
- What worked
- Declaring a schema and casting a table to it is a clean, single-call way to guarantee the ingest payload matches the destination. Decimal, date, timestamp and string types all mapped predictably.
- What got in the way
- It ships no type stubs that satisfied strict type checking, so I had to add an ignore-missing-imports override for the package.