@rohitshetty @jdwills Quick update. Turns out this has been fixed in 24.2.3 and 23.2.3. And should be fixed in the next release cycle for Dremio Cloud.
There shouldn’t be a performance implication using the workaround. You should be able to see partition pruning happening in the raw profile of the query. IMO, partition inference is more of a convenience feature.