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, 2020 in AWS by himanshu
• 130 points
4,684 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, 2020 by MD
• 95,460 points

Related Questions In AWS

0 votes
1 answer
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 26, 2019 in AWS by Priyaj
• 58,100 points
6,867 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
• 58,100 points
2,659 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 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
3,953 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP