---
schema_version: "1"
id: 3fbe2e2340726b9b5781fa9a08a3559bcdb239ee63ad1c4f8054f83fb4e54c9a
title: Validate and Sync External Data Source Configured 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_ext_data_sync_database.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_ext_data_sync_database.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d539a267a62a51bd0c0e47d75f36f60f428bc12e999ceb477af1b5ee546efa7a
description: After you create an external data source for Amazon Athena, synchronize it to map its tables with external objects in your Salesforce org.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Validate and Sync External Data Source Configured for Amazon Athena

After you create an external data source for Amazon Athena, synchronize it to map its tables with external objects in your Salesforce org.

### 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:49.01960784313725%">
          <col style="width:50.98039215686274%">
        </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="d105288e74">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d105288e74 ">To create an external object from an external data
              source:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d105288e74 ">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. Open the external data source that you created for the Amazon Athena external system.
3. Click **Validate and Sync**.
4. Select the Amazon Athena database that contains the tables that you want to sync.
    
    You can see only the first 50 databases from Amazon Athena.
5. Select the tables, and click **Sync**.

![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 Make sure that the external object field names exactly match the table column names in Amazon Athena. Otherwise, queries to Amazon Athena cause a runtime error.

After the external object and its fields are created, you must provide additional configuration so that Salesforce can access Amazon Athena to run queries and respect settings configured by the AWS administrator. See [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.").

#### 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.")