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.