Chapter 6: Amazon Athena – Combining the Simplicity of Files with the Power of SQL
In Chapter 3, Storage in AWS – Choosing the Right Tool for the Job, we covered many of the file and object storage services offered by AWS. In Chapter 5, Selecting the Right Database Service, we covered many of the AWS database services. What if there was a way to combine the simplicity and cost-effectiveness of files with the power of SQL? In fact, such a way exists in AWS, and it's called Amazon Athena.
Don't assume that because this service exists, we now don't need to use databases for some use cases. In this chapter, in addition to learning about the details and mechanics of Amazon Athena, we will also learn about when it makes sense to use Amazon Athena and when an AWS database service is more appropriate.
In this chapter, once we have introduced Amazon Athena, we will learn more about Amazon Athena workgroups. We will also review Amazon Athena's APIs toward...