Google AlloyDB Snap Pack

Owned by Kalpana Malladi, created
Last updated: Nov 14, 2024 by Amritesh Singh
3 min read

 

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

November 2024

main29029

Nov 13, 2024

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

main27765

Aug 21, 2024

Stable

Updated and certified against the current Snaplogic Platform release.

May 2024

437patches27416

Jul 29, 2024

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

Jul 10, 2024

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

May 30, 2024

-

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

May 8, 2024

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

Feb 14, 2024

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023

main23721

Nov 8, 2023

Stable

Updated and certified against the current SnapLogic Platform release.

August 2023

main22460

Aug 16, 2023

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

May 10, 2023

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023

main19844

Feb 9, 2023

Stable

Upgraded with the latest SnapLogic Platform release.

November 2022

main18944

Nov 10, 2022

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

Sep 30, 2022

Latest

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

4.30Patches

430patches17841

Sep 16, 2022

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:

Related Links

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.