how to take multiple folder s3 data into one table using athena in python pyathena

Question

AWS using python boto3 and athena

Answer 1

Hi@himanshu,

You can do that in Athena. You need to create an s3 bucket first and then store all the files in a folder and upload the folder in your s3 bucket. Now when you are creating your table in Athena at that time set the path till your folder. You can also go through the below link. You will get some examples.

https://aws.amazon.com/blogs/big-data/analyzing-data-in-s3-using-amazon-athena/