> ## Documentation Index
> Fetch the complete documentation index at: https://docs.usedatabrain.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Athena

> This guide will walk you through the steps to connect your Athena database to Databrain.

### Requirements:

* Active AWS account with **Athena** and **S3** access.
* Proper **IAM permissions** to access Athena and the related S3 buckets.
* A selected **Databrain Workspace** where this source will be added.

### Setup Guide:

1. **Ensure Athena and S3 Accessibility:**

   * Make sure your **Athena database** is active and queries can write results to the designated **S3 bucket**.
   * Ensure that both Athena and S3 are accessible using the credentials you plan to use with Databrain.
   * Your S3 bucket should be in a region supported by Athena (e.g., `us-east-1` is preferred).

2. **Grant Necessary Permissions:**

   You must assign the appropriate IAM policies to the user or role you're using. These should include:

   * **Access to Athena** for querying.
   * **Access to Glue Data Catalog**, if used.
   * **Access to S3** for reading/writing query results.

3. **Fill Up Connection Info:**

   Provide the following fields in Databrain to configure your Athena source:

   * **Destination Name**: A custom name to identify this Athena connection in Databrain.\
     *Example: `Athena Destination Spec`*

   * **S3 Region**: The AWS region where your Athena query result bucket is located.\
     *Example: `us-east-1`*

   * **S3 Access Key ID**: Your AWS Access Key ID for authentication.

   * **S3 Secret Access Key**: Your AWS Secret Access Key associated with the Access Key ID.

   * **Database**: The name of the Athena database you want to connect to.\
     *Example: `iceberg_db`*

   * **S3 Bucket Name**: The name of the S3 bucket where Athena stores query results.\
     *Example: `output-bucket-name`*

### Locating the Configuration Details in AWS

1. **Destination Name:**

   Choose any descriptive name to label your Athena connection in Databrain. This does not affect AWS resources.

2. **S3 Region:**

   * Log in to the AWS Management Console and open the **S3** service.
   * Select the bucket used by Athena for output.
   * Then, find the **Region** under the bucket’s **Properties** tab.

3. **S3 Access Key ID & Secret Access Key:**

   * Open the **IAM** console and select the desired IAM **User** or **Role**.
   * Then, go to the **Security Credentials** tab and create or retrieve **Access Keys** for use in Databrain.

4. **Database:**

   * Open the **Athena** service in the AWS console and select your desired database from the left sidebar (e.g., `iceberg_db`).

5. **S3 Bucket Name:**

   * In the **Athena console**, go to **Settings**.
   * Then, find the **Query result location** (S3 URI like `s3://your-bucket-name/path`).
   * Use the bucket name from this URI (e.g., `your-bucket-name`).