---
schema_version: "1"
id: 2d692160ff0b6c53fc3bddc865e41ddd9c015e5e9a76d36932a75b7c668698fe
title: Amazon Athena Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_amazon_athena.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_amazon_athena.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: aef4219f3dadd9b542f67fd21668901a1f13857711799b35d4dd981412c54e66
description: Sync Amazon Athena to CRM Analytics by creating a remote connection.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Amazon Athena Connection

Sync Amazon Athena to CRM Analytics by creating a remote connection.

## Create the Connection

1. On the Data Manager Connections tab, click **New Connection**.
2. Click the name of the connector, and click **Next**.
3. Enter the connector settings.
4. To validate your settings and attempt to connect to the source, click **Save & Test**. If the connection fails, CRM Analytics shows possible reasons.

## Connection Settings

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d61448e73">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d61448e76">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. Use a name that lets you easily distinguish between different
              connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The API name is used in your recipes to reference data extracted through
              this connection. The name can't include spaces. After you create the connection, you
              can’t change the developer name.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The description for the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Authentication Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The authentication type. Valid values include <code>Root</code>, for standard authentication,
              and <code>IAM</code>, for AWS Identity Access Management (IAM) authentication.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">AWS Access Key</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The access key associated with your AWS root account. You can find it on your AWS
              Management console in the Security Credentials Access Keys section.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">AWS Secret Key</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The secret key associated with your AWS root account. You can find it on your AWS
              Management console in the Security Credentials Access Keys section.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">AWS Role ARN</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required for IAM authentication. The ARN of the IAM role. You can find it on the IAM Role Setup in AWS.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">AWS Region</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">
              <p>Required. The region name where your Amazon Athena data is hosted. Valid values are: </p>
              <ul>
                <li>bahrain</li>
                <li>beijing</li>
                <li>capetown</li>
                <li>central</li>
                <li>frankfurt</li>
                <li>govcloudeast</li>
                <li>govcloudwest</li>
                <li>hongkong</li>
                <li>ireland</li>
                <li>jakarta</li>
                <li>london</li>
                <li>milan</li>
                <li>mumbai</li>
                <li>ningxia</li>
                <li>northerncalifornia</li>
                <li>northernvirginia</li>
                <li>ohio</li>
                <li>oregon</li>
                <li>osaka</li>
                <li>paris</li>
                <li>saopaulo</li>
                <li>seoul</li>
                <li>singapore</li>
                <li>stockholm</li>
                <li>sydney</li>
                <li>tokyo</li>
                <li>uae</li>
                <li>zurich</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Database</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The name of the Amazon Athena database.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">S3 Staging Directory</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. The folder in S3 where you want to store the results of queries.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Datasource</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required. Then name of the Amazon Athena data source to connect to.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e73 ">Workgroup</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d61448e76 ">Required for IAM authentication. The name of the Amazon workgroup connected to the IAM role.</td>

          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note For Root authentication, the connector uses `AwsRootKeys` for the AuthSchema value, so make sure to use the AWS root key values.

For granular access to AWS data, use IAM authentication, setting up IAM users and roles in AWS. For more information on AWS IAM, see [Getting Started with IAM](https://docs.aws.amazon.com/IAM/latest/UserGuide/getting-started.html) on AWS.

For more information, see [CData JDBC Driver for Amazon Athena](https://cdn.cdata.com/help/FKJ/jdbc/default.htm) and [AWS security credentials](https://docs.aws.amazon.com/IAM/latest/UserGuide/security-creds.html).

## Connection Considerations

When working with the Amazon Athena connector, keep these behaviors in mind.

- Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
- Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
- This connector can sync up to 10 million rows or up to 5 GB per job, whichever limit it reaches first.