Amazon Athena
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
1 APIs
1 Capabilities
10 Features
Amazon AthenaSQLAnalyticsServerlessAWS
APIs
Amazon Athena API
REST management API for Amazon Athena covering query executions, named queries, work groups, data catalogs, databases, table metadata, and prepared statements.
Capabilities
Run Capabilities with Naftiko — Deploy and orchestrate these API capabilities using Naftiko Fleet.
Run with Naftiko
SQL Analytics Workflow
Workflow capability for running and managing SQL analytics queries with Amazon Athena including query execution, named queries, work groups, and data catalog management.
Run with NaftikoRun Capabilities with Naftiko — Deploy and orchestrate these API capabilities using Naftiko Fleet.
Run with Naftiko
Features
Serverless SQL query execution against Amazon S3 data
Pay-per-query pricing with no infrastructure management
Support for standard ANSI SQL with complex joins and window functions
Integration with AWS Glue Data Catalog for schema management
Named queries for saving and reusing SQL statements
Work groups for query isolation and cost management
Prepared statements for parameterized query execution
Multiple data format support including Parquet, ORC, JSON, CSV
Query result caching for improved performance and cost reduction
Fine-grained access control with IAM and Lake Formation
Use Cases
Analyze log files and clickstream data stored in S3
Run ad-hoc SQL queries on data lake without ETL
Build serverless data pipelines and reporting solutions
Query AWS service logs including CloudTrail, ELB, and VPC Flow Logs
Perform cost analysis on AWS Cost and Usage Reports
Enable self-service analytics for business intelligence teams
Integrations
Amazon S3
AWS Glue
Amazon QuickSight
AWS Lake Formation
Amazon CloudWatch
AWS IAM
Amazon DynamoDB
AWS Step Functions
Amazon SageMaker
Apache Spark