From Dev.to
Zero-downtime partition swaps on Athena: build in a new prefix, flip with SET LOCATION
In part 1 delete prefix → INSERT INTO → . In the comments, Karan Pulyala delete-then-INSERT leaves a window where Athena readers see an empty Thanks, Karan. Here is the full pattern, with a demo you c...