Google AlloyDB Snap Pack

 

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.

Snap Pack History

Release

Snap Pack Version

Date

Type

Updates

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: