AWS Athena Glue and QuickSight Tutorial | Athena and QuickSight Integration

AWS Athena Glue and QuickSight Tutorial | Athena and QuickSight Integration | Serverless Analytics

Рет қаралды 25,235

3 жыл бұрын

In this video, I have explained the Serverless Analytics pipeline using Athena, Glue, and QuickSight.
If you liked this video and want to appreciate my work, you can buy me a coffee☕️
www.buymeacoffee.com/wadhara
You can also support by Sharing and Subscribing to this channel🚀.
Keep Supporting👋
Connect with me on LinkedIn -
/ ajaywadhara
#AthenaTutorial #QuickSight #AwsGlue

Пікірлер: 33

@tieduprightnowprcls Жыл бұрын

00:26 Sample Diagram 02:24 s3 setup 02:43 glue setup 08:03 athena hands-on 14:34 quicksight intro 15:22 quicksight features 18:02 quicksight SPICE 19:47 SPICE vs direct queries 22:00 how to setup quicksight account 25:28 quicksight hands-on

@codewithmaheshhbalwan 3 жыл бұрын

Thanks, bro I was getting zero records when I ran queries on the Athena table but got it done by following your step by step tutorial. 👍

@Pradify_AI 3 жыл бұрын

Great. Nicely explained 🤘🏻

@revathilokku1003 Жыл бұрын

Very informative video. Thanks a lot

@tarvinder91 2 жыл бұрын

This was super helpful and so much learning to start with. Good job in making such a video

@AjayWadhara 2 жыл бұрын

Thanks bhaji 🙏🏻

@NIYANTAjmp Жыл бұрын

very well explained. Thank you

@AjayWadhara Жыл бұрын

Glad you like it✅

@chandshaik4573 3 жыл бұрын

Hi Ajay could you please post the junit test case preparation for api gateway lambda function in java

@sanarehmani479 2 жыл бұрын

hello there, I cannot seem to get any data when I run SQL queries against Athena? Do you know why the data is not loaded in and how to load the data in the glue catalog so i am able to query Athena?

@diegov9799 Жыл бұрын

Hi, when I created a custom query about a date, the data is not showing ok in quicksight. Just show the same date.

@RedCloudServices 2 жыл бұрын

Ajay thank you. Quicksight now supports NLQ but how could you submit a Quicksight query using a voice skill?

@AjayWadhara 2 жыл бұрын

Hey Greg, not sure about this.

@bhojpuriyalaika8550 2 жыл бұрын

Hi Ajay, when i am running the athena.I am not getting any value and getting query successfully completed. Could you help me why getting and how we can resolve this

@irisli3829 3 жыл бұрын

Looks like quicksight supports fetching data directly from S3, then what is the point of using Glue/Athena/Redshift Spectrum in between S3 and Quicksight? Does that save money or provide better query functionalities?

@AjayWadhara 3 жыл бұрын

Think about fetching data through complex queries...And showing the resulting data into QuickSight

@altair7676 2 жыл бұрын

So let's say a new csv file is uploaded every week into your S3 bucket. Does this pipeline automatically get the new csv file, import to database in Athena, then visualize in quicksight ?

@AjayWadhara 2 жыл бұрын

You have to use some Event Driven behaviour here. Lets say, On S3 upload, Lambda trigger that will run crawler, and once crawler finishes, you can execute your queries

@mandarbirwadkar 3 жыл бұрын

Hi Ajay ,do we required Athena here ,can we directly take data from Glue?

@tieduprightnowprcls Жыл бұрын

26:53 here we can't see Glue as data source but Athena is present.

@isratfardous1203 3 жыл бұрын

Hi Ajay, this is very useful tutorial. I am looking for someone who can help me in my current project. Is there any way I can contact with you?

@AjayWadhara 3 жыл бұрын

You can contact me at ajay.wadhara@gmail.com

@a7garg 2 жыл бұрын

i have orders data partitioned on date in s3 . how to handle this

@a7garg 2 жыл бұрын

my bucket is like s3:/orders/date/. data in parquet 100 files. for each date. how to handle this type of senario for analysis in Quick sight

@krishnasanagavarapu4858 2 жыл бұрын

@bhavanivani448 2 жыл бұрын

Hi Ajay ,looking for aws job support

@deepadandamudi6831 3 жыл бұрын

I am looking for a trainer who can teach me. Would you be ineterested?

@thevishalln 3 жыл бұрын

S3 -> Glue -> Athena S3 -> Athena Why is glue needed when You can query from S3 directly?

@AjayWadhara 3 жыл бұрын

You can, but Glue crawlers helps you identify the schema automatically and adds data catalog which can be used in other services such as Athena, EMR, RS

@picolosantiago5392 2 жыл бұрын

Please avoid moving the mouse too much around the screen it tend to loose focus on the topic

@AjayWadhara 2 жыл бұрын

Noted✅✅

@Mr9951432442 9 ай бұрын

Hi Ajay, very informative and and helpful. I have some data in database and I want to use Athena to generate reports. Could you please share me the Video if you have it.