Optimize Amazon Athena Queries with New Query Analysis Tools | Amazon Web Services

Amazon Athena is a serverless interactive query service that makes it easy to analyze data in your data lake using SQL. You can now analyze and optimize the performance of your queries using new visual, interactive tools available in the Athena console. In this video, you will learn how to see the execution plan for your queries, visualize the performance of completed queries, and examine granular query execution details to identify ways to make queries run more quickly and efficiently.
Learn more:
Amazon Athena - go.aws/3ISWlPC
Viewing execution plans for SQL queries - go.aws/3PGMu1r
Viewing statistics and execution details for completed queries - go.aws/3ogCxfo
Top 10 Performance Tuning Tips for Amazon Athena - go.aws/3IUm6yZ
Amazon Athena adds visual query analysis and tuning tools - go.aws/3B6Dv5A
Subscribe:
More AWS videos - bit.ly/2O3zS75
More AWS events videos - bit.ly/316g9t4
ABOUT AWS
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers - including the fastest-growing startups, largest enterprises, and leading government agencies - are using AWS to lower costs, become more agile, and innovate faster.
#AmazonAthena #AWS #AmazonWebServices #CloudComputing #AWSDemo #AWSDevOps

[@kechew]

Why is the Execution time sown at each step different than step0. from your example some steps have execution time of 1+ hour while the overall execution completed in minutes.

[@wishful1018]

For the group by example didn't understood what was the optimization? The requirement of grouping by four columns is generally different from grouping by two columns and execution time of these two are not comparable. The requirement cannot be changed just to show the improvement in query execution time.