JDBC Driver for Amazon Athena

Build 22.0.8462

QueryCachingLevel

Modifies the usage of query results stored in S3StagingDirectory . Cached queries will not be scanned again by Amazon Athena until the amount of seconds specified in QueryTolerance has passed.

Possible Values

None, Local, Cloud

Data Type

string

Default Value

"Local"

Remarks

Modifies the usage of query results stored in S3StagingDirectory. Cached queries will not be scanned again by Amazon Athena until the amount of seconds specified in QueryTolerance has passed. The casing of the queries must match exactly to trigger the behavior, which is explained below:

LocalSetting QueryCachingLevel to Local will persist the query Id returned by Amazon Athena after a query execution individually for every connection. Closing the connection will clean the cache, so that only a single connection can make use of the results.
CloudSetting QueryCachingLevel to Cloud will persist the query Id in the form of a named query in Amazon Athena. Closing the connection will only clean the results if it is the last open connection in a process, so that multiple connections can make use of the results.
NoneSetting QueryCachingLevel to None will disable the feature.

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