---
schema_version: "1"
id: f35e3ebc58a6ac0b147dcd3bdf7be34d3dd658479fcc3a8b9f30371924214aa4
title: Set Up Salesforce Connect SQL Adapter for Amazon Athena
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/athena_setup.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_setup.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2776e75acf40e329f3d1ebb6cf5035e11dbf6686521a8a41224f0051a4dd1d5c
description: Provide users easy access to data stored in Amazon S3 so that they can build custom applications that combine the power of the Salesforce and AWS clouds.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Set Up Salesforce Connect SQL Adapter for Amazon Athena

Provide users easy access to data stored in Amazon S3 so that they can build custom applications that combine the power of the Salesforce and AWS clouds.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
        <colgroup>
          <col>
        </colgroup>
        <tbody>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience (not for
              high-data-volume external objects)</td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">
              <p>Available in: <strong>Developer</strong> Edition</p>
              <p style="margin-bottom:0;">Available for an extra
                cost in: <strong>Enterprise</strong>, <strong>Performance</strong>, and
                <strong>Unlimited</strong> Editions
              </p>
            </td>

          </tr>
        </tbody>
      </table> <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d81849e74">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To create and edit external data sources:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Customize Application</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To create and edit external objects:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Customize Application</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To view named credentials:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">View Setup and Configuration</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To create, edit, or delete named credentials:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Manage Named Credentials or Customize Application</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To create and edit custom fields:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Customize Application</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To edit permission sets and user profiles:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Manage Profiles and Permission Sets</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">To edit another user’s authentication settings for external
              systems:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d81849e74 ">Manage Users</td>

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

Before you begin, review the basics of Amazon Athena setup and access in [Amazon Athena User Guide](https://docs.aws.amazon.com/athena/latest/ug/what-is.html).

To know more about identity-based AWS Identity and Access Management (IAM) policies to restrict access to Athena operations, see [Identity and access management in Athena](https://docs.aws.amazon.com/athena/latest/ug/security-iam-athena.html).

- **[Define a Named Credential for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_named_credentials_external_credentials.htm&release=264.0.0&type=5)**  
    Create a named credential that specifies the endpoint URL for Amazon Athena and an external credential to provide the required authentication parameters.
- **[Define a Legacy Named Credential for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_named_credentials.htm&release=264.0.0&type=5)**  
    Create a legacy named credential that specifies the URL of a callout endpoint as an Amazon Athena endpoint and provides the required authentication parameters.
- **[Create an External Data Source for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_add_external_data_source.htm&release=264.0.0&type=5)**  
    Connect your Salesforce org to access Amazon Athena’s interactive query capabilities.
- **[Validate and Sync External Data Source Configured for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_ext_data_sync_database.htm&release=264.0.0&type=5)**  
    After you create an external data source for Amazon Athena, synchronize it to map its tables with external objects in your Salesforce org.

#### See Also

- [Salesforce Connect](https://help.salesforce.com/s/articleView?id=platform.platform_connect_about.htm&release=264.0.0&type=5 "Salesforce Connect provides seamless integration of data across system boundaries by letting your users view, search, and modify data that’s stored outside your Salesforce org. For example, perhaps you have data that’s stored on premises in an enterprise resource planning (ERP) system. Instead of copying the data into your org, you can use external objects to access the data in real time via web service callouts.")
- [Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_adapter_about.htm&release=264.0.0&type=5 "Provide your users access to Amazon Athena’s capability to analyze data directly in Amazon Simple Storage Service (Amazon S3) and integrate AWS-hosted data in Salesforce applications.")
- [Manage Qualifiers for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_manage_qualifiers.htm&release=264.0.0&type=5 "Tables and databases in Amazon Athena contain the metadata definitions for the underlying source data schema. To be able to make queries to Amazon Athena, use qualifiers to specify the key columns that identify records in the Amazon Athena data source.")