What began as a neat data processing pipeline recently hit a roadblock.

Query 20250409_124602_00001_tip63 failed: Failed to commit the transaction during insert: Failed to write json to file:
s3a://warehouse/medical/ergometer-76e41009d6bc4f419bd0583b32d3bdaa/metadata/00397-9f9715cd-94e9-47ba-a351-6781f75d6427.metadata.json

TL;DR: Run ALTER TABLE <table> EXECUTE expire_snapshots(retention_threshold => '7d');