Skip to end of banner
Go to start of banner

Google AlloyDB Snap Pack

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 37 Current »

In this article

Overview

Google AlloyDB is a fully managed PostgresSQL-compatible database service that you can use for all your database workloads. You can use Snaps in this Snap Pack to connect to your AlloyDB database for reading and writing objects. Use Snaps in this Snap Pack to:

  • Lookup records in the target table and returns a selected set of fields.

  • Fetch data from a database.

  • Execute SQL statements to delete, update, or insert data into a specified table.

Articles in this section

Prerequisites

None.

Supported Versions

  • This Snap Pack is tested against AlloyDB, PostgreSQL 14.

  • PostgreSQL JDBC driver version 42.7.2. Learn more about the JDBC driver upgrade.

  • The Google AlloyDB Snap Pack is bundled with v42.7.2 (Java 8) JDBC driver as the default JDBC driver. Learn more.

Snap Pack History

Release

Snap Pack Version

Date

Type

Updates

August 2024

main27765

Stable

Updated and certified against the current Snaplogic Platform release.

May 2024

437patches27416

Latest

Fixed an issue with the AlloyDB Bulk Load Snap that caused incorrect or invalid binary data to be inserted when the column was of Binary type.

May 2024

437patches27172

Latest

  • Added the AlloyDB - Vector Search Snap to enable advanced vector-based queries using the SELECT statement.

  • Upgraded the JDBC driver from v42.4.2 to v42.7.2 (Java 8). This upgrade will be part of the Stable release (GA) on August 14, 2024. The 42.7.2 JDBC driver (default driver) is now bundled with the Google AlloyDB Snap Pack. Learn more.

May 2024

4postgresupgrade26570

-

Upgraded the JDBC driver from v42.4.2 to v42.7.2 (Java 8). This upgrade will be part of the latest release on July 10, 2024, and the Stable release (GA) on August 14, 2024.
The 42.7.2 JDBC driver (default driver) is now bundled with the AlloyDB Snap Pack. Learn more.

May 2024

main26341

Stable

Updated the Delete Condition (Truncates a Table if empty) field in the AlloyDB Delete Snap to Delete condition (deletes all records from a table if left blank) to indicate that all entries will be deleted from the table when this field is blank, but no truncate operation is performed.

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 AlloyDB 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

The AlloyDB Insert Snap now creates the target table only from the table metadata of the second input view when the following conditions are met:

  • The Create table if not present checkbox is selected.

  • The target table does not exist.

  • The table metadata is provided in the second input view.

September 2022

430patches18149

Latest

The AlloyDB Select and AlloyDB Execute Snaps now read NaN values in Numeric columns.

4.30Patches

430patches17841

Latest

Introduced the Google AlloyDB Snap Pack— a fully managed PostgresSQL-compatible database service that you can use for all your database workloads. This Snap Pack offers the following Snaps:

  • No labels