AWS athena medium security documentation change
Summary
Added Glue connection configuration guidance, casing_mode parameter documentation, and security notes about Secrets Manager requirements
Security assessment
The change explicitly mandates AWS Secrets Manager for credential storage when using Glue connections, addressing secure credential management. This prevents insecure credential handling practices.
Diff
diff --git a/athena/latest/ug/connectors-cloudera-hive.md b/athena/latest/ug/connectors-cloudera-hive.md index dd38a375a..146a2494e 100644 --- a//athena/latest/ug/connectors-cloudera-hive.md +++ b//athena/latest/ug/connectors-cloudera-hive.md @@ -62 +62,36 @@ Use the parameters in this section to configure the Cloudera Hive connector. -### Connection string +We recommend that you configure a Cloudera Hive connector by using a Glue connections object. To do this, set the `glue_connection` environment variable of the Cloudera Hive connector Lambda to the name of the Glue connection to use. + +**Glue connections properties** + +Use the following command to get the schema for a Glue connection object. This schema contains all the parameters that you can use to control your connection. + + + aws glue describe-connection-type --connection-type CLOUDERAHIVE + +**Lambda environment properties** + + * glue_connection – Specifies the name of the Glue connection associated with the federated connector. + + * **casing_mode** – (Optional) Specifies how to handle casing for schema and table names. The `casing_mode` parameter uses the following values to specify the behavior of casing: + + * **none** – Do not change case of the given schema and table names. This is the default for connectors that have an associated glue connection. + + * **upper** – Upper case all given schema and table names. + + * **lower** – Lower case all given schema and table names. + + + + +###### Note + + * All connectors that use Glue connections must use AWS Secrets Manager to store credentials. + + * The Cloudera Hive connector created using Glue connections does not support the use of a multiplexing handler. + + * The Cloudera Hive connector created using Glue connections only supports `ConnectionSchemaVersion` 2. + + + + +#### Connection string @@ -69 +104 @@ Use a JDBC connection string in the following format to connect to a database in -### Using a multiplexing handler +#### Using a multiplexing handler @@ -79 +114 @@ Record handler | `HiveMuxRecordHandler` -#### Multiplexing handler parameters +##### Multiplexing handler parameters @@ -94 +129 @@ Property | Value -#### Providing credentials +##### Providing credentials @@ -114 +149 @@ Currently, the Cloudera Hive connector recognizes the `UID` and `PWD` JDBC prope -### Using a single connection handler +#### Using a single connection handler @@ -124 +159 @@ Record handler | `HiveRecordHandler` -#### Single connection handler parameters +##### Single connection handler parameters @@ -138 +173 @@ default | `hive://jdbc:hive2://hive1:10000/default;secret=${Test/RDS/hive1}` -### Spill parameters +#### Spill parameters