Instead of S3 select, try using awswrangler - https://github.com/awslabs/aws-data-wrangler

Overhead cost is less and is more developer friendly