By   February 28, 2024

AWS Athena – Default Profile .aws – okta

The query editor needs a connection and sometimes we want to use the credentials generated in .aws folder in the machine. They might have been generated by any process including Okta.

You need to override the following parameters with simba driver:

Credentials Provider
jdbc:awsathena://;AwsCredentialsProviderClass=com.simba.athena.amazonaws.auth.profile.ProfileCredentialsProvider;

Credentials Provider Argument
AwsCredentialsProviderArguments=default

You would be needing these additional arguments:

  1. Endpoint URL: athena..amazonaws.com
  2. OutputLocation
  3. Database
  4. S3Output Location