Salesforce Connect SQL Adapter for Amazon Athena

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.