Cmdlets for Amazon Athena

Build 20.0.7654

CleanQueryResults Parameter (Connect-AmazonAthena Cmdlet)

Amazon Athena produces cache files with every query, in the folder specified in S3StagingDirectory . CleanQueryResults specifies whether these files should be deleted once the connection is closed.

Syntax

Connect-AmazonAthena -CleanQueryResults bool

Remarks

Amazon Athena stores the results of every query you execute as a CSV file in S3StagingDirectory. These CSV files can quickly rack up a lot of space in Amazon S3.

You can use CleanQueryResults, enabled by default, to clean these files for every query executed. Note that this behavior will add a minor performance hit when you disconnect the last connection in a process.

See Also

See Advanced Settings for more information on configuring Athena's query caching.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654