athena JDBC

AWS Athena JDBC allows you to connect to Amazon Athena using the JDBC driver, enabling seamless querying of data stored in Amazon S3.

This integration is essential for running SQL queries from BI tools, applications, or analytics platforms that support JDBC connections.

Churned integrates with AWS Athena JDBC to facilitate real-time data access and analysis, allowing you to leverage Athena’s serverless architecture for business insights.

How to Connect Athena JBDC Table to Churned

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

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

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

Required Credentials

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

• awsAccessKeyId - The AWS access key ID associated with your 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 used for query execution.

How to Retrieve These Credentials

Step 1: Create an IAM User with Proper Permissions

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

2. Click Users → Add User.

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

4. Click Next: Permissions, then attach the following policies:

• AmazonAthenaFullAccess

• AmazonS3ReadOnlyAccess (if querying data stored in S3)

1. Click Next: Review, then Create User.

Step 2: Retrieve Access Keys

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

2. Click Create Access Key and 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

• Open the AWS Athena console.

• The region is displayed in the top-right corner (e.g., us-east-1).

• Enter this value in the regionName field.

Step 4: Retrieve or Create a Workgroup

1. Navigate to the AWS Athena Console.

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

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

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

Final Steps

• Enter all retrieved values into 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 JDBC Documentation.