---
schema_version: "1"
id: 2b249f887760e526a7bfbe5aeacd4c85dd9e515b5559db725e0d1afa0998cb74
title: Manage Qualifiers 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_manage_qualifiers.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_manage_qualifiers.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f0f7874591e47a1cbbb84fcab37cd8a0f9df80a731111658ee795f8c4d9ed871
description: 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.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Manage Qualifiers for Salesforce Connect SQL Adapter for Amazon Athena

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.

### 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>

When you query an Amazon Athena table, the data catalog and database that you configured determine the table location. To provide additional configuration, follow these steps.

1. From Setup, in the Quick Find box, enter External Data Sources, and then select **External Data Sources**.
2. Select and click the external data source to edit.
3. Under External Objects, select the synced external object to which you want to add qualifiers and click Manage Qualifiers.
    
    <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="d129619e108">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d129619e111">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d129619e108 ">
                  <samp class="parmname">Database</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d129619e111 ">Displays the configured Athena database that contains the
                  synced table for the corresponding external object.</td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d129619e111 ">
                  <p>Specify the column names that represent a unique key for
                    a row in the synced Amazon Athena table. The Salesforce
                    Connect SQL adapter uses these column values to build an
                    external ID for external object records in
                    Salesforce.</p>
                  <p style="margin-bottom:0;">Composite keys can be represented as a
                    comma-delimited list. For example, <code>orderId,productId</code>.</p>
                </td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d129619e111 ">
                  <p>Specify the name of the workgroup used by the Salesforce
                    Connect SQL adapter to make queries to Amazon Athena. The
                    primary workgroup is the default.</p>
                  <p>AWS administrators use
                    workgroups to control query access and costs. To respect
                    those settings, specify the <code>workgroup</code> option.</p>
                  <p style="margin-bottom:0;">If you want to
                    create a workgroup to isolate queries from different
                    workloads, see <a href="https://docs.aws.amazon.com/athena/latest/ug/workgroups.html" target="_blank">Using workgroups for running
                      queries</a>.</p>
                </td>

              </tr>
            </tbody>
          </table>
4. Save your changes.

#### See Also

- [_Amazon Athena User Guide_: How workgroups work](https://docs.aws.amazon.com/athena/latest/ug/user-created-workgroups.html)
- [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.")