NAME
Paws::Athena - Perl Interface to AWS Amazon Athena
SYNOPSIS
use Paws;
my $obj = Paws->service('Athena');
my $res = $obj->Method(
Arg1 => $val1,
Arg2 => [ 'V1', 'V2' ],
# if Arg3 is an object, the HashRef will be used as arguments to the constructor
# of the arguments type
Arg3 => { Att1 => 'Val1' },
# if Arg4 is an array of objects, the HashRefs will be passed as arguments to
# the constructor of the arguments type
Arg4 => [ { Att1 => 'Val1' }, { Att1 => 'Val2' } ],
);DESCRIPTION
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 (http://docs.aws.amazon.com/athena/latest/ug/what-is.html) 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 (https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html).
For code samples using the AWS SDK for Java, see Examples and Code Samples (https://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
For the AWS API documentation, see https://docs.aws.amazon.com/goto/WebAPI/athena-2017-05-18
METHODS
BatchGetNamedQuery
Each argument is described in detail in: Paws::Athena::BatchGetNamedQuery
Returns: a Paws::Athena::BatchGetNamedQueryOutput instance
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. Requires you to have access to the workgroup in which the queries were saved. Use ListNamedQueriesInput to get the list of named query IDs in the specified workgroup. If information could not be retrieved for a submitted query ID, information about the query ID submitted is listed under UnprocessedNamedQueryId. Named queries differ from executed queries. Use BatchGetQueryExecutionInput to get details about each unique query execution, and ListQueryExecutionsInput to get a list of query execution IDs.
BatchGetQueryExecution
Each argument is described in detail in: Paws::Athena::BatchGetQueryExecution
Returns: a Paws::Athena::BatchGetQueryExecutionOutput instance
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. Requires you to have access to the workgroup in which the queries ran. To get a list of query execution IDs, use ListQueryExecutionsInput$WorkGroup. Query executions differ from named (saved) queries. Use BatchGetNamedQueryInput to get details about named queries.
CreateNamedQuery
- Database => Str
- Name => Str
- QueryString => Str
- [ClientRequestToken => Str]
- [Description => Str]
- [WorkGroup => Str]
Each argument is described in detail in: Paws::Athena::CreateNamedQuery
Returns: a Paws::Athena::CreateNamedQueryOutput instance
Creates a named query in the specified workgroup. Requires that you have access to the workgroup.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
CreateWorkGroup
- Name => Str
- [Configuration => Paws::Athena::WorkGroupConfiguration]
- [Description => Str]
- [Tags => ArrayRef[Paws::Athena::Tag]]
Each argument is described in detail in: Paws::Athena::CreateWorkGroup
Returns: a Paws::Athena::CreateWorkGroupOutput instance
Creates a workgroup with the specified name.
DeleteNamedQuery
Each argument is described in detail in: Paws::Athena::DeleteNamedQuery
Returns: a Paws::Athena::DeleteNamedQueryOutput instance
Deletes the named query if you have access to the workgroup in which the query was saved.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
DeleteWorkGroup
Each argument is described in detail in: Paws::Athena::DeleteWorkGroup
Returns: a Paws::Athena::DeleteWorkGroupOutput instance
Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
GetNamedQuery
Each argument is described in detail in: Paws::Athena::GetNamedQuery
Returns: a Paws::Athena::GetNamedQueryOutput instance
Returns information about a single query. Requires that you have access to the workgroup in which the query was saved.
GetQueryExecution
Each argument is described in detail in: Paws::Athena::GetQueryExecution
Returns: a Paws::Athena::GetQueryExecutionOutput instance
Returns information about a single execution of a query if you have access to the workgroup in which the query ran. Each time a query executes, information about the query execution is saved with a unique ID.
GetQueryResults
Each argument is described in detail in: Paws::Athena::GetQueryResults
Returns: a Paws::Athena::GetQueryResultsOutput instance
Returns the results of a single query execution specified by QueryExecutionId if you have access to the workgroup in which the query ran. This request does not execute the query but returns results. Use StartQueryExecution to run a query.
GetWorkGroup
Each argument is described in detail in: Paws::Athena::GetWorkGroup
Returns: a Paws::Athena::GetWorkGroupOutput instance
Returns information about the workgroup with the specified name.
ListNamedQueries
Each argument is described in detail in: Paws::Athena::ListNamedQueries
Returns: a Paws::Athena::ListNamedQueriesOutput instance
Provides a list of available query IDs only for queries saved in the specified workgroup. Requires that you have access to the workgroup.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
ListQueryExecutions
Each argument is described in detail in: Paws::Athena::ListQueryExecutions
Returns: a Paws::Athena::ListQueryExecutionsOutput instance
Provides a list of available query execution IDs for the queries in the specified workgroup. Requires you to have access to the workgroup in which the queries ran.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
ListTagsForResource
Each argument is described in detail in: Paws::Athena::ListTagsForResource
Returns: a Paws::Athena::ListTagsForResourceOutput instance
Lists the tags associated with this workgroup.
ListWorkGroups
Each argument is described in detail in: Paws::Athena::ListWorkGroups
Returns: a Paws::Athena::ListWorkGroupsOutput instance
Lists available workgroups for the account.
StartQueryExecution
- QueryString => Str
- [ClientRequestToken => Str]
- [QueryExecutionContext => Paws::Athena::QueryExecutionContext]
- [ResultConfiguration => Paws::Athena::ResultConfiguration]
- [WorkGroup => Str]
Each argument is described in detail in: Paws::Athena::StartQueryExecution
Returns: a Paws::Athena::StartQueryExecutionOutput instance
Runs the SQL query statements contained in the Query. Requires you to have access to the workgroup in which the query ran.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
StopQueryExecution
Each argument is described in detail in: Paws::Athena::StopQueryExecution
Returns: a Paws::Athena::StopQueryExecutionOutput instance
Stops a query execution. Requires you to have access to the workgroup in which the query ran.
For code samples using the AWS SDK for Java, see Examples and Code Samples (http://docs.aws.amazon.com/athena/latest/ug/code-samples.html) in the Amazon Athena User Guide.
TagResource
- ResourceARN => Str
- Tags => ArrayRef[Paws::Athena::Tag]
Each argument is described in detail in: Paws::Athena::TagResource
Returns: a Paws::Athena::TagResourceOutput instance
Adds one or more tags to the resource, such as a workgroup. A tag is a label that you assign to an AWS Athena resource (a workgroup). Each tag consists of a key and an optional value, both of which you define. Tags enable you to categorize resources (workgroups) in Athena, for example, by purpose, owner, or environment. Use a consistent set of tag keys to make it easier to search and filter workgroups in your account. For best practices, see AWS Tagging Strategies (https://aws.amazon.com/answers/account-management/aws-tagging-strategies/). The key length is from 1 (minimum) to 128 (maximum) Unicode characters in UTF-8. The tag value length is from 0 (minimum) to 256 (maximum) Unicode characters in UTF-8. You can use letters and numbers representable in UTF-8, and the following characters: + - = . _ : / @. Tag keys and values are case-sensitive. Tag keys must be unique per resource. If you specify more than one, separate them by commas.
UntagResource
Each argument is described in detail in: Paws::Athena::UntagResource
Returns: a Paws::Athena::UntagResourceOutput instance
Removes one or more tags from the workgroup resource. Takes as an input a list of TagKey Strings separated by commas, and removes their tags at the same time.
UpdateWorkGroup
- WorkGroup => Str
- [ConfigurationUpdates => Paws::Athena::WorkGroupConfigurationUpdates]
- [Description => Str]
- [State => Str]
Each argument is described in detail in: Paws::Athena::UpdateWorkGroup
Returns: a Paws::Athena::UpdateWorkGroupOutput instance
Updates the workgroup with the specified name. The workgroup's name cannot be changed.
PAGINATORS
Paginator methods are helpers that repetively call methods that return partial results
GetAllQueryResults(sub { },QueryExecutionId => Str, [MaxResults => Int, NextToken => Str])
GetAllQueryResults(QueryExecutionId => Str, [MaxResults => Int, NextToken => Str])
If passed a sub as first parameter, it will call the sub for each element found in :
- ResultSet.Rows, passing the object as the first parameter, and the string 'ResultSet.Rows' as the second parameter If not, it will return a a Paws::Athena::GetQueryResultsOutput instance with all the params; from all the responses. Please take into account that this mode can potentially consume vasts ammounts of memory.
ListAllNamedQueries(sub { },[MaxResults => Int, NextToken => Str, WorkGroup => Str])
ListAllNamedQueries([MaxResults => Int, NextToken => Str, WorkGroup => Str])
If passed a sub as first parameter, it will call the sub for each element found in :
- NamedQueryIds, passing the object as the first parameter, and the string 'NamedQueryIds' as the second parameter If not, it will return a a Paws::Athena::ListNamedQueriesOutput instance with all the params; from all the responses. Please take into account that this mode can potentially consume vasts ammounts of memory.
ListAllQueryExecutions(sub { },[MaxResults => Int, NextToken => Str, WorkGroup => Str])
ListAllQueryExecutions([MaxResults => Int, NextToken => Str, WorkGroup => Str])
If passed a sub as first parameter, it will call the sub for each element found in :
- QueryExecutionIds, passing the object as the first parameter, and the string 'QueryExecutionIds' as the second parameter If not, it will return a a Paws::Athena::ListQueryExecutionsOutput instance with all the params; from all the responses. Please take into account that this mode can potentially consume vasts ammounts of memory.
SEE ALSO
This service class forms part of Paws
BUGS and CONTRIBUTIONS
The source code is located here: https://github.com/pplu/aws-sdk-perl
Please report bugs to: https://github.com/pplu/aws-sdk-perl/issues