How to query S3 data from Athena using SQL | AWS Athena Hands On Tutorial | Create Athena Tables

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.
In this hands on tutorial, I explain step by step how to query S3 data using SQL from Athena.
#aws #athena #awsglue #sql

[@parthmehta801]

Very crisp and informative video. To the point discussion. Good work!

[@guillermopasoslopez3552]

Amazing and detailed tutorial! I think this is the first time I have 0 issues following a tutorial. Keep up the good work man!

[@AWS-Made-Easy]

Thank you!

[@souryapattanayak9698]

Very crisp and informative video. Liked it very much.

[@mustafabohra2070]

Danke schön!!

[@AWS-Made-Easy]

Danke!

[@iqbal_multan]

Very well explained. Thanks for this.

[@Learn_IT_with_Azizul]

Great. Please add more contents like this especially for data extracting then analysis in RedShift... Ty

[@Alam_Syed]

Awesome, and very helpful thanks.

[@MrMemb]

Thanks, nice!

[@solaaderogba491]

This is awesome.

[@saurabhgoreamazing9368]

Nice Video. Followed it completely and then running queries. Created a file containing employee records . Though the table records are getting displayed in the athena console. I am unable to reterive the results select empid,empname from "employee"."employeedata" where salary = 1000000; Any help would be appreciated Not getting any error and hence difficult to find the cause It seems like it is not reading the data any permissions issue?

[@krksivasai]

Hello, I have a question - How is this different than copying the local csv to hdfs location(hdfs on AWS S3). And, then create external table to this location. And query this external table.

[@pedromarcos5944]

How can I convert a date that is as a string in my table into this format: '25/04/2021 07:32:23'? I would like to transform it into a date so I can check the minimum date of some records in my database.

[@CinematicsHD]

i did all of the steos and my table isnt created i dont know what step im missing any help ?

[@rajasekharanand6091]

I also followed the sam process but tables are not added in Athena dashboard. They are added in below path aws glue ->databases . How can I make this correct

[@spencerantoniomarlen-starr3069]

I don't have access to IAM roles and I am not an IAM user, is it possible to do this without using the Glue Crawler or is it possible to create a Glue Crawler without having either of those permissions??

[@user-nm3pf6fo5t]

Can some one suggest me how can we do that via AWS lambda

[@rajasekharanand6091]

I also followed the sam process but tables are not added in Athena dashboard. They are added in below path aws glue ->databases . How can I make this correct