To connect your AWS Athena to Kaldea, you will need Admin access to AWS account

Pre-requisite

  • You must be using Athena with workgroups. → “WORKGROUP_NAME
    • The workgroup must specifies the S3 bucket that will store the output of Athena queries.
    • For more information, refer to the official documentation on using workgroups.
    • You can also use the default workgroup named “primarywith query output location.
  • You must have an output bucket registered to the workgroup. → “OUTPUT_BUCKET_ARN

Configuring IAM users for Kaldea

There are 2 categories of IAM credentials that need to be prepared for Kaldea :

  • kaldea-system
  • kaldea-user

Create an IAM user: kaldea-system

This IAM user will be used by the Kaldea’s system to retrieve the query history.

kaldea-system requires the following permissions :

Create an IAM user: kaldea-user

This IAM user is to be used for all users as default.

kaldea-user requires the following permissions :

Prepare Access Key and Secret pairs

For each IAM user, you must have the ACCESS_KEY_ID & SECRET_ACCESS_KEY ready.

Integrating within Kaldea Interface

Given the above steps are completed, you now have :

  • The name of the workgroup workgroup_name
  • The AWS region in use for Athena AWS_REGION
  • Access Key Pair for AWS IAM user kaldea-system
  • Access Key Pair for AWS IAM user kaldea-user
  • ARN for AWS IAM role kaldea-system
  • ARN for AWS IAM role kaldea-user

Choose Athena among the data source options.

Choose Athena among the data source options.

Insert system credentials for the Kaldea’s system access.

Insert system credentials for the Kaldea’s system access.

Insert the default credential for all Kaldea users.

Insert the default credential for all Kaldea users.