Configure Amazon Athena for Kompass integration

This topic describes how to set up Athena for integration with Kompass. Kompass queries Athena for required data.

Prerequisites:

Details of the crawler-cfn.yml file from the CUR S3 bucket, either the path to crawler-cfn.yml or the actual downloaded file. AWS makes this information available 24 hours after creating a new CUR (or editing an existing one) with Amazon Athena integration.

Example: s3://<your-bucket>/cloudformation/crawler-cfn.yml

To configure Athena:

1. Use AWS to create the CloudFormation stack:

   1. From the AWS Management Console, open CloudFormation.

   2. Choose Create Stack > With new resources (standard).

   3. In the Specify template section, do one of the following:

      • Select Amazon S3 URL, and paste the URL to your crawler-cfn.yml file, for example: https://<your-bucket>.s3.amazonaws.com/cloudformation/crawler-cfn

      • Select Upload a template file, and upload the actual file from the S3 CUR bucket to use as a template.

   4. Click Next.

   5. Enter a name for the stack.

      We recommend a name like Zesty-CUR-Athena-Setup.

   6. Click Next.

   7. In the Configure stack options screen, review and acknowledge the IAM role capabilities, then click Next.

   8. In the Review and create screen, click Submit.

      A database will be created, with a name similar to athenacurcfn.

      Leave this tab open. You will need it for a future step.

2. Set up a new S3 bucket for the Athena query results:

   1. From AWS, open a new tab to the S3 Management Console.

   2. Create the bucket:

      1. Click Create bucket.

         The Create Bucket page is displayed.

      2. Use the same region used for the CUR bucket and enter a name like <account-id>-aws-athena-query-results-<region>

      3. Click Create bucket.

3. Configure Athena:

   1. From AWS, open the Amazon Athena dashboard.

   2. Select Query editor.

   3. In the Data section, select the database with the name of the S3 bucket created in the previous step.

   4. Choose Settings > Manage.

      The Manage settings window is displayed.

   5. Click Browse, select the relevant data set, then click Choose.

      The location of the query result displayed is the S3 bucket you just created. It should look like this: s3://<account-id>-aws-athena-query-results-<region>

   6. Click Save.

Athena is configured for integration with Kompass.

Next step

If you are onboarding an AWS Management account, return to Onboard an AWS Management account for Kompass.