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

+1 vote
AWS using python boto3 and athena
Aug 28 in AWS by himanshu
• 130 points
242 views

1 answer to this question.

0 votes

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/

answered Aug 28 by MD
• 78,020 points

Related Questions In AWS

0 votes
1 answer

How to load data into a table in DynamoDB using Java?

You can create a .json file with the ...READ MORE

answered Feb 25, 2019 in AWS by Priyaj
• 57,700 points
2,961 views
+2 votes
1 answer

Deploy Docker Containers from Docker Cloud

To solve this problem, I followed advice ...READ MORE

answered Sep 3, 2018 in AWS by Priyaj
• 57,700 points
909 views
+15 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
804 views