Amazon Athena to Query AWS S3 Data

Рет қаралды 26,670

2 жыл бұрын

===================================================================
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

Пікірлер: 31

@jeffm4284 11 ай бұрын

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 11 ай бұрын

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.

@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.

@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.

@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 11 ай бұрын

@@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.

@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.

@Saady2s Жыл бұрын

Thank you

@cloudquicklabs Жыл бұрын

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

@DHAVAL518 11 ай бұрын

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

@cloudquicklabs 11 ай бұрын

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

@PeDro-dq9vr Жыл бұрын

thanks

@cloudquicklabs Жыл бұрын

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

@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.