Athena

AWS Athena is an interactive query service that allows you to analyze data in Amazon S3 using standard SQL.

Churned seamlessly integrates with AWS Athena as a data source. Connecting Athena to Churned enables real-time data synchronization, allowing you to gain insights into customer behavior and improve engagement strategies effectively.

How to connect AWS Athena to Churned

1. Log in to the Churned platform and navigate to the Integrations section.

2. Click on “New Integration” and select Athena from the list.

3. You will be prompted to enter the required credentials for Athena.

Required Credentials

To connect AWS Athena to Churned, you will need the following details:

• awsAccessKeyId - The access key ID associated with your AWS IAM user.

• awsSecretAccessKey - The secret key corresponding to the access key ID.

• regionName - The AWS region where your Athena instance is located (e.g., us-east-1).

• workgroup - The Athena workgroup you want to use for executing queries.

How to Retrieve These Credentials

Step 1: Create an IAM User with the Correct Permissions

1. Go to the AWS Management Console and navigate to the IAM (Identity and Access Management) service.

2. Click Users and then Add User.

3. Assign a name and select Programmatic access as the access type.

4. Click Next: Permissions and attach the following policies:

• AmazonAthenaFullAccess

• AmazonS3ReadOnlyAccess (if querying data stored in S3)

1. Click Next: Review, then Create User.

Step 2: Retrieve the Access Keys

1. After creating the user, go to the Security Credentials tab.

2. Click Create Access Key and Download .csv file to securely store the credentials.

3. Copy the Access Key ID and Secret Access Key for use in the integration form.

Step 3: Find Your Region Name

• Navigate to the AWS Athena console.

• In the top right corner, note the selected region (e.g., us-east-1, eu-west-2).

• Enter this value in the regionName field.

Step 4: Retrieve or Create a Workgroup

1. Open the AWS Athena Console.

2. Click on Workgroups in the left-hand menu.

3. Choose an existing workgroup or create a new one by clicking Create Workgroup.

4. Copy and enter the workgroup name in the workgroup field.

Final Steps

• Enter all retrieved values in the Churned integration form.

• Click Send to complete the integration.

• Once connected, notify the Churned team to synchronize data.

For more details, refer to the AWS Athena Documentation.