Reference

Authentication AWS or IAM Identity Center profile

Description

No description available [API reference]

Instructions

Use a named AWS profile, including an IAM Identity Center (AWS SSO) profile, instead of storing an access key in the DSN.

  1. Create the named profile in the shared AWS config for the same Windows account that runs the ZappySys JDBC Bridge.
  2. For IAM Identity Center, configure the profile with aws configure sso, then sign in with aws sso login --profile athena-idc.
  3. Enter that exact profile name, 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. For scheduled jobs, make sure the profile session remains valid or use the Default AWS credential chain with a workload role.

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: ProfileName

Label: AWS profile name

Named profile from the shared AWS config or credentials files (e.g. athena or athena-idc). 		YES athena
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.