How can I create tables in Athena

0 votes
Athena does not give the functionality of create table, how to create a table in Athena? Can someone help me with this?
Jan 17, 2019 in AWS by Anjali
• 2,950 points
1,486 views

1 answer to this question.

0 votes

Creating tables in Athena is very easy. All you need to do is :-

1. Upload the file to S3 bucket.

2. Create a format for your table in Athena Console and point to your data in S3.

3. An external table is created.

For a detailed explanation on how to do this, you can refer to the blog:- "What Is Amazon Athena?"

answered Jan 17, 2019 by Edureka
• 4,220 points

Related Questions In AWS

0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
• 58,020 points
4,820 views
0 votes
1 answer

How can I get current date in a CloudFormation script?

There was a similar question asked on ...READ MORE

answered Aug 29, 2018 in AWS by Priyaj
• 58,020 points
8,922 views
0 votes
1 answer
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How to delete / drop multiple tables in AWS athena?

It is not possible to run multiple ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
8,247 views
0 votes
1 answer

How to update or insert data using Athena?

Athena is a query language and as ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
12,116 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