Query Application Load Balancer logs

An Application Load Balancer is a load balancing option for Elastic Load Balancing that enables traffic distribution in a microservices deployment using containers. Querying Application Load Balancer logs allows you to see the source of traffic, latency, and bytes transferred to and from Elastic Load Balancing instances and backend applications. For more information, see Access logs for your Application Load Balancer and Connection logs for your Application Load Balancer in the User Guide for Application Load Balancers.

Prerequisites

• Enable access logging or connection logging so that Application Load Balancer logs can be saved to your Amazon S3 bucket.

• A database to hold the table that you will create for Athena. To create a database, you can use the Athena or AWS Glue console. For more information, see Create databases in Athena in this guide or Working with databases on the AWS glue console in the AWS Glue Developer Guide.

Topics

• Create the table for ALB access logs
• Create the table for ALB access logs in Athena using partition projection
• Example queries for ALB access logs
• Create the table for ALB connection logs
• Create the table for ALB connection logs in Athena using partition projection
• Example queries for ALB connection logs
• Additional resources