Skip to main content

Amazon Athena

  • Serverless query to analyze the data stored in S3.
  • SQL to query the files.
  • Commonly used with Amazon Quicksignt for dashboards.
  • Analyze data in S3 using serverless SQL, use Athena.

Performance Improvement​

  • Use columnar data for cost-savings.
  • Compress data for smaller retrievals.
  • Partition datasets in S3 for easy querying on virtual columns.
  • User larger files to minimize overhead.

Federated Query​