Amazon Athena is an interactive query service that lets you use standard SQL to analyze data directly in Amazon S3. You can point Athena at your data in Amazon S3 and run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to set up or manage. You pay only for the queries you run. Athena scales automatically---executing queries in parallel---so results are fast, even with large datasets and complex queries. For more information, see What is Amazon Athena in the Amazon Athena User Guide.
If you connect to Athena using the JDBC driver, use version 1.1.0 of the driver or later with the Amazon Athena API. Earlier version drivers do not support the API. For more information and to download the driver, see Accessing Amazon Athena with JDBC.
For code samples using the AWS SDK for Java, see Examples and Code Samples in the Amazon Athena User Guide.
athena()| batch_get_named_query | Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of query ID strings |
| batch_get_query_execution | Returns the details of a single query execution or a list of up to 50 query executions, which you provide as an array of query execution ID strings |
| create_named_query | Creates a named query in the specified workgroup |
| create_work_group | Creates a workgroup with the specified name |
| delete_named_query | Deletes the named query if you have access to the workgroup in which the query was saved |
| delete_work_group | Deletes the workgroup with the specified name |
| get_named_query | Returns information about a single query |
| get_query_execution | Returns information about a single execution of a query if you have access to the workgroup in which the query ran |
| get_query_results | Returns the results of a single query execution specified by QueryExecutionId if you have access to the workgroup in which the query ran |
| get_work_group | Returns information about the workgroup with the specified name |
| list_named_queries | Provides a list of available query IDs only for queries saved in the specified workgroup |
| list_query_executions | Provides a list of available query execution IDs for the queries in the specified workgroup |
| list_tags_for_resource | Lists the tags associated with this workgroup |
| list_work_groups | Lists available workgroups for the account |
| start_query_execution | Runs the SQL query statements contained in the Query |
| stop_query_execution | Stops a query execution |
| tag_resource | Adds one or more tags to the resource, such as a workgroup |
| untag_resource | Removes one or more tags from the workgroup resource |
# NOT RUN {
svc <- athena()
svc$batch_get_named_query(
Foo = 123
)
# }
# NOT RUN {
# }
Run the code above in your browser using DataCamp Workspace