Comment by streamdreams

Good points re: Athena performance tuning. I've found that my go to has been to do some form of ingest date partitioning, and use parquet compressed with zstd (among some other things mentioned in your links). Although with the improvements made in Athena version 3, I'm excited to test it out with Delta Lake tables!