Cmdlets for Amazon Athena

Build 20.0.7654

Select-AmazonAthena Cmdlet

Parameters   Output Objects  

Searches Amazon Athena data.


Select-AmazonAthena [parameters]


The Select-AmazonAthena cmdlet allows you to use a syntax similar to SQL SELECT statements to search Amazon Athena data.

$conn = Connect-AmazonAthena AWSAccessKey "a123" -AWSSecretKey "s123" -AWSRegion "IRELAND" -Database "sampledb" -S3StagingDirectory "s3://bucket/staging/"
Select-AmazonAthena -Connection $conn -Table "Customers" -Columns @("Name","TotalDue") -Where "CustomerId='12345'"

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