AWS athena: Document new ALB access log columns in Athena CREATE TABLE example
Summary
Adds transformed_host, transformed_uri, request_transform_status and ip_address columns to the sample ALB access log table, updates the description text, and adjusts the regex to capture the optional trailing fields.
Security assessment
Schema/documentation update to expose additional ALB access-log fields (IP address, transformed URI) for querying and analysis; it is logging-adjacent but contains no vulnerability fix or explicit security guidance.
Evidence
+The following example `CREATE TABLE` statement includes the recently added `classification`, `classification_reason`, `conn_trace_id` ('traceability ID', or TID), `transformed_host`, `transformed_uri`, `request_transform_status`, and `ip_address` columns. To create a table for Application Load Balancer access logs that do not contain these entries, remove the corresponding columns from the `CREATE TABLE` statement and modify the regular expression accordingly.
Diff
diff --git a/athena/latest/ug/create-alb-access-logs-table.md b/athena/latest/ug/create-alb-access-logs-table.md index 02d9052..0f5ef54 100644 --- a//athena/latest/ug/create-alb-access-logs-table.md +++ b//athena/latest/ug/create-alb-access-logs-table.md @@ -15 +15 @@ For information about each log file field, see [Access log entries](https://docs -The following example `CREATE TABLE` statement includes the recently added `classification`, `classification_reason`, and `conn_trace_id` ('traceability ID', or TID) columns. To create a table for Application Load Balancer access logs that do not contain these entries, remove the corresponding columns from the `CREATE TABLE` statement and modify the regular expression accordingly. +The following example `CREATE TABLE` statement includes the recently added `classification`, `classification_reason`, `conn_trace_id` ('traceability ID', or TID), `transformed_host`, `transformed_uri`, `request_transform_status`, and `ip_address` columns. To create a table for Application Load Balancer access logs that do not contain these entries, remove the corresponding columns from the `CREATE TABLE` statement and modify the regular expression accordingly. @@ -51 +51,5 @@ The following example `CREATE TABLE` statement includes the recently added `clas - conn_trace_id string + conn_trace_id string, + transformed_host string, + transformed_uri string, + request_transform_status string, + ip_address string @@ -57 +61 @@ The following example `CREATE TABLE` statement includes the recently added `clas - '([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*):([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]+)\" \"([^ ]*)\" \"([^ ]*)\" ?([^ ]*)?(?: \"([^\"]*)\" \"([^\"]*)\" \"([^\"]*)\")?(?: ([^ ]*))? ?( .*)?'