Cassandra Snap Pack

Cassandra Snap Pack

This page is no longer maintained (Nov 12, 2025). For the most current information, go to https://docs.snaplogic.com/snaps/snaps-data/sp-cassandra/sp-cassandra-about.html.

On this Page

Overview

You can use the Cassandra Snap Pack to work with data in Apache Cassandra. 

Use Snaps in this Snap Pack to:

  • Execute a Cassandra Select.

  • Execute a Cassandra statement or query.

Supported Versions

This Snap Pack is tested against Cassandra versions 1.2, 2.0, and 3.0.

Known Issues

MultiExcerpt

Behavior change

The jOOQ upgrade for Cassandra Snap Pack done as part of 436patches25597 resulted in the following behavior changes:

  • Previously, when TTL (time to live) was queried using a Select statement without specifying it during data insertion or update, the Cassandra Snaps would display '0'. Now, they return 'null' in such cases.

  • Previously, the null values were stored as ‘0' in the INT datatype columns, now they are stored as 'null’.


See Also

Snap Pack History

Release  Snap Pack Version Date Type   Updates November 2025 main33142 Stable Updated and certified against the current SnapLogic Platform release. August 2025 main32088 Stable Updated and certified against the current SnapLogic Platform release. May 2025 main31019   Stable Updated and certified against the current SnapLogic Platform release. February 2025 main29887   Stable Updated and certified against the current SnapLogic Platform release. November 2024 main29029   Stable Updated and certified against the current SnapLogic Platform release. August 2024 main27765   Stable Updated and certified against the current Snaplogic Platform release. May 2024 main26341   Stable Updated and certified against the current SnapLogic Platform release. February 2024 436patches25597   - Upgraded the jOOQ library of the Cassandra Snap Pack from v3.9.1 to v3.17.x. This upgrade is currently NOT available with the latest distribution. However, you can still consume this patch through 436patches25597. This update is scheduled to be included in the latest distribution release on April 10, 2024, and will be a part of the stable distribution with the GA release on May 8. 2024. Behavior change: The jOOQ upgrade for Cassandra Snap Pack done as part of 436patches25597 resulted in the following behavior changes: Previously, when TTL (time to live) was queried using a Select statement without specifying it during data insertion or update, the Cassandra Snaps would display '0'. Now, they return 'null' in such cases. Previously, the null values were stored as ‘0' in the INT datatype columns, now they are stored as 'null’. February 2024 main25112   Stable Updated and certified against the current SnapLogic Platform release. November 2023 main23721   Stable Updated and certified against the current SnapLogic Platform release. August 2023 main22460   Stable The Cassandra - Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically. May 2023 main21015   Stable Upgraded with the latest SnapLogic Platform release. February 2023 main19844     Stable Upgraded with the latest SnapLogic Platform release. November 2022 main18944   Stable Upgraded with the latest SnapLogic Platform release. August 2022 main17386   Stable Upgraded with the latest SnapLogic Platform release. 4.29 main15993   Stable Upgraded with the latest SnapLogic Platform release. 4.28 main14627   Stable Upgraded with the latest SnapLogic Platform release. 4.27 main12833   Stable Upgraded with the latest SnapLogic Platform release. 4.26 main11181   Stable Upgraded with the latest SnapLogic Platform release. 4.25 main9554   Stable Upgraded with the latest SnapLogic Platform release. 4.24 main8556 Stable Enhanced the Cassandra - Select Snap to return only the fields (provided in the Output Fields) in the output schema (second output view), through a new checkbox Fetch Output Fields In Schema. If the Output Fields property is empty all the columns are visible. 4.23 main7430   Stable Upgraded with the latest SnapLogic Platform release. 4.22 main6403   Stable Introduces a new account type Cassandra SSL/TLS Database account. Enhances encryption by ensuring data is transferred securely.  Enhances both the account types to enable expressions for required fields to support dynamic account.  4.21 Patch 421patches6272   Latest Fixed the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected. 4.21 Patch 421patches6144   Latest Fixed the following issues with DB Snaps: The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive. Connection leaks occur during Pipeline execution. 4.21 Patch MULTIPLE8841   Latest Fixed the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. 4.21 snapsmrc542   Stable Extended support to Cassandra version 3.11.5. 4.20 snapsmrc535   Stable Upgraded with the latest SnapLogic Platform release. 4.19 snaprsmrc528   Stable Upgraded with the latest SnapLogic Platform release. 4.18 snapsmrc523   Stable Upgraded with the latest SnapLogic Platform release. 4.17 ALL7402   Latest Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. 4.17 snapsmrc515   Latest Fixed an issue with the Cassandra Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field. Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box. 4.16 Patch  db/cassandra6848   Latest Fixed an issue with the Cassandra Execute Snap wherein output documents were not produced on selecting the Pass through property. 4.16 snapsmrc508   Stable Upgraded with the latest SnapLogic Platform release. 4.15 Patch  db/cassandra6329    Latest Replaced Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings. 4.15 snapsmrc500   Stable Upgraded with the latest SnapLogic Platform release. 4.14 snapsmrc490   Stable Upgraded with the latest SnapLogic Platform release. 4.13 snapsmrc486   Stable Upgraded with the latest SnapLogic Platform release. 4.12 snapsmrc480   Stable Upgraded with the latest SnapLogic Platform release. 4.11 snapsmrc465   Stable Where clause property updated to support values containing upstream parameters and Pipeline parameters. 4.10 snapsmrc414   Stable Upgraded with the latest SnapLogic Platform release. 4.9 Patch cassandra3067   Latest Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap. 4.9 snapsmrc405   Stable Upgraded with the latest SnapLogic Platform release. 4.8 Patch cassandra2751 Potential fix for JDBC deadlock issue. 4.8 snapsmrc398   Stable Info tab added to accounts. Database accounts now invalidate connection pools if account properties are modified and login attempts fail. 4.7.0 Patch cassandra2197   Latest Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter. 4.7 snapsmrc382   Stable Upgraded with the latest SnapLogic Platform release. 4.6 cassandra1620   Stable Resolved an issue in the Cassandra Select Snap unexpectedly failing with a Failure: 0 error. Resolved an issue in the Cassandra Select Snap that caused unexpectedly failure for valid SQL queries. Resolved an an issue in the Cassandra Select Snap that caused correctly configured Snaps to fail while execution. 4.5.1 snapsmrc344   Stable Upgraded with the latest SnapLogic Platform release. 4.4.1 NA   Stable Upgraded with the latest SnapLogic Platform release. 4.4 NA   Stable Upgraded with the latest SnapLogic Platform release. 4.3.2 NA   Stable Resolved an issue with Execute and Select Snaps failing when querying table with user-defined types (UDT). Resolved an issue when ordering db column names using TreeMap versus HashMap caused Cassandra's use of emptyString fields to break.