Skip to content

Connecting to Amazon Athena

To connect to Amazon Athena, select Amazon Athena from the Database dropdown on the connection tab.

Query caching

The Amazon Athena connection will reuse previously generated result data for up to a day. To discard a cached result set, select it in the recent queries menu in the header bar and click the trash icon. The reference to the stored result set will be discarded and a new query will be issued the next time the report or data view is refreshed.

Connection information

Your connection details

You will need to provide several pieces of information. You may need to retrieve this information from your system administrator.

Region

Enter the region code where your Athena service resides. The regions code can be found in the list of AWS Service Endpoints.

Catalog

Amazon Athena organizes tables into schemas/databases and lists them in catalogs. The data catalog can either be managed by Athena, or by AWS Glue in regions and clusters where AWS Glue has been implemented.

Enter the catalog you would like to use.

Database

Enter a catalog that exists within the catalog. Rational BI will download metadata for any tables and columns within the specified database.

Workgroup

Optionally, provide a workgroup name to execute queries within. If you do not specify a workgroup, the Athena default will be used.

S3 output location

The location of the query output can be specified in the form of a S3 path, such as s3://mycompany-athena/results.

If no S3 output location is specified, the workgroup default will be used.

Access key ID

Provide the access key ID of a valid AWS IAM user. The user must have sufficient privileges to execute queries through the AWS Athena API.

Secret access key

Enter the secret access key belonging to the provided access key.

Testing your configuration

You can test your configuration by pressing the Test Configuration button. Rational BI will attempt to make a connection to the remote database and will indicate if the connection was successful. If an error was reported, check that the supplied information is correct and and that the supplied user has sufficient privileges to access Amazon Athena through the API.

Saving your configuration

When the configuration is correct, press Save. The system will connect to the remote database and create the metadata schema with table and column information based on the tables and views visible to the configured user.

The dataset will be updated to reflect that the remote database is online, and the database connection is now ready for use.