The optimization is limited to queries: You can optimize your questions, not your data.You can use JDBC to connect Athena with BI and machine learning tools. Custom Connectors: Amazon Athena lets you run SQL queries across multiple data sources, which can drive various business intelligence and analytics processes.Because this storage costs a fraction of what you would pay to keep the same data in a data warehouse, you can handle larger volumes of data without worry. Access to all your data: Most organizations process only 30 to 35 percent of their data into a traditional data warehouse due to the high operational and infrastructure costs of constantly resizing database clusters.

You can control and keep costs down by checking only the data you need to answer a specific query (this can be done using data splitting – see below). Low cost: Athena’s pricing model is based on terabytes of scanned data.Open file formats: Unlike many high-performance databases, Athena does not use a proprietary file format but supports standard open source formats such as Apache Parquet, ORC, CSV, and JSON.Data is stored in your Amazon S3 account, while Amazon Web Services provide Athena computation as a shared resource among all Athena users. Separated storage and computing resources: Athena has a complete separation of computing and memory resources.Ubiquitous Access: Because your data is stored in an S3 bucket and the schema is defined in the Glue Data Catalog, you can switch between query engines that can read from these sources without redefining the schema or creating a separate copy of the data.Open architecture (no vendor lock-in): Athena enables open access to data rather than lock-in to a specific tool or technology.For users who already know SQL, there is no learning curve to get started. Based on SQL: You can use Athena to run SQL queries against the desired table that is configured in the Glue data catalogue or data sources that you can connect to using the Athena Query Federation SDK.As a result, there are no additional IT costs and no clusters to manage. Using Athena is as simple as defining a query, and you only pay for the questions you run. Serverless Design Reduces IT Overhead: Amazon Athena is serverless, meaning there is no user-side infrastructure to manage or configure.

Aws redshift