Set Up Salesforce Connect SQL Adapter for Amazon Athena

Provide users easy access to data stored in Amazon S3 so that they can build custom applications that combine the power of the Salesforce and AWS clouds.

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
To create and edit external objects: Customize Application
To view named credentials: View Setup and Configuration
To create, edit, or delete named credentials: Manage Named Credentials or Customize Application
To create and edit custom fields: Customize Application
To edit permission sets and user profiles: Manage Profiles and Permission Sets
To edit another user’s authentication settings for external systems: Manage Users

Before you begin, review the basics of Amazon Athena setup and access in Amazon Athena User Guide.

To know more about identity-based AWS Identity and Access Management (IAM) policies to restrict access to Athena operations, see Identity and access management in Athena.