Parameters   Output Objects  

Searches Amazon Athena data.

Syntax

Select-AmazonAthena [parameters]

Remarks

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 "[AwsDataCatalog].[sampledb].Customers" -Columns @("Name","TotalDue") -Where "CustomerId='12345'"