Amazon Athena Query | S3 | JSON | Amazon Athena Query for Amazon S3 Bucket JSON Raw Files

===================================================================
1. SUBSCRIBE FOR MORE LEARNING :
/ @cloudquicklabs
===================================================================
2. CLOUD QUICK LABS - CHANNEL MEMBERSHIP FOR MORE BENEFITS :
/ @cloudquicklabs
===================================================================
3. BUY ME A COFFEE AS A TOKEN OF APPRECIATION :
www.buymeacoff...
===================================================================
#athena #query #s3 #json #aws #bigdata #serverless

[@cristianoborgesdeoliveira3900]

Excellent video!! You explianed in details in an easy way to undertsand and create by myself

[@cloudquicklabs]

Thank you for watching my videos. Glad that it helped you.

[@WolfmaninKannada]

Excellent sir thank u so much

[@cloudquicklabs]

Thank you for watching my videos. Glad that it helped you.

[@meghashares24]

Thanks for the video.

[@cloudquicklabs]

Thank you for watching my videos. Glad that it helped you.

[@amarnatha1614]

Very nice 🙂

[@cloudquicklabs]

Thank you for watching my videos. Glad that it helped you.

[@vivekgowda1576]

Thank you for the explanation. But we have unstructured json data (it might contain a list of list multiple arry in side json) it gives an error if we try to add it into Athena . What would be the better approach?

[@cloudquicklabs]

Thank you for watching my videos. You need to use Glue job first to convert the data in to required format using crawlers and data refineries tasks store it in Data catalog tables. And then you can use Athena to Query it.

[@vivekgowda1576]

@@cloudquicklabs yeah I've tried this . But getting error for un stratured json data.

[@user-wx2fq7ot4y]

i have one doubt in real world projects as a data scientist how do extract the data (while learning we used to download datasets from kaggle) can you please clarify this

[@cloudquicklabs]

Thank you for watching my videos. I have created many videos on data extractions from many sources like S3 bucket, rds etc. Please.my channel latest videos.

[@user-wx2fq7ot4y]

@@cloudquicklabs hey thanks man ..

[@user-wx2fq7ot4y]

hey hi.....how to join tables in athena for example one json file contains about customer detail other json file contains about transactional details how we join both these tables in athena could you please help me regarding this...

[@cloudquicklabs]

Thank you for watching my videos. You can use athena query to merge two tables. Try to find docs.aws.amazon.com/athena/latest/ug/select.html

[@cloudquicklabs]

Like in sql query, you would use merge or join query to merge two source table.

[@user-ny7px9yy1m]

speak MORE MORE MORE slowly otherwise your English spoken and accent is a mission impossible . Sorry mate

[@cloudquicklabs]

Thank you for giving valuable feedbacks. Much appreciated. I shall consider these to improve my self.