AWS athena documentation change

Service: athena · 2025-08-13 · Documentation low

File: athena/latest/ug/connectors-available.md

Summary

Added comprehensive documentation about case resolver modes in Federation SDK, including support matrix and limitations across different connectors

Security assessment

The changes focus on case sensitivity handling and compatibility between connectors/schemas without mentioning security controls, vulnerabilities, or credential management. The limitations described relate to naming conventions rather than security mechanisms.

Diff

diff --git a/athena/latest/ug/connectors-available.md b/athena/latest/ug/connectors-available.md
index 5ae5fe7f5..4184e5895 100644
--- a//athena/latest/ug/connectors-available.md
+++ b//athena/latest/ug/connectors-available.md
@@ -5 +5 @@
-Considerations and limitationsAdditional information
+Considerations and limitationsCase resolver modes in Federation SDKConnector support for case resolver modesCase resolver limitationsAdditional information
@@ -43,0 +44,97 @@ This section lists prebuilt Athena data source connectors that you can use to qu
+## Case resolver modes in Federation SDK
+
+The Federation SDK supports the following standardized case resolver modes for schema and table names:
+
+  * `NONE` – Does not change case of the given schema and table names.
+
+  * `LOWER` – Lower case all given schema and table names.
+
+  * `UPPER` – Upper case all given schema and table names.
+
+  * `ANNOTATION` – This mode is maintained for backward compatibility only and is supported exclusively by existing Snowflake and SAP HANA connectors.
+
+  * `CASE_INSENSITIVE_SEARCH` – Perform case insensitive searches against schema and tables names.
+
+
+
+
+## Connector support for case resolver modes
+
+### Basic mode support
+
+All JDBC connectors support the following basic modes:
+
+  * `NONE`
+
+  * `LOWER`
+
+  * `UPPER`
+
+
+
+
+### Annotation mode support
+
+Only the following connectors support the `ANNOTATION` mode:
+
+  * Snowflake
+
+  * SAP HANA
+
+
+
+
+###### Note
+
+It is recommended to use CASE_INSENSITIVE_SEARCH instead of ANNOTATION.
+
+### Case-insensitive search support
+
+The following connectors support `CASE_INSENSITIVE_SEARCH`:
+
+  * DataLake Gen2
+
+  * Snowflake
+
+  * Oracle
+
+  * Synapse
+
+  * MySQL
+
+  * PostgreSQL
+
+  * Redshift
+
+  * ClickHouse
+
+  * SQL Server
+
+  * DB2
+
+
+
+
+## Case resolver limitations
+
+Be aware of the following limitations when using case resolver modes:
+
+  * When using `LOWER` mode, your schema name and all tables within the schema must be in lowercase.
+
+  * When using `UPPER` mode, your schema name and all tables within the schema must be in uppercase.
+
+  * When using `CASE_INSENSITIVE_SEARCH`:
+
+    * Schema names must be unique
+
+    * Table names within a schema must be unique (for example, you cannot have both "Apple" and "APPLE")
+
+  * Glue integration limitations:
+
+    * Glue only supports lowercase names
+
+    * Only `NONE` or `LOWER` modes will work when registering your Lambda function with GlueDataCatalog/LakeFormation
+
+
+
+