Configure PostgreSQL Accounts

Overview

You must create PostgreSQL Accounts to connect to data sources that you want to use in your pipelines. You can configure your account from SnapLogic Platform using the Designer or Manager.

Snap-account compatibility

Snaps in the PostgreSQL Snap Pack work with different accounts per the following table.

Snaps PostgreSQL Account PostgreSQL Dynamic Account
PostgreSQL Bulk Load Tick Icon Tick Icon
PostgreSQL Bulk Upsert Tick Icon Tick Icon
PostgreSQL Delete Tick Icon Tick Icon
PostgreSQL Execute Tick Icon Tick Icon
PostgreSQL Insert Tick Icon Tick Icon
PostgreSQL Lookup Tick Icon Tick Icon
PostgreSQL Multi Execute Tick Icon Tick Icon
PostgreSQL Select Tick Icon Tick Icon
PostgreSQL Table List Tick Icon Tick Icon
PostgreSQL Update Tick Icon Tick Icon
PostgreSQL Vector Search Tick Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Password
  • Medium: Username, Password
  • Low: Hostname, Database name, Username, Password