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.

• 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. 

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.

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.

Fixed the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends.

Extended support to Cassandra version 3.11.5.

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

• 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.

Fixed an issue with the Cassandra Execute Snap wherein output documents were not produced on selecting the Pass through property.

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.

snapsmrc486

snapsmrc480

Where clause property updated to support values containing upstream parameters and Pipeline parameters.

snapsmrc414

Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap.

Potential fix for JDBC deadlock issue.

snapsmrc398

• Info tab added to accounts.
• Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.

snapsmrc382

• 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.

snapsmrc344

• 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.