---
schema_version: "1"
id: 0191d844297f95e23301c49a6482eba5862984dbe12ba2ab278314dba594a1ac
title: Create an External Data Source for 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_add_external_data_source.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_add_external_data_source.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0235c8a59fea2c4b5a871c9b908d1d2406fcc7f7b12d1ae609d412f62910fc3f
description: Connect your Salesforce org to access Amazon Athena’s interactive query capabilities.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Create an External Data Source for Salesforce Connect SQL Adapter for Amazon Athena

Connect your Salesforce org to access Amazon Athena’s interactive query capabilities.

### 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="d153500e74">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e74 ">To create and edit external data sources:</td>

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

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

1. From Setup, in the Quick Find box, enter External Data Sources, and then select **External Data Sources**.
2. Click **New External Data Source**, or click **Edit** to modify an existing external data source.
3. Complete these fields.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:25%">
              <col style="width:75%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d153500e139">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d153500e142">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">External Data Source</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">A user-friendly name for the external data source. The
                  label is displayed in the Salesforce user interface.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Name</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">A unique identifier that’s used to refer to this external
                  data source definition through the API.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Type</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">Select <strong class="uicontrol">SQL</strong>.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Provider</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">Select <strong class="uicontrol">Amazon Athena</strong>.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Data Catalog</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">
                  <p>The name of the AWS Glue Data Catalog where the target
                    database is registered.</p>
                  <p style="margin-bottom:0;">In most cases, it’s the default
                    <code>AwsDataCatalog</code>
                    data source.
                  </p>
                </td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Named Credential</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">
                  <p>Enter the named credential URL that you defined for
                    Amazon Athena data source.</p>
                  <p style="margin-bottom:0;">You can skip the Authentication
                    section for the external data source. To access the
                    Amazon Athena external system, Salesforce Connect uses
                    the authentication settings that are defined in the
                    named credential.</p>
                </td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Connection Timeout</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">Number of seconds to wait for a response from the Amazon
                  Athena external system before timing out. By default, the
                  value is set to the maximum of <span id="athena_add_external_data_source__field_connection_timeout_max"><a name="athena_add_external_data_source__field_connection_timeout_max"><!-- --></a>120</span>
                  seconds.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Use Cached Results</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">Select to reuse the stored query results and accelerate
                  the performance of your repeat queries.</td>

              </tr>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e139 ">
                  <samp class="parmname">Maximum Age for Cached
                    Results</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d153500e142 ">Enter the maximum age for using the cached query results.
                  The valid range is 1–10,080 minutes.</td>

              </tr>
            </tbody>
          </table>
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png)
    
    Note Salesforce Connect SQL adapter for Amazon Athena doesn’t support writable external objects. The adapter only supports read operations on the queried data.
4. Save your changes.

#### See Also

- [Work with External Data Sources](https://help.salesforce.com/s/articleView?id=platform.external_data_sources.htm&release=264.0.0&type=5 "An external data source specifies how to access an external system. Salesforce Connect uses external data sources to access data that's stored outside your Salesforce organization. Files Connect uses external data sources to access third-party content systems. External data sources have associated external objects, which your users and the Lightning platform use to interact with the external data and content.")
- [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.")