Side by side
Amazon Athena vs Query
Both stand on query engine software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Paid APIWeb
Athena offers several ways to submit SQL queries and supports a broad set of data formats and connectors. Account for scanned-data pricing and separate storage, catalog, and related service charges when estimating use.
Visit Amazon Athena Paid APIWeb
Choose Query if your security team needs to search distributed sources without centralizing their data, or run detections where that data resides. Look elsewhere if role-based access controls are a requirement.
Visit QueryThe facts
| Amazon Athena | Query | |
|---|---|---|
| Free plan | No | Not published |
| Open source | Not published | Not published |
| Runs on | API, Web | API, Web |
| Lowest paid plan | See the plans | Not published |
| Plans published | 3 | None |
| Maker | Not published | Not published |
| Website | aws.amazon.com | query.ai |
| On query engine software | #17 of 28 | #21 of 28 |
Amazon Athena: what it does well
- Runs interactive SQL queries on S3 data
- Supports CSV, JSON, ORC, Avro, and Parquet
- Queries can invoke SageMaker models
- Workgroups can set limits and track costs
What to know first
- No free plan
- S3 and other service charges may apply separately
- SQL query pricing is based on data scanned
Query: what it does well
- Searches connected sources in parallel and normalizes results to OCSF.
- FSQL translates queries into each connected source’s native language.
- Workers support triage, investigation, hunting, and detection.
- Read-only access keeps data at its source without ingestion.
- Supports single sign-on through Google, Microsoft, and Okta.
What to know first
- Role-based access controls are not currently supported.
Alternatives to Amazon Athena Alternatives to Query The whole list