AWS Athena Parquet file extension

Question

Is there any way to configure AWS Athena to add proper file extension? 
Say `CTAS` query creates Parquet files but with no extension at all.

Accepted Answer

Hi,

This Explanation Give you an understand about your issue.

No, AWS Athena CTAS queries won't add file extensions to Parquet files. This is by design.

Actually,

=> Athena stores Parquet files without extensions internally in S3.
=> It can still efficiently read and process these files because it relies on metadata within the Parquet format to identify the file type.

Here's the simple answer with a reference link:

Athena stores Parquet files without extensions in S3. It relies on internal metadata for identification.  Reference Link: https://docs.aws.amazon.com/athena/latest/ug/parquet-serde.html

AWS Athena Parquet file extension

Relevant content