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 in AWS by Anjali
• 2,900 points
25 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 by Edureka
• 4,180 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
• 56,160 points
41 views
0 votes
1 answer

How can I get current date in a CloudFormation script?

The advice by @Guy is correct, you ...READ MORE

answered Aug 29, 2018 in AWS by Priyaj
• 56,160 points
687 views
0 votes
1 answer

How can I disable a user's password in AWS using boto3

delete_login_profile is the one you should use if ...READ MORE

answered Sep 27, 2018 in AWS by Priyaj
• 56,160 points
296 views
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 in AWS by Edureka
• 4,180 points
326 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 in AWS by Edureka
• 4,180 points
136 views