Athena

A sample properties file for AWS Athena would be:

driver=awsathena
host=athena.[Region].amazonaws.com
port=443
db=<defaultdb>
user=<awsAccessKey>
password=<awsSecretKey>
jdbc.db.name=<Default catalog to connect to. Note, skipping this value can result in errors. Use default as 'AwsDataCatalog'>
jdbc.schema.name=<Optional. Specify the schema name if used, This is referred to as database in awsathena>
S3OutputLocation=<The s3 default output path, can be found in awsathena settings>
defaultdb=<The default database to connect to. Typically same as jdbc.db.name>

Note

For awsathena the jdbc.db.name setting is the catalog name, which is typically defaulted to AwsDataCatalog and the jdbc.schema.name is the actual awsathena database name.