Versions Compared

Old Version 27

changes.mady.by.user Lakshmi Manda

Saved on

compared with

New Version Current

changes.mady.by.user Lakshmi Manda

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
minLevel1
maxLevel2
absoluteUrltrue

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

Child pages (Children Display)

Prerequisites

None.

Supported Versions

This Snap Pack is tested against AlloyDB, PostgreSQL 14.

Snap Pack History

Excerpt
nameGoogle AlloyDB SPH

Release

Snap Pack Version

Date

Type

Updates

February 2024

436patches25696

Latest

The AlloyDB Execute Snap displays both the status and the message in the output when you call stored procedures.

Info

Behavior Change:

As part of 436patches25696, when you use a stored procedure in the AlloyBD Execute Snap, the Snap displays Message: Success and $UPDATE_COUNT=-1, 0, or 1 (based on the Snap Pack behavior) in the output.

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: