PostgreSQL Connector

{
  "destinationId": "<string>",
  "destinationSchema": "<string>",
  "replicationFrequency": "<string>",
  "onSchemaUpdate": "<string>",
  "enabled": true,
  "sourceConfig": {
    "type": "postgres",
    "name": "<string>",
    "authMethod": "<string>",
    "connection": {
      "username": "<string>",
      "password": "<string>",
      "hostname": "<string>",
      "port": 123,
      "database": "<string>",
      "slot": "<string>",
      "publication": "<string>"
    },
    "connectionType": "<string>",
    "owners": [
      "<string>"
    ]
  },
  "sourceSettings": {
    "max_clients": 123,
    "incremental_mode": "<string>"
  }
}

This connector uses the common integration parameters as described in the Create Integration endpoint, along with the PostgreSQL-specific parameters below.

Additional Resources

Schema Configuration

How to configure which tables and columns to sync

destinationId

string

required

destinationSchema

string

required

replicationFrequency

string

required

onSchemaUpdate

string

required

enabled

boolean

required

sourceConfig

object

required

Show child attributes

sourceSettings

object

required

Show child attributes

API Reference

Assets

Integrations

Connectors

Users

Tags

Audit Logs

PostgreSQL Connector

Additional Resources

Schema Configuration

​Additional Resources

Schema Configuration

Additional Resources