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
| Available in: both Salesforce Classic and Lightning Experience |
| Available in: all editions |
| User Permissions Needed | |
|---|---|
| To view named credentials: | View Setup and Configuration |
| To create, edit, or delete named credentials: | Customize Applications |
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.
- From Setup, in the Quick Find box, enter Named Credentials, and then select Named Credentials.
- To create a legacy named credential, click New Legacy from the dropdown menu.
-
Complete the fields.
Field Description Label A user-friendly name for the named credential that’s displayed in the Salesforce user interface. Name A unique identifier that’s used to refer to this named credential from callout definition while creating an external data source for Amazon Athena. URL The URL of the Amazon Athena endpoint.
The sample format of the URL is
https://athena.REGION.amazonaws.com.For example, if the AWS region is us-west-2, the URL is
https://athena.us-west-2.amazonaws.com.Identity Type To designate one user account on the Amazon Athena external system for all your Salesforce org users, select Named Principal. Authentication Protocol Select AWS Signature Version 4, and then complete these fields.
- AWS Access Key ID: The first part of the access key used to sign programmatic requests to AWS.
- AWS Secret Access Key: The second part of the access key used to sign programmatic requests to AWS.
- AWS Region: The AWS region name for the named credential’s endpoint. For example, us-west-2.
- AWS Service: The AWS utility to access. For example, athena.
- Save your changes.