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
Child pages (Children Display)
Prerequisites
None.
Supported Versions
This Snap Pack is tested against AlloyDB, PostgreSQL 14.
Snap Pack History
Excerpt
name
Google AlloyDB SPH
Release
Snap Pack Version
Date
Type
Updates
May 2024
437patches27172
Latest
Added the AlloyDB - Vector Search Snap to enable advanced vector-based queries using the SELECT statement.
The JDBC driver for the Google AlloyDB Snap Pack has been upgraded from v42.4.2 to v42.7.2 (Java 8). This upgrade will be part of the GA release on August 14, 2024 (Stable release). As part of this upgrade, the 42.7.2 JDBC driver is bundled with the AlloyDB Snap Pack as the default JDBC driver. Learn more about the behavior changes caused by the driver upgrade.
May 2024
4postgresupgrade26570
-
The JDBC driver for the Google AlloyDB Snap Pack has been upgraded from v42.4.2 to v42.7.2 (Java 8). This upgrade will be part of the GA release on August 14, 2024 (Stable release). As part of this upgrade, the 42.7.2 JDBC driver is bundled with the AlloyDB Snap Pack as the default JDBC driver. Learn more about the behavior changes caused by the driver upgrade.
May 2024
main26341
Stable
Updated the Delete Condition (Truncates a Table if empty) field in the AlloyDB DeleteSnap 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.
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:
