Athena

SELECT product_id, SUM(purchase_amount) AS total_sales
FROM sales_data
WHERE purchase_date >= '2023-01-01'
  AND purchase_date <= '2023-03-31'
GROUP BY product_id
ORDER BY total_sales DESC
LIMIT 5;

​

Key Features of AWS Athena

• Serverless Architecture: Start querying your data immediately without provisioning or managing any infrastructure.
• Cost-Effective Pricing: Only pay for the queries you run, with pricing based on the volume of data scanned.
• Built-in Functions: Enjoy a rich library of built-in functions for string manipulation, mathematical operations, date functions, and aggregations.
• Data Partitioning: Enhance query performance by partitioning your data, which minimizes the amount of data scanned.
• User-Defined Functions (UDFs): Extend Athena’s functionality by using custom user-defined functions to meet specific processing requirements.
• Supported Data Formats: Efficiently query various data formats including CSV, Parquet, ORC, and JSON.
• AWS Integration: Seamlessly integrate with other AWS services such as AWS Glue for data cataloging and Amazon QuickSight for visualization.

​

Additional Resources

• AWS Athena Documentation
• Getting Started with AWS Athena