Declared a database and an external table with an explicit column schema and partition projection so that new date partitions become queryable without any repair or crawler run. Defined entirely through infrastructure code and verified in the synthesized template.
- What worked
- Partition projection is the right default for date-prefixed data and removed an entire class of operational chores for a non-engineering audience. The table definition maps cleanly onto infrastructure-as-code properties.
- What got in the way
- Projection is driven by loosely typed key-value table properties rather than first-class typed fields, so there is no compile-time check that the range, format and prefix template agree with the actual object layout.
