AWS Athena Returning Zero Records from Tables Created from GLUE Crawler database using parquet from S3

xpansionfactor 0
Viewed 23

I have created parquet files from SQL data using python. I am able to read the data on my local machine, so I know the parquet files are valid. I created a Glue Crawler that creates a database from Parquet files in S3 and the database shows the correct amount of records in the glue dashboard.

When I query that database in Athena it shows "No Results", but does show the column names.

Please see the images below for reference.

GLUE Table Properties Athena Query

amazon-athena aws-glue amazon-s3 parquet
1 Answers

I figured it out. You cannot point to the root of the S3 bucket with parquet files in that location. Each parquet file needs to be in a folder that has the same name as your file. I don't think this is required, but for automation purposes, it makes the most sense...

xpansionfactor0
Related