Reference

Authentication Default AWS credential chain

Description

No description available [API reference]

Instructions

Use credentials already available to the Windows account that runs the ZappySys JDBC Bridge. The AWS SDK default credential provider chain can use environment variables, shared AWS files, container credentials, or an EC2 instance role.

  1. Grant the selected IAM principal Athena and Glue catalog permissions plus access to the query-results S3 location.
  2. Configure credentials for the Windows account that runs the driver. For unattended refresh, prefer an EC2 instance role, container role, or another short-lived credential source over long-lived access keys.
  3. Enter Region and Workgroup. Enter Output location only when the workgroup does not enforce one.
  4. Finish the wizard. Then click Test Connection on the DSN Main UI.
  5. If the test cannot find credentials, verify them while signed in as the service account that runs the process, not only as your interactive user.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Amazon Athena\athena-jdbc-3.8.1-with-dependencies.jar
Name: WorkGroup

Label: Workgroup

Athena workgroup (e.g. primary). 		YES primary
Name: Region

Label: AWS region

AWS region (e.g. us-east-1). 		YES us-east-1
Name: Catalog

Label: Athena catalog

Athena catalog (e.g. AwsDataCatalog). 		YES AwsDataCatalog
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. com.amazon.athena.jdbc.AthenaDriver). 		com.amazon.athena.jdbc.AthenaDriver
Name: OutputLocation

Label: Output location

S3 query-result location. Leave empty when the workgroup supplies one.