AWS AmazonS3 documentation change
Summary
Added Important section requiring lowercase table/column names to prevent integration failures with AWS analytics services
Security assessment
Change addresses compatibility requirements rather than security vulnerabilities. Focuses on preventing service integration errors due to naming conventions.
Diff
diff --git a/AmazonS3/latest/userguide/s3-tables-create.md b/AmazonS3/latest/userguide/s3-tables-create.md index 62ba1696d..81c83a716 100644 --- a/AmazonS3/latest/userguide/s3-tables-create.md +++ b/AmazonS3/latest/userguide/s3-tables-create.md @@ -37,0 +38,6 @@ To create a table, you must first do the following: +###### Important + +When creating tables, make sure that you use all lowercase letters in your table names and table definitions. For example, make sure that your column names are all lowercase. If your table name or table definition contains capital letters, the table isn't supported by AWS Lake Formation or the AWS Glue Data Catalog. In this case, your table won't be visible to AWS analytics services such as Amazon Athena, even if your table buckets are integrated with AWS analytics services. + +If your table definition contains capital letters, you receive the following error message when running a `SELECT` query in Athena: **`"GENERIC_INTERNAL_ERROR: Get table request failed: com.amazonaws.services.glue.model.ValidationException: Unsupported Federation Resource - Invalid table or column names."`** + @@ -79,0 +86,2 @@ If you don't see these values in the **Catalog** and **Database** fields, make s + * If you receive the following error message when running a `SELECT` query in Athena, this message is caused by having capital letters in your table name or your column names in your table definition: **`"GENERIC_INTERNAL_ERROR: Get table request failed: com.amazonaws.services.glue.model.ValidationException: Unsupported Federation Resource - Invalid table or column names."`** Make sure that your table and column names are all lowercase. +