Thanks for helping!

Setting table properties unfortunately didn't do the trick. We ended up have a view that points to the latest partition like this for fast queries: 

SELECT
*
FROM
parquet.`s3://bucket/prefix/partition_column_date=20250616/`

We haven't found a better solution yet.