Tables and databases in Amazon Athena contain the metadata definitions for the underlying source data schema. To be able to make queries to Amazon Athena, use qualifiers to specify the key columns that identify records in the Amazon Athena data source.
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 |
When you query an Amazon Athena table, the data catalog and database that you configured determine the table location. To provide additional configuration, follow these steps.
- From Setup, in the Quick Find box, enter External Data Sources, and then select External Data Sources.
- Select and click the external data source to edit.
-
Under External Objects, select the synced external object to which you want to
add qualifiers and click Manage Qualifiers.
Field Description Database Displays the configured Athena database that contains the synced table for the corresponding external object. Key Column Names Specify the column names that represent a unique key for a row in the synced Amazon Athena table. The Salesforce Connect SQL adapter uses these column values to build an external ID for external object records in Salesforce.
Composite keys can be represented as a comma-delimited list. For example,
orderId,productId.Workgroup Specify the name of the workgroup used by the Salesforce Connect SQL adapter to make queries to Amazon Athena. The primary workgroup is the default.
AWS administrators use workgroups to control query access and costs. To respect those settings, specify the
workgroupoption.If you want to create a workgroup to isolate queries from different workloads, see Using workgroups for running queries.
- Save your changes.