AWS re:Post Knowledge Center Feedback Survey

Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.

AWS Athena Parquet file extension

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.

Topics: Analytics
Tags: Amazon Athena
Language: English

Smotrov

asked 2 years ago517 views

1 Answer

Newest
Most votes
Most comments

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