[AWS Certificate]-Athena & Quicksight

Athena

• Serverless SQL Queries on top of your data in S3, pay per query, output to S3
• Supports CSV, JSON, Parquet, ORC
• Queries are logged in CloudTrail (which can be chained with CloudWatch logs)
• Greate for sporadic queries

---

Quicksight

• Business Intelligence tool for data visualization, creating dahsboards
• Integrates with Athena, Redshift, EMR, RDS...

---

AQUA for Redshift

 

• AQUA = Advanced Query Accelerator
• It's a new distributed and hardware-accelerated cache
• Runs data intensive tasks (filtering / aggregation) closer to the storage layer
  • Avoids networking bandwidth limitations
  • Other warehouses typically need to move data to compute nodes for processing
• Enableds Redshift to run up to 10x faster than any other cloud DWs
• Can process large amounts of data in parallel across multiple nodes
• Automatically scales out to add storage capacity
• No code changes required