AWS athena documentation change

Service: athena · 2025-04-03 · Documentation low

File: athena/latest/ug/creating-tables-how-to.md

Summary

Replaced example CREATE TABLE statement from cloudfront_logs with OpenCSVSerde example.

Security assessment

Change is a routine documentation example update with no security implications.

Diff

diff --git a/athena/latest/ug/creating-tables-how-to.md b/athena/latest/ug/creating-tables-how-to.md
index 015f8a006..4d010fe1f 100644
--- a//athena/latest/ug/creating-tables-how-to.md
+++ b//athena/latest/ug/creating-tables-how-to.md
@@ -39,17 +39,9 @@ For more information, see [Use a crawler to add a table](./schema-crawlers.html)
-  2. Enter a statement like the following in the query editor, and then choose **Run** , or press `Ctrl+ENTER`.
-    
-        CREATE EXTERNAL TABLE IF NOT EXISTS cloudfront_logs (
-        `Date` Date,
-        Time STRING,
-        Location STRING,
-        Bytes INT,
-        RequestIP STRING,
-        Method STRING,
-        Host STRING,
-        Uri STRING,
-        Status INT,
-        Referrer STRING,
-        OS String,
-        Browser String,
-        BrowserVersion String
-    ) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
+  2. In the query editor, enter a statement as shown in the following example and then choose **Run**.
+    
+        CREATE EXTERNAL TABLE myopencsvtable (
+       firstname string,
+       lastname string,
+       job string,
+       country string
+    )
+    ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
@@ -57,2 +49,6 @@ For more information, see [Use a crawler to add a table](./schema-crawlers.html)
-    "input.regex" = "^(?!#)([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+[^\(]+[\(]([^\;]+).*\%20([^\/]+)[\/](.*)$"
-    ) LOCATION 's3://athena-examples-MyRegion/cloudfront/plaintext/';
+       'separatorChar' = ',',
+       'quoteChar' = '"',
+       'escapeChar' = '\\'
+       )
+    STORED AS TEXTFILE
+    LOCATION 's3://amzn-s3-demo-bucket/mycsv/';