Loading
The online Trailblazer Community becomes read-only Oct 30, 2026Read More
Important Advisory: iOS Update Impacting CG Mobile ApplicationRead More
Extend Salesforce with Clicks, Not Code
Create an External Data Source for Salesforce Connect SQL Adapter for Amazon Athena

You are here:

  1. Salesforce Help
  2. Docs
  3. Extend Salesforce with Clicks, Not Code

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
  1. From Setup, in the Quick Find box, enter External Data Sources, and then select External Data Sources.
  2. Click New External Data Source, or click Edit to modify an existing external data source.
  3. 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.
    Note
    Note Salesforce Connect SQL adapter for Amazon Athena doesn’t support writable external objects. The adapter only supports read operations on the queried data.
  4. Save your changes.

See Also

 
Loading
Salesforce Help | Article