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
| 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 |
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.
- Map Salesforce External Object Field to Amazon Athena Data Types
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
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
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.