Please enable JavaScript.
Coggle requires JavaScript to display documents.
22.242: AMZ Athena - Coggle Diagram
22.242: AMZ Athena
Features
-
-
Support CSV, JSON, ORC, Avro, Parquet
-
-
Usecase: Business intelligence/analytics/reporting, analyze, query VPC flow log, ELB log, CloudTrail
Exam tip: analyze data in S3 using serverless SQL, use Athena
Improve performance
-
Compress data for smaller retrievals (bzip2, gizp, lz4..)
Partition dataset in S3 for ez querying on virtual column. Ex: s3://athena-examples/flight/parquet/year=1991/month=1/day=1/
-
Federate Query
Allow you to run SQL across data stored in relational/non relational, object and customer data sources (AWS or on premises)
Use Data Source Connectors that run on AWS Lambda to run Federated Queries (Ex: CloudWatch Logs, DynamoDB, RDS...)
-