I considered converting the files to Parquet but didn't actually try it out. Probably worth trying. If I get a chance, I'll report back here on the results.

I also like your suggestion about the external table. I'll give it a go. Thanks for reading and making some suggestions. Cheers.