AWS Security ChangesHomeSearch

AWS athena: Document new ALB access log columns in Athena CREATE TABLE example

Service: athena · 2026-11-07 · Documentation low

File: athena/latest/ug/create-alb-access-logs-table.md · Type: logging

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]+)\" \"([^ ]*)\" \"([^ ]*)\" ?([^ ]*)?(?: \"([^\"]*)\" \"([^\"]*)\" \"([^\"]*)\")?(?: ([^ ]*))? ?( .*)?'