AWS athena: Add new ALB access log fields to partition-projection table DDL
Summary
Extends the sample ALB access log CREATE TABLE with transformed_host, transformed_uri, request_transform_status and ip_address columns and updates the row regex to parse the optional trailing fields.
Security assessment
Documentation of log-table schema for new ALB log fields (including client IP and transformed URI); it improves the ability to query/audit load balancer traffic but does not fix a vulnerability or add security guidance.
Evidence
+ transformed_host string,
Diff
diff --git a/athena/latest/ug/create-alb-access-logs-table-partition-projection.md b/athena/latest/ug/create-alb-access-logs-table-partition-projection.md index 6131734..e4ce284 100644 --- a//athena/latest/ug/create-alb-access-logs-table-partition-projection.md +++ b//athena/latest/ug/create-alb-access-logs-table-partition-projection.md @@ -48 +48,5 @@ The following example `CREATE TABLE` statement automatically uses partition proj - conn_trace_id string + conn_trace_id string, + transformed_host string, + transformed_uri string, + request_transform_status string, + ip_address string @@ -58 +62 @@ The following example `CREATE TABLE` statement automatically uses partition proj - '([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*):([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]+)\" \"([^ ]*)\" \"([^ ]*)\" ?([^ ]*)? ?( .*)?' + '([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*):([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]+)\" \"([^ ]*)\" \"([^ ]*)\" ?([^ ]*)?(?: \"([^\"]*)\" \"([^\"]*)\" \"([^\"]*)\")?(?: ([^ ]*))? ?( .*)?'