MetadataRetrievalMethod

This property determines how the metadata would be retrieved from Athena for different JDBC API calls like getTables, getColumns. Following are the valid values:

• Auto: At connection time connector automatically determines whether to use AWS Glue or Query to retrieve metadata for the specified Athena region. If AWS Glue is supported in the region and Athena has been upgraded to use AWS Glue, the connector uses AWS Glue to retrieve the metadata. If AWS Glue is not supported in the region or Athena hasn’t been upgraded to use AWS Glue, the connector queries Athena to retrieve the metadata.
• Glue: The connector uses AWS Glue to retrieve the metadata regardless of whether AWS Glue is supported or used in the region.
• ProxyAPI: The connector uses Athena’s proxy API. This is used to query external catalogs.
• Query: The connector uses Query to retrieve the metadata regardless of whether AWS Glue is supported or used in that region.

Important: Changing the default value for this configuration option may lead to unwanted behavior. For example, the connector may attempt to use AWS Glue in a region where AWS Glue is not supported or used.

Default Value	Data Type	Required
Auto	String	No