I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I am reposting your solution in case you'd like to "Accept " the answer.
Issue:
Getting the below error when running a query with filter and [quarter] in ('2023Q2', '2023Q3', '2023Q4', '2024Q1')
Error handling external file: 'IO request completed with an error. ERROR = 0x0000000C'. Underlying data description: file '/machine_id=aaaa/quarter=2024Q2/month=6/partition_version=last/part-0.parquet'.
Solution:
The issue was with the way the column type was defined for the partitions while building the view. Moving from VARCHAR(MAX)
to VARCHAR(%VALUE%)
(according to the length of the column) fixed the issue and allowed queries to run with proper partition pruning.
If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.
I hope this helps!