Unable to do METADATA REFRESH FOR PARTITIONS

[lenoyjacob]

@rohitshetty, Welcome to Dremio Community!

Try the following command. Works for me on your sample dataset:

ALTER TABLE path.to.dataset REFRESH METADATA FOR PARTITIONS (
    dir0 = 'year=2023', 
    dir1 = 'month=08', 
    dir2 = 'day=21'
);