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.
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
Excerpt
name
Google AlloyDB SPH
Release
Snap Pack Version
Date
Type
Updates
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.
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 GA latest release on August 14July 10, 2024(, and the Stable release(GA) . As part of this upgrade, the on August 14, 2024. The 42.7.2 JDBC driver (default driver) is now bundled with the AlloyDB Snap Packas the default JDBC driver. Learn moreabout 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:
