Amazon Athena Connector
Intro
Amazon Athena is a serverless, interactive query service that lets you analyze big data in S3 using standard SQL. Use Domo's Amazon Athena connector to query data from your Athena instance. To learn more about the Amazon Athena API, visit their page (https://aws.amazon.com/documentation/athena/).
You connect to your Amazon Athena account in the Data Center. This topic discusses the fields and menus that are specific to the Amazon Athena connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Prerequisites
To connect to your Amazon Athena account and create a DataSet, you must have the following:
-
Your AWS access key.
-
Your AWS secret key.
-
The Amazon S3 location to which the query output is written (e.g. s3://aws-athena-query-results-1234-us-west-2/). You can find this by going to Settings in the Athena web console.
For information about obtaining AWS credentials, visit http://docs.aws.amazon.com/general/l...red-types.html.
Connecting to Your Amazon Athena Account
This section enumerates the options in the Credentials and Details panes in the Amazon Athena Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials Pane
This pane contains fields for entering credentials to connect to your Amazon Athena account. The following table describes what is needed for each field:
|
Field |
Description |
|---|---|
|
Access Key |
Enter your AWS access key. |
|
Secret Key |
Enter your AWS secret key. |
|
S3 Staging Directory |
Enter the S3 staging directory to which the query output will be written. For more information, see "Prerequisites," above. |
|
Region |
Select your AWS region. |
Once you have entered valid Amazon Athena credentials, you can use the same account any time you go to create a new Amazon Athena DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details Pane
This pane contains a number of options for entering your query and configuring the report.
|
Menu |
Description |
||
|---|---|---|---|
|
Report |
Select the Amazon Athena report you want to run. Currently only one report type is available.
|
||
|
Database Name |
Select the database you want to query. |
||
|
Table Name (Optional) |
Select the table in the database you want to query. |
||
|
Column Names |
Select all the columns you want to query. |
||
|
Query Helper |
Based on the selected columns in the Column Names option, the Query Helper will build a sample query for you. |
||
|
Query |
Enter the SQL query you want to execute (e.g. select * from table_name). |
||
|
Connection Timeout (Optional) |
Enter the maximum amount of time, in milliseconds, to make a successful connection to Athena before an attempt is terminated. Default value is 10000ms. |
||
|
Socket Timeout |
Enter the maximum amount of time, in milliseconds, to wait for a socket in order to send data to Athena. Default value is 10000ms. |
||
|
Maximum Error Retries |
The maximum number of retries that the JDBC client attempts to make a request to Athena. Default value is 10. |
Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.