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
'AWS Database' 카테고리의 다른 글
| [AWS Certificate]-AWS Database Encryption, Security and Auditing (0) | 2022.01.22 |
|---|---|
| [AWS Ceritificate]-Database Migration, DMS and SCT (0) | 2022.01.20 |
| Comparison of AWS Database (0) | 2022.01.20 |
| [AWS Certificate]-Amazon Redshift (0) | 2022.01.14 |
