Salesforce Docs Portal

Amazon Athena Connection

Sync Amazon Athena to CRM Analytics by creating a remote connection.

Create the Connection

  1. On the Data Manager Connections tab, click New Connection.
  2. Click the name of the connector, and click Next.
  3. Enter the connector settings.
  4. To validate your settings and attempt to connect to the source, click Save & Test. If the connection fails, CRM Analytics shows possible reasons.

Connection Settings

Setting Description
Connection Name Required. Use a name that lets you easily distinguish between different connections.
Developer Name Required. The API name is used in your recipes to reference data extracted through this connection. The name can't include spaces. After you create the connection, you can’t change the developer name.
Description Required. The description for the connection.
Authentication Type Required. The authentication type. Valid values include Root, for standard authentication, and IAM, for AWS Identity Access Management (IAM) authentication.
AWS Access Key Required. The access key associated with your AWS root account. You can find it on your AWS Management console in the Security Credentials Access Keys section.
AWS Secret Key Required. The secret key associated with your AWS root account. You can find it on your AWS Management console in the Security Credentials Access Keys section.
AWS Role ARN Required for IAM authentication. The ARN of the IAM role. You can find it on the IAM Role Setup in AWS.
AWS Region

Required. The region name where your Amazon Athena data is hosted. Valid values are:

  • bahrain
  • beijing
  • capetown
  • central
  • frankfurt
  • govcloudeast
  • govcloudwest
  • hongkong
  • ireland
  • jakarta
  • london
  • milan
  • mumbai
  • ningxia
  • northerncalifornia
  • northernvirginia
  • ohio
  • oregon
  • osaka
  • paris
  • saopaulo
  • seoul
  • singapore
  • stockholm
  • sydney
  • tokyo
  • uae
  • zurich
Database Required. The name of the Amazon Athena database.
S3 Staging Directory Required. The folder in S3 where you want to store the results of queries.
Datasource Required. Then name of the Amazon Athena data source to connect to.
Workgroup Required for IAM authentication. The name of the Amazon workgroup connected to the IAM role.
Note
Note For Root authentication, the connector uses AwsRootKeys for the AuthSchema value, so make sure to use the AWS root key values.

For granular access to AWS data, use IAM authentication, setting up IAM users and roles in AWS. For more information on AWS IAM, see Getting Started with IAM on AWS.

For more information, see CData JDBC Driver for Amazon Athena and AWS security credentials.

Connection Considerations

When working with the Amazon Athena connector, keep these behaviors in mind.

  • Connected object names must start with a letter and contain only letters, digits, or underscores. Object names can’t end with an underscore.
  • Only field names with combinations of alphanumeric, dot, underscore, or dash characters are supported. If a connector includes field names that contain other characters, such as spaces or brackets, the sync fails.
  • This connector can sync up to 10 million rows or up to 5 GB per job, whichever limit it reaches first.