- Trifacta® Enterprise Edition
- Trifacta Professional Edition
- Trifacta Premium
Amazon Athena is a service that enables a data analyst to perform interactive queries in the AWS public cloud on data stored in Amazon Simple Storage Service (S3) For more information, see https://aws.amazon.com/athena/ .
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.
- For more information, please consult the CData driver documentation for the specific table.
- For more information on using custom SQL, see Create Dataset with SQL.
- Supports authentication using AWS key and secret.
via Trifacta application
When you create the connection, please review the following properties and specify them accordingly:
The hosting region for your Amazon Web Services resources.
For more information, see http://cdn.cdata.com/help/FKF/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.
The name of the Amazon Athena database.
|Connect String Options|
The following are the connect string options passed to the JDBC driver by default:
|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 |
For more information, see the driver documentation http://cdn.cdata.com/help/FKF/jdbc/Connection.htm .
Depending on your product edition, you can create connections of this type. Key information:
For more information, seeTrifacta SaaS API Reference docs: Premium | Standard
Data Type Conversions
For more information, see the driver documentation http://cdn.cdata.com/help/FKF/jdbc/default.htm.
This page has no comments.