---
schema_version: "1"
id: c4942d25aa1df656ca2f74958d3cccbac5f09bf46e8e62f14e30371a004a779d
title: Salesforce Connect SQL Adapter for Amazon Athena
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/athena_adapter_about.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.athena_adapter_about.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1a869e9944066d853f37cd16596f4427799c6253c5a873b81f1cb6035fdbf88d
description: Provide your users access to Amazon Athena’s capability to analyze data directly in Amazon Simple Storage Service (Amazon S3) and integrate AWS-hosted data in Salesforce applications.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Salesforce Connect SQL Adapter for Amazon Athena

Provide your users access to Amazon Athena’s capability to analyze data directly in Amazon Simple Storage Service (Amazon S3) and integrate AWS-hosted data in Salesforce applications.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic
            and Lightning Experience (not for high-data-volume external objects)</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: <strong>Developer</strong> Edition</p>
            <p style="margin-bottom:0;">Available for an extra cost in:
              <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions
            </p>
          </td>

        </tr>
      </tbody>
    </table>

Perform complex queries on large datasets and get fast query results using the Salesforce Connect SQL adapter for Amazon Athena. With the SQL adapter, take advantage of Amazon Athena’s capability to run queries against data directly in Amazon S3 without managing RDBMS infrastructure or ETL tools.

Amazon Athena is an interactive query service that makes it easy to query structured data stored in Amazon S3 using standard SQL. Use the Salesforce Connect SQL adapter for Amazon Athena to query data stored in Amazon S3 and combine it with the customer 360-degree view captured in Salesforce.

Amazon Athena provides additional data connectors that run as AWS Lambda functions and can query nearly any data source on AWS. However, one of the trade-offs is that DML operations such as insert, update, and delete aren’t supported on all the data sources. For more information, see [_Amazon Athena User Guide_: Running SQL queries using Amazon Athena](https://docs.aws.amazon.com/athena/latest/ug/querying-athena-tables.html).

- **[Map Salesforce External Object Field to Amazon Athena Data Types](https://help.salesforce.com/s/articleView?id=platform.athena_external_object_datatypes.htm&release=264.0.0&type=5)**  
    External object fields of Salesforce Connect SQL adapter for Amazon Athena can be mapped to columns with scalar types such as strings and numbers. External object fields can’t be mapped to columns containing complex or nested data types such as an array, map, or struct.
- **[Set Up Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_setup.htm&release=264.0.0&type=5)**  
    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.
- **[Manage Qualifiers for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_manage_qualifiers.htm&release=264.0.0&type=5)**  
    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.

#### See Also

- [Salesforce Connect](https://help.salesforce.com/s/articleView?id=platform.platform_connect_about.htm&release=264.0.0&type=5 "Salesforce Connect provides seamless integration of data across system boundaries by letting your users view, search, and modify data that’s stored outside your Salesforce org. For example, perhaps you have data that’s stored on premises in an enterprise resource planning (ERP) system. Instead of copying the data into your org, you can use external objects to access the data in real time via web service callouts.")
- [Set Up Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_setup.htm&release=264.0.0&type=5 "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.")
- [Manage Qualifiers for Salesforce Connect SQL Adapter for Amazon Athena](https://help.salesforce.com/s/articleView?id=platform.athena_manage_qualifiers.htm&release=264.0.0&type=5 "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.")