In this article
Overview
You can use this account type to connect Google AlloyDB Snaps with data sources that use AlloyDB account.
Prerequisites
Valid Hostname, Database and User credentials.
Limitations and Known Issues
None.
Account Settings
Asterisk ( * ): Indicates a mandatory field.
Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the fieldset.
Remove icon ( ): Indicates that you can remove fields from the fieldset.
Field Name | Field Type | Description | |
---|---|---|---|
Label* Default Value: None | String | Specify a unique label for the account. | |
Account properties | The account information required to create a connection to the PostgreSQL database. | ||
Hostname Default Value: None | String/Expression | Specify the AlloyDB server's address. | |
Port Number Default Value: 5432 | Integer | Specify the port number of the database server to which you need to connect. | |
Database name Default Value: N/A | String/Expression | Specify the name of the database to which you need to connect. | |
Username Default Value: N/A | String/Expression | Specify the username that is allowed to connect to the database. | |
Password Default Value: N/A | String/Expression | Specify the password used to connect to the data source. | |
JDBC JARs | Use this field set to list the JDBC jar files that must be loaded for the account to work. | ||
JDBC Driver Default Value: N/A | String | Specify the JDBC driver that must be loaded for the account to work. By default, AlloyDB uses the latest jar file. | |
JDBC Driver Class Default Value: org.postgresql.Driver | String | The JDBC driver class that you want to use with the account. | |
Configure SSH Tunnel Default Value: Deselected | Checkbox | Select this checkbox to allow the Snap to create an SSH tunnel for connecting the Snaplex to the AlloyDB server. After the operation is completed, the tunnel is closed. If you select true, you must provide the configuration details of the SSH tunnel. | |
SSH Auth Mode Default Value: Password | String/Expression | Select an option to specify the mode for authenticating the user on the SSH tunnel. The available options are:
Do not enable expression in this field. If you enable expression then the other fields that are based on the expression might not be available. | |
SSH Hostname Default Value: N/A | String/Expression | Specify either the IP address or the domain name of the SSH server to which you want to connect. or use an expression for this field. | |
SSH Username Default Value: N/A | String/Expression | Specify the SSH username for connecting to the SSH tunnel. | |
SSH Password Default Value: N/A | String/Expression | Specify the password for the specified SSH username for connecting to the SSH tunnel. This field is required if SSH Auth Mode is Password. | |
SSH Port Default Value: 22 | Integer/Expression | Specify the SSH port to connect to the PostgreSQL Server. Ensure that there are no port conflicts. | |
Advanced properties | Advanced properties associated with the PostgreSQL account type. | ||
Auto commit Default value: Selected | Checkbox | Select this check box to commit batches as soon as they are executed. If the Snap fails, only the batch being executed at that moment is rolled back. Deselect the check box to commit Snap execution output only after all the batches are executed. If the Snap fails, the entire transaction is rolled back unless the Snap finds invalid input data before it sends the insert request to the server and routes the error documents to the Error view. | |
Batch size* Default Value: 50 | Integer | Specify the number of statements to execute at a time.
| |
Fetch size* Default Value: 100 | Integer | Specify the number of rows to fetch at a time when executing a query. | |
Max pool size* Default Value: 50 | Integer | Specify the maximum number of connections a pool must maintain at a time. | |
Max life time* Default value: 30 | Integer | Specify the maximum lifetime of a connection in the pool. Ensure that the value you enter is a few seconds shorter than any database or infrastructure-imposed connection time limit. A value of 0 indicates an infinite lifetime, subject to the Idle Timeout value. An in-use connection is never retired. Connections are removed only after they are closed. | |
Idle Timeout* Default value: 5 | Integer | Specify the maximum amount of time a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool. | |
Checkout timeout* Default Value: 10000 | Integer | Specify the number of milliseconds to wait for a connection to be available when the pool is exhausted. If you provide 0, the Snap waits infinitely until the connection is available. Therefore, we recommend you not to specify 0 for Checkout Timeout. | |
URL properties | Use this field set to define URL properties to use if any. | ||
URL Property Name
| String | Specify a name for the URL property if any. | |
URL Property Value Default Value: N/A | String | Specify a value for the URL property name. |
Snap Pack History
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
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 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 |
| 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:
|
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: |