Amazon Athena to Query AWS S3 Data

===================================================================
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.buymeacoffee.com/cloudqui...
===================================================================
This video shows how to use Amazon Athena service to run query on data present in AWS S3 bucket of format (.csv/.json etc).
It video has pictorial overview of demo and step-by-step explanation of required configuration at these services and demo of running queries
#aws #athena #awsathena #s3 #query #bigdata #serverless

[@jeffm4284]

I have to say this was a very well done tutorial. I especially appreciate the call-outs for - "make sure you remember to do this. It is very important". Those "little" details are very easy to miss and cause a lot of lost time and frustration. Every time you made a call-out, I went back a little bit to make sure I captured the instructions. I can tell it helped me to avoid pulling more hair out of my head. Well done sir!

[@cloudquicklabs]

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

[@raymetz4546]

Thanks for a great video. This is one of the few videos that show each of the steps to perform basic operations. I appreciate your commentary too.

[@cloudquicklabs]

Thank you for watching my videos.
Thank you very much for your note.
Keep watching and keep learning from my videos. Happy learning.

[@kondavidyasagar6115]

This video is informative and helpful on how to use Athena! Thank you!

[@cloudquicklabs]

Thank you for watching my videos.
I am glad that it helped you.

[@aldoaguirre9864]

amazing video ! In few minutes I learned a lot!

[@cloudquicklabs]

Thank you for watching my videos.
Thank you for kind note. Appreciated, keep watching and keep learning from my videos.

[@avneetkaur8097]

sir great job at making this video! you have no idea how much time you saved me. Thanks a ton

[@cloudquicklabs]

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

[@joshlingeorge9220]

Many thanks for creating this video, very helpful.

[@cloudquicklabs]

Thank you for watching my videos.
I am glad that it helped you.

[@priyankadevendran6982]

thank you for the video. I'm facing an issue with the csv to table transformation. All my column values are added in the first column

[@cloudquicklabs]

Thank you for watching my videos.
You need to use AWS glue option to extract data from S3 bucket to Athena Query table, where you will an option to ignore first row as it will column names.

[@jeffm4284]

@@cloudquicklabs I think there's been some updates to the definition process as I saw my console looked different than what's in this video. I was able to figure that out quickly. But, there's now an option under the Data format section to specify the field.delim, then under that - Column details. Headers in the Preview Table command were omitted.

[@skularatna8136]

which is more cost efficient to use glue crawler with Athena or Athena directly to query data in s3

[@cloudquicklabs]

Thank you for watching my videos.
Both are cost effective approach at their unique requirement. But preferably directly accessible would more cost effective way.

[@Saady2s]

Thank you

[@cloudquicklabs]

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

[@diwakarjoshi4108]

WOW

[@cloudquicklabs]

Thank you for watching my videos.
Its really great to hear from your side.

[@PeDro-dq9vr]

thanks

[@cloudquicklabs]

Thank you for watching my videos.
I am glad that it helped you.

[@rojerben9296]

If we add new csv file into S3 bucket, will it add data to Athena table automatically?

[@cloudquicklabs]

Thank you for watching my videos. I believe that you need to run the query again to load the data in temporary database then use it. Please try the same from your side.

[@DHAVAL518]

To run Athena Query,MySQL knowledge is enough ?or which query language knowledge to we need to know ? please suggest ?

[@cloudquicklabs]

Thank you for watching my videos.
If you know T- SQL query is enough. It works at Amazon Athena as well.

[@mohammadaliazam3624]

Beware before buying any product from Vision as their support is very very poor. I called their hotline twice and after long music it only ended up with 'Good Bye'. Very upsetting.

[@cloudquicklabs]

Thank you for watching my videos.
I understand your concerns here.

[@AbhimanyuKumar-uh9un]

GENERIC_INTERNAL_ERROR: S3 service error I'm getting this error

[@cloudquicklabs]

Thank you for watching my videos.
Could you please give more context on task that you are performing and which results in tjis error.