Breaking News: Grepper is joining You.com. Read the official announcement!

amazon athena for load balancing logs easy setup guide

Radhia Shah answered on April 23, 2024 Popularity 1/10 Helpfulness 1/10

answer amazon athena for load balancing logs easy setup guide

related amazon athena for load balancing logs easy setup guide

amazon athena for load balancing logs easy setup guide

Comment

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Principal": {
        "AWS": "arn:aws:iam::elb-account-id:root"
      },
      "Action": "s3:PutObject",
      "Resource": "arn:aws:s3:::bucket-name/prefix/AWSLogs/your-aws-account-id/*"
    }
  ]
}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: dakshjat.medium.com

Tags: amazon-athena load-balancing whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Radhia Shah

0 Answers Avg Quality 2/10

Closely Related Answers

amazon athena for load balancing logs easy setup guide

Comment

CREATE EXTERNAL TABLE IF NOT EXISTS alb_logs (
            type string,
            time string,
            elb string,
            client_ip string,
            client_port int,
            target_ip string,
            target_port int,
            request_processing_time double,
            target_processing_time double,
            response_processing_time double,
            elb_status_code int,
            target_status_code string,
            received_bytes bigint,
            sent_bytes bigint,
            request_verb string,
            request_url string,
            request_proto string,
            user_agent string,
            ssl_cipher string,
            ssl_protocol string,
            target_group_arn string,
            trace_id string,
            domain_name string,
            chosen_cert_arn string,
            matched_rule_priority string,
            request_creation_time string,
            actions_executed string,
            redirect_url string,
            lambda_error_reason string,
            target_port_list string,
            target_status_code_list string,
            classification string,
            classification_reason string
            )
            ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
            WITH SERDEPROPERTIES (
            'serialization.format' = '1',
            'input.regex' = 
        '([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*):([0-9]*) ([^ ]*)[:-]([0-9]*) ([-.0-9]*) ([-.0-9]*) ([-.0-9]*) (|[-0-9]*) (-|[-0-9]*) ([-0-9]*) ([-0-9]*) \"([^ ]*) (.*) (- |[^ ]*)\" \"([^\"]*)\" ([A-Z0-9-_]+) ([A-Za-z0-9.-]*) ([^ ]*) \"([^\"]*)\" \"([^\"]*)\" \"([^\"]*)\" ([-.0-9]*) ([^ ]*) \"([^\"]*)\" \"([^\"]*)\" \"([^ ]*)\" \"([^\s]+?)\" \"([^\s]+)\" \"([^ ]*)\" \"([^ ]*)\"')
            LOCATION 's3://<alb-logs-s3-bucket>/AWSLogs/<ACCOUNT-ID>/elasticloadbalancing/<REGION>/'

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: dakshjat.medium.com

Tags: amazon-athena load-balancing whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Radhia Shah

0 Answers Avg Quality 2/10

amazon athena for load balancing logs easy setup guide

Comment

CREATE DATABASE access_logs;

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: dakshjat.medium.com

Tags: amazon-athena load-balancing whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Radhia Shah

0 Answers Avg Quality 2/10

amazon athena for load balancing logs easy setup guide

Comment

SELECT COUNT(*)
FROM alb_logs;

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: dakshjat.medium.com

Tags: amazon-athena load-balancing whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Radhia Shah

0 Answers Avg Quality 2/10

amazon athena for load balancing logs easy setup guide

Comment

SELECT *
from alb_logs
where elb_status_code = 503;

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: dakshjat.medium.com

Tags: amazon-athena load-balancing whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Radhia Shah

0 Answers Avg Quality 2/10

amazon athena for load balancing logs easy setup guide

Contents

More Related Answers

amazon athena for load balancing logs easy setup guide

Closely Related Answers

amazon athena for load balancing logs easy setup guide

amazon athena for load balancing logs easy setup guide

amazon athena for load balancing logs easy setup guide

amazon athena for load balancing logs easy setup guide

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.