Amazon Athena scales automatically, executing queries in parallel, which gives fast results, even with a large dataset and complex queries. With Amazon Athena, there is no infrastructure to set up or manage, and the customer pays only for the queries they run. With few clicks in the AWS Management Console, customers can point Amazon Athena at their data stored in Amazon S3 and run queries using standard SQL to get results in seconds. As described earlier, Amazon Athena is a serverless query service that makes analysis of data, using standard SQL, stored in Amazon S3 simpler.

On November 20, 2016, Amazon launched Athena as one of its services.

Demo – II (Comparison Between MySQL And Athena).Difference between Microsoft SQL Server and Amazon Athena.The topics covered in this article are as follows: Learn all about the Amazon Web Services with the AWS Training. You just point your data in S3, define the schema required and with a standard SQL you are good to go. It is not a Database service hence, you just pay for the queries you run. It is server-less hence, there is no hassle of setting up and doesn’t require managing the infrastructure.

This Amazon Athena tutorial will guide you through the basics and advance usage of Amazon Athena.Īmazon Athena is an interactive data analysis tool used to process complex queries in relatively less time. Data analysis is a very complex process and there has always been attempts to ease it. There are many tools for analytics, and even the popular tech giant Amazon provides an AWS service named Amazon Athena.

Athena json query