Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Snap Pack

Date of Update

Snap Pack Version

Updates

Binary

435patches23780

Fixed an issue with the Binary Snaps that failed to build a data connection when connecting to the FTP server over FTPS protocol.

Data Automation

ELT

435patches23671

  • With Databricks Lakehouse Platform as the target CDW, you can now define your update expressions with the WHEN NOT MATCHED BY SOURCE clause besides other supported clauses and expression lists in the ELT Merge Into Snap.

Upgrading to this Release

...

  • For integrations that load from Google BigQuery to BigQuery, failures can occur if a source BIGNUMERIC column does not have precision and scale set and contains a value with precision larger than 76. This happens because when the precision and scale for a BIGNUMERIC column is not set in the source, AutoSync sets it to (76,38) when creating the target table. BigQuery can actually store a BIGNUMERIC value with a precision and scale of (76.76,38).
    Workaround: Set the precision and scale for BIGNUMERIC columns in the source to (76,38).

  • For integrations with Google BigQuery as a source or destination, the Filter columns data preview might not contain data, so there is no way to select the columns that you do not want to synchronize.
    Workaround: The issue is intermittent. Try re-creating the data pipeline.

  • Clarification to documented behavior: When using the Append load type for CSV files, if you upload a file containing content that was previously uploaded, the content is duplicated in the destination. This is because CSV files do not have primary keys to distinguish the data.

  • For efficiency and performance, AutoSync uses bulk load for Salesforce objects. The Salesforce Bulk API does not support all object types. Refer to the Salesforce discussion forum for more information.

Data Automation

Dot Releases

...

Snap Pack

...

Date of Update

...

Snap Pack Version

...

Updates

...

ELT

...

...

435patches23671

...

Enhancements

  • Enhanced the ELT Merge Into and ELT SCD2 Snaps to display detailed pipeline execution statistics about the data loaded to target tables on a Databricks Lakehouse Platform instance. In addition to the individual counts of rows inserted, updated, and deleted that the ELT Merge Into Snap covers, the ELT SCD2 Snap also reports the count of source rows rejected.

...