JDBC Driver for Amazon Athena

Build 22.0.8462

Connection Properties

The available connection properties can be retrieved with the getPropertyInfo method of the Driver class. This method returns an array with elements of type DriverPropertyInfo.

String connectionString = "jdbc:AWSAccessKey='a123';AWSSecretKey='s123';AWSRegion='IRELAND';Database='sampledb';S3StagingDirectory='s3://bucket/staging/';:";

Driver driver = DriverManager.getDriver(connectionString);
Properties info = new Properties();
DriverPropertyInfo[] attr = driver.getPropertyInfo(connectionString,info);
for(int i=0;i<attr.length;i++){
  System.out.println(attr[i].name);
  System.out.println(attr[i].description);
  System.out.println(attr[i].required);
  System.out.println(attr[i].value);
  String[] c = attr[i].choices;
  if(c != null) {
    for(String s: c)
      System.out.println(s);
  }
}

The DriverPropertyInfo class has the following properties:

Property NameData TypeDescription
NameStringThe name of the connection property.
DescriptionStringThe description for the connection property.
RequiredbooleanWhether the connection property must be set to connect to Amazon Athena.
ChoicesString[]An array of the allowed values for the connection property.
ValueStringThe current value of the connection property or the default value if one is not set by the user.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462