Add support to read parquet files with metadata files from S3

[malhotrashivam]

In the current code, we only support reading a single parquet file from S3 bucket. We should extend this support to read parquet files with metadata files stored in S3.
This can be done after #5039 for simpler testing.