You are here:
Amazon Athena Connection
Sync Amazon Athena to Salesforce Data Pipelines by creating a remote connection.
Create the Connection
- On the Data Manager Connections tab, click New Connection.
- Click the name of the connector, and click Next.
- Enter the connector settings.
- To validate your settings and attempt to connect to the source, click Save & Test. If the connection fails, Salesforce Data Pipelines shows possible reasons.
Connection Settings
| Setting | Description |
|---|---|
| Connection Name | Use a name that lets you easily distinguish between different connections. |
| Developer Name | The developer 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 | Connection description. |
| Authetication Type | For standard authentication, enter Root. For AWS Identity Access Management (IAM) authentication, enter IAM. |
| AWS Access Key | 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 | 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 | For IAM authentication only, the ARN of the IAM role. You can find it on the IAM Role Setup in AWS. |
| AWS Region | Region name where your Amazon Athena data is hosted. Valid values are:
|
| Database | Name of the Amazon Athena database. |
| S3 Staging Directory | Folder in S3 where you want to store the results of queries. |
| Datasource | Name of the Amazon Athena data source to connect to. |
| Workgroup | For IAM authentication only, the name of the Amazon workgroup connected to the IAM role. |
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.
Did this article solve your issue?
Let us know so we can improve!
