Zero-downtime partition swaps on Athena: build in a new prefix, flip with SET LOCATION

<p>In <a href="https://dev.to/csotelo/idempotent-loads-on-s3-athena-skip-unchanged-partitions-with-content-signatures-1c80">part 1</a><br> I made partition rebuilds idempotent with <strong>delete prefix → INSERT INTO →<br> add partition</strong>. In the comments, <a href="https://dev.to/karanpulyala">Karan Pulyala</a><br> pointed out two weak spots. This post fixes the first one, hands-on and<br>

Read the source →