AWS Athena
What Is AWS Athena?
AWS Athena is a service designed to help data analysts conduct interactive queries in Amazon S3 – Amazon’s cloud storage service. While Amazon S3 is designed to facilitate online archiving and backup of data and apps on AWS, Athena allows users to analyze this data using Structured Query Language (SQL). This allows you to perform ad hoc, quick, and complex analysis using large-scale datasets.
AWS Athena is a serverless service, freeing analysts from using any dedicated computing infrastructure while using it. There is no need to load your Amazon S3 data into Athena to transform it before analysis. This makes data analytics faster and simpler.
A data analyst can access AWS Athena through an API, AWS Management Console, or a Java Database Connectivity Driver. They can then define the concerned schema and use the pre-built query editor to execute SQL queries.