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
| Available in: both Salesforce Classic and Lightning Experience (not for
high-data-volume external objects) |
|
Available in: Developer Edition
Available for an extra
cost in: Enterprise, Performance, and
Unlimited Editions
|
| User
Permissions Needed |
| To create and edit external data sources: |
Customize Application |
-
From Setup, in the Quick Find box, enter External Data
Sources, and then select External Data
Sources.
-
Click New External Data Source, or click
Edit to modify an existing external data
source.
-
Complete these fields.
| Field |
Description |
|
External Data Source
|
A user-friendly name for the external data source. The
label is displayed in the Salesforce user interface. |
|
Name
|
A unique identifier that’s used to refer to this external
data source definition through the API. |
|
Type
|
Select SQL. |
|
Provider
|
Select Amazon Athena. |
|
Data Catalog
|
The name of the AWS Glue Data Catalog where the target
database is registered.
In most cases, it’s the default
AwsDataCatalog
data source.
|
|
Named Credential
|
Enter the named credential URL that you defined for
Amazon Athena data source.
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.
|
|
Connection Timeout
|
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 120
seconds. |
|
Use Cached Results
|
Select to reuse the stored query results and accelerate
the performance of your repeat queries. |
|
Maximum Age for Cached
Results
|
Enter the maximum age for using the cached query results.
The valid range is 1–10,080 minutes. |
-
Save your changes.
Note Salesforce Connect SQL adapter for Amazon Athena doesn’t support writable external objects. The adapter only supports read operations on the queried data.