QueryCachingLevel Parameter (Connect-AmazonAthena Cmdlet)
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.
Syntax
Connect-AmazonAthena -QueryCachingLevel string
Possible Values
None, Local, CloudData Type
cstr
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:
| Local | Setting 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. |
| Cloud | Setting 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. |
| None | Setting QueryCachingLevel to None will disable the feature. |