AWS Security ChangesHomeSearch

AWS athena: Add new ALB access log fields to partition-projection table DDL

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

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

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