Athena
Last updated
Last updated
Kubemq athena target connector allows services using kubemq server to access aws athena service.
The following required to run the aws-athena target connector:
kubemq cluster
aws account with athena active service
kubemq-source deployment
athena target connector configuration properties:
Example:
list all catalogs
List Catalogs:
Example:
list all databases
List Databases:
Example:
create a query request return execution_id.
Query:
Example:
get Query result by execution_id that return from Query result.
Get Query Result:
Example:
Properties Key
Required
Description
Example
aws_key
yes
aws key
aws key supplied by aws
aws_secret_key
yes
aws secret key
aws secret key supplied by aws
region
yes
region
aws region
token
no
aws token ("default" empty string
aws token
Metadata Key
Required
Description
Possible values
method
yes
type of method
"list_data_catalogs"
Metadata Key
Required
Description
Possible values
method
yes
type of method
"list_databases"
catalog
yes
aws athena catalog
"string"
Metadata Key
Required
Description
Possible values
method
yes
type of method
"query"
catalog
yes
aws athena catalog
"string"
db
yes
aws athena db name
"string"
output_location
yes
aws athena folder location
"string"
query
yes
aws query to execute
"query"
Metadata Key
Required
Description
Possible values
method
yes
type of method
"get_query_result"
execution_id
yes
aws executionID that returned from query
"string"