Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

Athena is easy to use. Simply point to your data in Amazon S3, define the schema, and start querying using standard SQL. Most results are delivered within seconds. With Athena, there’s no need for complex ETL jobs to prepare your data for analysis. This makes it easy for anyone with SQL skills to quickly analyze large-scale datasets.

Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata repository across various services, crawl data sources to discover schemas and populate your Catalog with new and modified table and partition definitions, and maintain schema versioning.

Below are the cmdlets which are available with Amazon Athena

CmdletName                                      ServiceOperation                          
Add-ATHResourceTag                                 TagResource                                   
Get-ATHDatabase                                    GetDatabase                                   
Get-ATHDatabasisList                               ListDatabases                                 
Get-ATHDataCatalog                                 GetDataCatalog                                
Get-ATHDataCatalogList                             ListDataCatalogs                              
Get-ATHNamedQuery                                  GetNamedQuery                                 
Get-ATHNamedQueryBatch                             BatchGetNamedQuery                            
Get-ATHNamedQueryList                              ListNamedQueries                              
Get-ATHQueryExecution                              GetQueryExecution                             
Get-ATHQueryExecutionBatch                         BatchGetQueryExecution                        
Get-ATHQueryExecutionList                          ListQueryExecutions                           
Get-ATHQueryResult                                 GetQueryResults                               
Get-ATHResourceTag                                 ListTagsForResource                           
Get-ATHTableMetadata                               GetTableMetadata                              
Get-ATHTableMetadataList                           ListTableMetadata                             
Get-ATHWorkGroup                                   GetWorkGroup                                  
Get-ATHWorkGroupList                               ListWorkGroups                                
New-ATHDataCatalog                                 CreateDataCatalog                             
New-ATHNamedQuery                                  CreateNamedQuery                              
New-ATHWorkGroup                                   CreateWorkGroup                               
Remove-ATHDataCatalog                              DeleteDataCatalog                             
Remove-ATHNamedQuery                               DeleteNamedQuery                              
Remove-ATHResourceTag                              UntagResource                                 
Remove-ATHWorkGroup                                DeleteWorkGroup                               
Start-ATHQueryExecution                            StartQueryExecution                           
Stop-ATHQueryExecution                             StopQueryExecution                            
Update-ATHDataCatalog                              UpdateDataCatalog                             
Update-ATHWorkGroup                                UpdateWorkGroup                               

You can also check other AWS Services, and each services cmdlets we are providing.

Click on this Link for an Single place, where you get all the PowerShell cmdlets sorted based on the modules.

You can also refer other blogs on PowerShell at link

You can also refer other blogs on Microsoft at link

And also if you required any technology you want to learn, let us know below we will publish them in our site

Like our page in Facebook and follow us for New technical information.

References are taken from Microsoft and AWS

Leave a Reply

Your email address will not be published. Required fields are marked *