Client library for Amazon Athena
npm install --save @datafire/amazonaws_athena
let amazonaws_athena = require('@datafire/amazonaws_athena').create({
accessKeyId: "",
secretAccessKey: "",
region: ""
});
.then(data => {
console.log(data);
});
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.
amazonaws_athena.BatchGetNamedQuery({
"NamedQueryIds": null
}, context)
- input
object
- NamedQueryIds required
- items NamedQueryId
- NamedQueryIds required
- output BatchGetNamedQueryOutput
amazonaws_athena.BatchGetQueryExecution({
"QueryExecutionIds": null
}, context)
- input
object
- QueryExecutionIds required
- items QueryExecutionId
- QueryExecutionIds required
- output BatchGetQueryExecutionOutput
amazonaws_athena.CreateDataCatalog({
"Name": null,
"Type": null
}, context)
- input
object
- Description
- Name required
- Parameters
- Tags
- items Tag
- Type required
- output CreateDataCatalogOutput
amazonaws_athena.CreateNamedQuery({
"Name": null,
"Database": null,
"QueryString": null
}, context)
- input
object
- ClientRequestToken
- Database required
- Description
- Name required
- QueryString required
- WorkGroup
- output CreateNamedQueryOutput
amazonaws_athena.CreateWorkGroup({
"Name": null
}, context)
- input
object
- Configuration
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RequesterPaysEnabled
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- Description
- Name required
- Tags
- items Tag
- Configuration
- output CreateWorkGroupOutput
amazonaws_athena.DeleteDataCatalog({
"Name": null
}, context)
- input
object
- Name required
- output DeleteDataCatalogOutput
amazonaws_athena.DeleteNamedQuery({
"NamedQueryId": null
}, context)
- input
object
- NamedQueryId required
- output DeleteNamedQueryOutput
amazonaws_athena.DeleteWorkGroup({
"WorkGroup": null
}, context)
- input
object
- RecursiveDeleteOption
- WorkGroup required
- output DeleteWorkGroupOutput
amazonaws_athena.GetDataCatalog({
"Name": null
}, context)
- input
object
- Name required
- output GetDataCatalogOutput
amazonaws_athena.GetDatabase({
"CatalogName": null,
"DatabaseName": null
}, context)
- input
object
- CatalogName required
- DatabaseName required
- output GetDatabaseOutput
amazonaws_athena.GetNamedQuery({
"NamedQueryId": null
}, context)
- input
object
- NamedQueryId required
- output GetNamedQueryOutput
amazonaws_athena.GetQueryExecution({
"QueryExecutionId": null
}, context)
- input
object
- QueryExecutionId required
- output GetQueryExecutionOutput
amazonaws_athena.GetQueryResults({
"QueryExecutionId": null
}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- QueryExecutionId required
- MaxResults
- output GetQueryResultsOutput
amazonaws_athena.GetTableMetadata({
"CatalogName": null,
"DatabaseName": null,
"TableName": null
}, context)
- input
object
- CatalogName required
- DatabaseName required
- TableName required
- output GetTableMetadataOutput
amazonaws_athena.GetWorkGroup({
"WorkGroup": null
}, context)
- input
object
- WorkGroup required
- output GetWorkGroupOutput
amazonaws_athena.ListDataCatalogs({}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- MaxResults
- output ListDataCatalogsOutput
amazonaws_athena.ListDatabases({
"CatalogName": null
}, context)
- input
object
- MaxResults
string
- NextToken
string
- CatalogName required
- MaxResults
- NextToken
- MaxResults
- output ListDatabasesOutput
amazonaws_athena.ListNamedQueries({}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- WorkGroup
- MaxResults
- output ListNamedQueriesOutput
amazonaws_athena.ListQueryExecutions({}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- WorkGroup
- MaxResults
- output ListQueryExecutionsOutput
amazonaws_athena.ListTableMetadata({
"CatalogName": null,
"DatabaseName": null
}, context)
- input
object
- MaxResults
string
- NextToken
string
- CatalogName required
- DatabaseName required
- Expression
- MaxResults
- NextToken
- MaxResults
- output ListTableMetadataOutput
amazonaws_athena.ListTagsForResource({
"ResourceARN": null
}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- ResourceARN required
- MaxResults
- output ListTagsForResourceOutput
amazonaws_athena.ListWorkGroups({}, context)
- input
object
- MaxResults
string
- NextToken
string
- MaxResults
- NextToken
- MaxResults
- output ListWorkGroupsOutput
amazonaws_athena.StartQueryExecution({
"QueryString": null
}, context)
- input
object
- ClientRequestToken
- QueryExecutionContext
- Catalog
- Database
- QueryString required
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- WorkGroup
- output StartQueryExecutionOutput
amazonaws_athena.StopQueryExecution({
"QueryExecutionId": null
}, context)
- input
object
- QueryExecutionId required
- output StopQueryExecutionOutput
amazonaws_athena.TagResource({
"ResourceARN": null,
"Tags": null
}, context)
- input
object
- ResourceARN required
- Tags required
- items Tag
- output TagResourceOutput
amazonaws_athena.UntagResource({
"ResourceARN": null,
"TagKeys": null
}, context)
- input
object
- ResourceARN required
- TagKeys required
- items TagKey
- output UntagResourceOutput
amazonaws_athena.UpdateDataCatalog({
"Name": null,
"Type": null
}, context)
- input
object
- Description
- Name required
- Parameters
- Type required
- output UpdateDataCatalogOutput
amazonaws_athena.UpdateWorkGroup({
"WorkGroup": null
}, context)
- input
object
- ConfigurationUpdates
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RemoveBytesScannedCutoffPerQuery
- RequesterPaysEnabled
- ResultConfigurationUpdates
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- RemoveEncryptionConfiguration
- RemoveOutputLocation
- EncryptionConfiguration
- Description
- State
- WorkGroup required
- ConfigurationUpdates
- output UpdateWorkGroupOutput
- AmazonResourceName
string
- BatchGetNamedQueryInput
object
- NamedQueryIds required
- items NamedQueryId
- NamedQueryIds required
- BatchGetNamedQueryOutput
object
- NamedQueries
- items NamedQuery
- UnprocessedNamedQueryIds
- items UnprocessedNamedQueryId
- NamedQueries
- BatchGetQueryExecutionInput
object
- QueryExecutionIds required
- items QueryExecutionId
- QueryExecutionIds required
- BatchGetQueryExecutionOutput
object
- QueryExecutions
- items QueryExecution
- UnprocessedQueryExecutionIds
- QueryExecutions
- Boolean
boolean
- BoxedBoolean
boolean
- BytesScannedCutoffValue
integer
- CatalogNameString
string
- Column
object
: Contains metadata for a column in a table.- Comment
- Name required
- Type
- ColumnInfo
object
: Information about the columns in a query execution result.- CaseSensitive
- CatalogName
- Label
- Name required
- Nullable
- Precision
- Scale
- SchemaName
- TableName
- Type required
- ColumnInfoList
array
- items ColumnInfo
- ColumnList
array
- items Column
- ColumnNullable
string
(values: NOT_NULL, NULLABLE, UNKNOWN)
- CommentString
string
- CreateDataCatalogInput
object
- Description
- Name required
- Parameters
- Tags
- items Tag
- Type required
- CreateDataCatalogOutput
object
- CreateNamedQueryInput
object
- ClientRequestToken
- Database required
- Description
- Name required
- QueryString required
- WorkGroup
- CreateNamedQueryOutput
object
- NamedQueryId
- CreateWorkGroupInput
object
- Configuration
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RequesterPaysEnabled
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- Description
- Name required
- Tags
- items Tag
- Configuration
- CreateWorkGroupOutput
object
- DataCatalog
object
: Contains information about a data catalog in an AWS account.- Description
- Name required
- Parameters
- Type required
- DataCatalogSummary
object
: The summary information for the data catalog, which includes its name and type.- CatalogName
- Type
- DataCatalogSummaryList
array
- items DataCatalogSummary
- DataCatalogType
string
(values: LAMBDA, GLUE, HIVE)
- Database
object
: Contains metadata information for a database in a data catalog.- Description
- Name required
- Parameters
- DatabaseList
array
- items Database
- DatabaseString
string
- Date
string
- Datum
object
: A piece of data (a field in the table).- VarCharValue
- DeleteDataCatalogInput
object
- Name required
- DeleteDataCatalogOutput
object
- DeleteNamedQueryInput
object
- NamedQueryId required
- DeleteNamedQueryOutput
object
- DeleteWorkGroupInput
object
- RecursiveDeleteOption
- WorkGroup required
- DeleteWorkGroupOutput
object
- DescriptionString
string
- EncryptionConfiguration
object
: If query results are encrypted in Amazon S3, indicates the encryption option used (for example,SSE-KMS
orCSE-KMS
) and key information.- EncryptionOption required
- KmsKey
- EncryptionOption
string
(values: SSE_S3, SSE_KMS, CSE_KMS)
- ErrorCode
string
: The error code returned when the query execution failed to process, or when the processing request for the named query failed.
- ErrorMessage
string
- ExpressionString
string
- GetDataCatalogInput
object
- Name required
- GetDataCatalogOutput
object
- DataCatalog
- Description
- Name required
- Parameters
- Type required
- DataCatalog
- GetDatabaseInput
object
- CatalogName required
- DatabaseName required
- GetDatabaseOutput
object
- Database
- Description
- Name required
- Parameters
- Database
- GetNamedQueryInput
object
- NamedQueryId required
- GetNamedQueryOutput
object
- NamedQuery
- Database required
- Description
- Name required
- NamedQueryId
- QueryString required
- WorkGroup
- NamedQuery
- GetQueryExecutionInput
object
- QueryExecutionId required
- GetQueryExecutionOutput
object
- QueryExecution
- Query
- QueryExecutionContext
- Catalog
- Database
- QueryExecutionId
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- StatementType
- Statistics
- DataManifestLocation
- DataScannedInBytes
- EngineExecutionTimeInMillis
- QueryPlanningTimeInMillis
- QueryQueueTimeInMillis
- ServiceProcessingTimeInMillis
- TotalExecutionTimeInMillis
- Status
- CompletionDateTime
- State
- StateChangeReason
- SubmissionDateTime
- WorkGroup
- QueryExecution
- GetQueryResultsInput
object
- MaxResults
- NextToken
- QueryExecutionId required
- GetQueryResultsOutput
object
- NextToken
- ResultSet
- ResultSetMetadata
- ColumnInfo
- items ColumnInfo
- ColumnInfo
- Rows
- items Row
- ResultSetMetadata
- UpdateCount
- GetTableMetadataInput
object
- CatalogName required
- DatabaseName required
- TableName required
- GetTableMetadataOutput
object
- GetWorkGroupInput
object
- WorkGroup required
- GetWorkGroupOutput
object
- WorkGroup
- Configuration
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RequesterPaysEnabled
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- CreationTime
- Description
- Name required
- State
- Configuration
- WorkGroup
- IdempotencyToken
string
- Integer
integer
- KeyString
string
- ListDataCatalogsInput
object
- MaxResults
- NextToken
- ListDataCatalogsOutput
object
- DataCatalogsSummary
- items DataCatalogSummary
- NextToken
- DataCatalogsSummary
- ListDatabasesInput
object
- CatalogName required
- MaxResults
- NextToken
- ListDatabasesOutput
object
- DatabaseList
- items Database
- NextToken
- DatabaseList
- ListNamedQueriesInput
object
- MaxResults
- NextToken
- WorkGroup
- ListNamedQueriesOutput
object
- NamedQueryIds
- items NamedQueryId
- NextToken
- NamedQueryIds
- ListQueryExecutionsInput
object
- MaxResults
- NextToken
- WorkGroup
- ListQueryExecutionsOutput
object
- NextToken
- QueryExecutionIds
- items QueryExecutionId
- ListTableMetadataInput
object
- CatalogName required
- DatabaseName required
- Expression
- MaxResults
- NextToken
- ListTableMetadataOutput
object
- NextToken
- TableMetadataList
- items TableMetadata
- ListTagsForResourceInput
object
- MaxResults
- NextToken
- ResourceARN required
- ListTagsForResourceOutput
object
- NextToken
- Tags
- items Tag
- ListWorkGroupsInput
object
- MaxResults
- NextToken
- ListWorkGroupsOutput
object
- NextToken
- WorkGroups
- items WorkGroupSummary
- Long
integer
- MaxDataCatalogsCount
integer
- MaxDatabasesCount
integer
- MaxNamedQueriesCount
integer
- MaxQueryExecutionsCount
integer
- MaxQueryResults
integer
- MaxTableMetadataCount
integer
- MaxTagsCount
integer
- MaxWorkGroupsCount
integer
- NameString
string
- NamedQuery
object
: A query, whereQueryString
is the list of SQL query statements that comprise the query.- Database required
- Description
- Name required
- NamedQueryId
- QueryString required
- WorkGroup
- NamedQueryId
string
- NamedQueryIdList
array
- items NamedQueryId
- NamedQueryList
array
- items NamedQuery
- ParametersMap
object
- ParametersMapValue
string
- QueryExecution
object
: Information about a single instance of a query execution.- Query
- QueryExecutionContext
- Catalog
- Database
- QueryExecutionId
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- StatementType
- Statistics
- DataManifestLocation
- DataScannedInBytes
- EngineExecutionTimeInMillis
- QueryPlanningTimeInMillis
- QueryQueueTimeInMillis
- ServiceProcessingTimeInMillis
- TotalExecutionTimeInMillis
- Status
- CompletionDateTime
- State
- StateChangeReason
- SubmissionDateTime
- WorkGroup
- QueryExecutionContext
object
: The database and data catalog context in which the query execution occurs.- Catalog
- Database
- QueryExecutionId
string
- QueryExecutionIdList
array
- items QueryExecutionId
- QueryExecutionList
array
- items QueryExecution
- QueryExecutionState
string
(values: QUEUED, RUNNING, SUCCEEDED, FAILED, CANCELLED)
- QueryExecutionStatistics
object
: The amount of data scanned during the query execution and the amount of time that it took to execute, and the type of statement that was run.- DataManifestLocation
- DataScannedInBytes
- EngineExecutionTimeInMillis
- QueryPlanningTimeInMillis
- QueryQueueTimeInMillis
- ServiceProcessingTimeInMillis
- TotalExecutionTimeInMillis
- QueryExecutionStatus
object
: The completion date, current state, submission time, and state change reason (if applicable) for the query execution.- CompletionDateTime
- State
- StateChangeReason
- SubmissionDateTime
- QueryString
string
- ResultConfiguration
object
: The location in Amazon S3 where query results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the workgroup settings.- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- ResultConfigurationUpdates
object
: The information about the updates in the query results, such as output location and encryption configuration for the query results.- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- RemoveEncryptionConfiguration
- RemoveOutputLocation
- EncryptionConfiguration
- ResultSet
object
: The metadata and rows that comprise a query result set. The metadata describes the column structure and data types. To return aResultSet
object, use GetQueryResults.- ResultSetMetadata
- ColumnInfo
- items ColumnInfo
- ColumnInfo
- Rows
- items Row
- ResultSetMetadata
- ResultSetMetadata
object
: The metadata that describes the column structure and data types of a table of query results. To return aResultSetMetadata
object, use GetQueryResults.- ColumnInfo
- items ColumnInfo
- ColumnInfo
- Row
object
: The rows that comprise a query result table.- Data
- items Datum
- Data
- RowList
array
- items Row
- StartQueryExecutionInput
object
- ClientRequestToken
- QueryExecutionContext
- Catalog
- Database
- QueryString required
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- WorkGroup
- StartQueryExecutionOutput
object
- QueryExecutionId
- StatementType
string
(values: DDL, DML, UTILITY)
- StopQueryExecutionInput
object
- QueryExecutionId required
- StopQueryExecutionOutput
object
- String
string
- TableMetadata
object
: Contains metadata for a table.
- TableMetadataList
array
- items TableMetadata
- TableTypeString
string
- Tag
object
: A label that you assign to a resource. In Athena, a resource can be a workgroup or data catalog. Each tag consists of a key and an optional value, both of which you define. For example, you can use tags to categorize Athena workgroups or data catalogs by purpose, owner, or environment. Use a consistent set of tag keys to make it easier to search and filter workgroups or data catalogs in your account. For best practices, see Tagging Best Practices. Tag keys can be from 1 to 128 UTF-8 Unicode characters, and tag values can be from 0 to 256 UTF-8 Unicode characters. Tags 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 tag, separate them by commas.- Key
- Value
- TagKey
string
- TagKeyList
array
- items TagKey
- TagList
array
- items Tag
- TagResourceInput
object
- ResourceARN required
- Tags required
- items Tag
- TagResourceOutput
object
- TagValue
string
- Timestamp
string
- Token
string
- TypeString
string
- UnprocessedNamedQueryId
object
: Information about a named query ID that could not be processed.- ErrorCode
- ErrorMessage
- NamedQueryId
- UnprocessedNamedQueryIdList
array
- items UnprocessedNamedQueryId
- UnprocessedQueryExecutionId
object
: Describes a query execution that failed to process.- ErrorCode
- ErrorMessage
- QueryExecutionId
- UnprocessedQueryExecutionIdList
array
- UntagResourceInput
object
- ResourceARN required
- TagKeys required
- items TagKey
- UntagResourceOutput
object
- UpdateDataCatalogInput
object
- Description
- Name required
- Parameters
- Type required
- UpdateDataCatalogOutput
object
- UpdateWorkGroupInput
object
- ConfigurationUpdates
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RemoveBytesScannedCutoffPerQuery
- RequesterPaysEnabled
- ResultConfigurationUpdates
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- RemoveEncryptionConfiguration
- RemoveOutputLocation
- EncryptionConfiguration
- Description
- State
- WorkGroup required
- ConfigurationUpdates
- UpdateWorkGroupOutput
object
- WorkGroup
object
: A workgroup, which contains a name, description, creation time, state, and other configuration, listed under WorkGroup$Configuration. Each workgroup enables you to isolate queries for you or your group of users from other queries in the same account, to configure the query results location and the encryption configuration (known as workgroup settings), to enable sending query metrics to Amazon CloudWatch, and to establish per-query data usage control limits for all queries in a workgroup. The workgroup settings override is specified in EnforceWorkGroupConfiguration (true/false) in the WorkGroupConfiguration. See WorkGroupConfiguration$EnforceWorkGroupConfiguration.- Configuration
- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RequesterPaysEnabled
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- CreationTime
- Description
- Name required
- State
- Configuration
- WorkGroupConfiguration
object
: The configuration of the workgroup, which includes the location in Amazon S3 where query results are stored, the encryption option, if any, used for query results, whether the Amazon CloudWatch Metrics are enabled for the workgroup and whether workgroup settings override query settings, and the data usage limits for the amount of data scanned per query or per workgroup. The workgroup settings override is specified in EnforceWorkGroupConfiguration (true/false) in the WorkGroupConfiguration. See WorkGroupConfiguration$EnforceWorkGroupConfiguration.- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RequesterPaysEnabled
- ResultConfiguration
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- EncryptionConfiguration
- WorkGroupConfigurationUpdates
object
: The configuration information that will be updated for this workgroup, which includes the location in Amazon S3 where query results are stored, the encryption option, if any, used for query results, whether the Amazon CloudWatch Metrics are enabled for the workgroup, whether the workgroup settings override the client-side settings, and the data usage limit for the amount of bytes scanned per query, if it is specified.- BytesScannedCutoffPerQuery
- EnforceWorkGroupConfiguration
- PublishCloudWatchMetricsEnabled
- RemoveBytesScannedCutoffPerQuery
- RequesterPaysEnabled
- ResultConfigurationUpdates
- EncryptionConfiguration
- EncryptionOption required
- KmsKey
- OutputLocation
- RemoveEncryptionConfiguration
- RemoveOutputLocation
- EncryptionConfiguration
- WorkGroupDescriptionString
string
- WorkGroupName
string
- WorkGroupState
string
(values: ENABLED, DISABLED)
- WorkGroupSummary
object
: The summary information for the workgroup, which includes its name, state, description, and the date and time it was created.- CreationTime
- Description
- Name
- State
- WorkGroupsList
array
- items WorkGroupSummary
- datumList
array
- items Datum
- datumString
string