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
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 an external object from an external data
source:
Customize Application
From Setup, in the Quick Find box, enter External Data
Sources, and then select External Data
Sources.
Open the external data source that you created for the Amazon Athena external
system.
Click Validate and Sync.
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.
Select the tables, and click Sync.
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.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
