Would you know if the reflection files on S3, the actual S3 buckets and the Dremio servers (I assume EC2) are all in the same region?
Can you also please go to the S3 distributed storage location and see the # of reflection files actually created for this query? How does it compare to the actual number of raw parquet files (non Dremio ones) you are reading ?
Thanks
@balaji.ramaswamy