| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
The REST Snap Pack from the Core Snap Pack will be deprecated. We recommend that you migrate to the HTTP Client Snap for your REST integration needs. Contact support@snaplogic.com, if you require assistance in migrating the existing pipelines from REST Snaps to HTTP Client Snap.
...
Amazon Athena Snap Pack:
Athena Bulk Load:
Choosing the Overwrite option for the If table exists field can delete the Athena table and its associated S3 objects when the Snap execution starts. Use this option cautiously to prevent data loss.
Athena Select:
ARRAY, STRUCT, and MAP are not supported in SELECT queries. If used, they can result in incorrect values in the output documents.
This Snap can fail with a connection error if the account is configured with an IAM role, and, Role ARN.
This Snap uses the Athena JDBC driver to retrieve data. When using a Cross-account IAM role, the JDBC connection expires based on the role's duration. Large datasets requiring more time than this duration are not supported.
CSE_KMS encryption is not supported because of an issue in the Athena JDBC driver.
Workaround: Use the Athena Query Snap with a SELECT query.
The second output view of this Snap cannot connect directly to the second input view of Athena Bulk Load Snap because Athena does not provide complete table metadata for all data types.
Query execution can fail on a table created with ORC files in LZO compression because of an Athena service defect.
Athena Query
ARRAY, STRUCT, and MAP are not supported in SELECT queries. If used, it can result in incorrect values in the output documents.
Query execution can fail on a table created with ORC files in LZO compression because of an Athena service defect.
When the Teradata FastLoad Snap pauses, both the target and error tables get locked.
Workaround: You must manually drop these tables before retrying the fast-load job.
Deprecated
The ForEach and TaskExecute Snaps are deprecated. If your existing pipelines use these Snaps, we recommend that you replace them with the Pipeline Execute Snap.
...