Contents:
Limitations and Requirements
NOTE: During normal selection or import of an entire table, you may encounter an error indicating a problem with a specific column. Since some tables require filtering based on a particular column, data from them can only be ingested using custom SQL statements. In this case, the problematic column can be used as a filter in the WHERE clause of a custom SQL statement to ingest the table. NOTE: For filtering date columns, this connection type supports a set of literal functions on dates. You can use these to reduce the volume of data extracted from the database using a custom SQL query. For more information, see the
pg_dateliteralfunctions.htm
page in the driver documentation for this connection type.
- Supports authentication using AWS key and secret.
Create Connection
via Trifacta application
When you create the connection, please review the following properties and specify them accordingly:
Connection Property | Description |
---|---|
AWS Region | The hosting region for your Amazon Web Services resources. For more information, see https://cdn.cdata.com/help/FKG/jdbc/RSBAmazonAthena_p_AWSRegion.htm |
S3 Staging Directory | Specifies the location in your S3 bucket where Amazon Athena can store the results of a query. |
Database | The name of the Amazon Athena database. |
Connect String Options | The following are the connect string options passed to the JDBC driver by default: Timeout=0;CleanQueryResults=true;
|
Access Key ID | AWS account access key. This value is accessible from your AWS security credentials page. |
Secret access key | AWS account secret key. This value is accessible from your AWS security credentials page. |
Default Column Data Type Inference | Leave this value as Enabled . |
For more information, see the driver documentation https://cdn.cdata.com/help/FKG/jdbc/ .
via API
Depending on your product edition, you can create connections of this type. Key information:
"vendor": "amazon_athena", "vendorName": "Amazon Athena", "type": "jdbc"
For more information, see
Trifacta API Reference docs: Enterprise | Professional | PremiumData Type Conversions
For more information, see the driver documentation https://cdn.cdata.com/help/FKG/jdbc/ .
This page has no comments.