Using Amazon Athena to query data in Amazon S3
Amazon Athena is a serverless query service that allows us to use SQL statements to query data from files stored in S3. With Amazon Athena, we don’t have to worry about infrastructure management and it scales automatically to handle our queries:
Figure 4.35 – How Amazon Athena works
If you were to set this up yourself, you may need to set up an EC2 instance cluster with an application such as Presto. In addition to this, you will need to manage the overall cost, security, performance, and stability of this EC2 cluster setup yourself.
Setting up the query result location
If the Before you run your first query, you need to set up a query result location in Amazon S3 notification appears on the Editor page, this means that you must make a quick configuration change on the Amazon Athena Settings page so that Athena can store the query results in a specified S3 bucket location every time there’...