Reference

Authentication IAM access key

Description

No description available [API reference]

Instructions

Athena JDBC v3 uses IAM access keys (same idea as a Stripe secret key). Query results land in S3. Bridge then serves Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Sign in to the IAM console.
  2. Create (or reuse) an IAM user or role with Athena and Glue catalog permissions plus s3:GetObject / s3:PutObject on the query-results bucket.
  3. Open Security credentials and create an access key. Copy Access key ID into User name and Secret access key into Password. Do not check keys into XML or TFVC.
  4. In the Athena console, note Region, WorkGroup (often primary), Catalog, and the S3 output location (s3://your-bucket/prefix/).
  5. After Finish, edit the JDBC URL on the DSN Main UI to replace WorkGroup, Region, Catalog, and OutputLocation.
  6. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  7. Done. You can query from C#, Python, PowerShell, and ODBC apps.

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. MyAwsDataCatalog). 		YES MyAwsDataCatalog
Name: OutputLocation

Label: Output location

Athena query result S3 location (e.g. s3://my-s3-bucket/). 		YES s3://my-s3-bucket/
Name: UserName

Label: Access key ID

IAM access key ID (not a personal AWS console login). Paste from IAM > Security credentials. 		YES
Name: Password

Label: Secret access key

IAM secret access key for the same access key ID. 		YES
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