| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
We use some third-party subprocessors to deliver services to our SnapLogic customers. For updates and details about the subprocessors and purpose of processing, refer tohttps://www.snaplogic.com/privacy-subprocessors.
...
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.
...
Introduced the Amazon Athena Snap Pack with the following Snaps and Account:
Athena Bulk Load: Performs a bulk load operation from an external location to the target table.
Athena Query: Executes SQL queries on large datasets.
Athena Select: Executes a SELECT query on the Amazon Athena table.
Amazon Athena Account: Establishes a connection between Amazon Athena Snaps and Athena services.
Added the gRPC Client Snap that enables you to interact with a gRPC (Google Remote Procedure Call) server to invoke its services. Learn more.
Added Introduced the Oracle CDC Snap Pack with the following Snap and Account:
Oracle CDC Snap: Retrieves data from Oracle Database transaction logs. It performs Insert, Update, and Delete statements on a specific table within a specified date and time range.
Oracle CDC Account: Establishes a connection between the Oracle CDC Snap and Oracle CDC services.
...
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.
...