---
schema_version: "1"
id: cdf36f1a766f3ebffbe9919e731e1780ead44aab3c7266cad7dbaeb239811b78
title: Define a Legacy Named Credential 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_named_credentials.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_named_credentials.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ad61793dba02d98fe8563d5327c8ff4acaaa8761ebfb136e3394fef04f4abf77
description: Create a legacy named credential that specifies the URL of a callout endpoint as an Amazon Athena endpoint and provides the required authentication parameters.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Define a Legacy Named Credential for Salesforce Connect SQL Adapter for Amazon Athena

Create a legacy named credential that specifies the URL of a callout endpoint as an Amazon Athena endpoint and provides the required authentication parameters.

### 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</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: all editions</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="d141767e60">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e60 ">To view named credentials:</td>

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

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

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

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

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_important.png)

Important In Winter ’23, Salesforce introduced an improved named credential that is extensible, customizable, and more secure. We strongly recommend that you use this preferred credential instead of legacy named credentials, which are no longer updated or enhanced. For information on extensible, customizable named credentials, see [Named Credentials Schema](https://help.salesforce.com/s/articleView?id=xcloud.nc_parts_of_nc.htm&type=5&language=en_US).

1. From Setup, in the Quick Find box, enter Named Credentials, and then select **Named Credentials**.
2. To create a legacy named credential, click **New Legacy** from the dropdown menu.
3. Complete the 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="d141767e138">Field</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d141767e141">Description</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e138 ">
                  <samp class="parmname">Label</samp>
                </td>

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e141 ">A user-friendly name for the named credential that’s
                  displayed in the Salesforce user interface.</td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e141 ">A unique identifier that’s used to refer to this named
                  credential from callout definition while creating an
                  external data source for Amazon Athena.</td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e141 ">
                  <p>The URL of the Amazon Athena endpoint.</p>
                  <p>The sample
                    format of the URL is <code>https://athena.<em>REGION</em>.amazonaws.com</code>.</p>
                  <p style="margin-bottom:0;">For
                    example, if the AWS region is
                    <kbd>us-west-2</kbd>, the URL is <code>https://athena.us-west-2.amazonaws.com</code>.
                  </p>
                </td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e141 ">To designate one user account on the Amazon Athena
                  external system for all your Salesforce org users, select
                  <strong class="uicontrol">Named Principal</strong>.
                </td>

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

                <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d141767e141 ">
                  <p>Select <strong class="uicontrol">AWS Signature Version 4</strong>,
                    and then complete these fields.</p>
                  <ol>
                    <li><samp class="parmname">AWS Access Key ID</samp><strong>:</strong> The
                      first part of the access key used to sign
                      programmatic requests to AWS.</li>
                    <li><samp class="parmname">AWS Secret Access Key</samp><strong>:</strong>
                      The second part of the access key used to sign
                      programmatic requests to AWS.</li>
                    <li><samp class="parmname">AWS Region</samp><strong>:</strong> The AWS
                      region name for the named credential’s endpoint. For
                      example, <kbd>us-west-2</kbd>.</li>
                    <li><samp class="parmname">AWS Service</samp><strong>:</strong> The AWS
                      utility to access. For example,
                      <kbd>athena</kbd>.
                    </li>
                  </ol>
                </td>

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

#### See Also

- [AWS Account and Access Keys](https://docs.aws.amazon.com/powershell/latest/userguide/pstools-appendix-sign-up.html)
- [Named Credentials](https://help.salesforce.com/s/articleView?id=xcloud.named_credentials_about.htm&type=5&language=en_US)
- [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.")