Athena

Athena

To create an Athena dataset, follow steps 1 and 2 in Creating SQL Dataset .

The following figure shows the Product Selection page.



The Data Connect page for choosing your dataset type is displayed.

1.      From the RDBMS options, select Athena.

The following figure shows RDBMS options.



2.      Create an Athena Dataset page is displayed.



3.      Enter a suitable Name for the Dataset.

4.      In the Connection Parameter section, enter the following details.

-- AWS Access Key (Used to log in and access AWS services like Amazon Athena.)
-- AWS Secret Key (Used to log in and access AWS services like Amazon Athena.)
-- AWS Region (Location with data centers to run AWS services.)
-- S3 Staging Directory (Temporary spot in S3 to store data before using it)
-- Database (Organize tables for querying data stored in S3.)
     

5.      Click Test Connection. If the parameters are accurate, the message "Database Connection Successful" will be displayed in green.

6.      After a successful connection, click on ‘Select Queries’.

7.      From the Select Queries dropdown, select the required queries and click Done.

8.      To add a custom query to select data from the tables, click on Add Custom Query. Add Custom Query screen is displayed. Refer to Adding a Custom Query.

9.      Click Create. The Athena dataset is created in Rubiscape and is available for use in your workbooks and workflows.



   Notes:

  1.    After entering the database name, all available queries within it will be displayed.
  2.    You can select multiple queries from the available options in the Select Queries dropdown.
  3.    Currently, there is read-only access without any write access, meaning you cannot use the template table node after the Athena dataset.
  4.    No Data Definition Language (DDL) commands are allowed in the custom query.
  5.    You can only use SELECT queries; other types of queries are not allowed.