PostgreSQL
Overview
You can create a PostgreSQL Destination Connector to write to a PostgreSQL table using your PostgreSQL username and password.
The schema for this Destination Connector is defined by the PostgreSQL table schema.
Prerequisites
Required information:
Host
Port
Username
Password
Database
Table
Creating an PostgreSQL Destination Connector
Step 1: After selecting + New Connector, under the System prompt, click PostgreSQL.

Step 2: Provide a Connector Name.
Step 3: Select Destination Connector.
Step 4: Provide the Host Name.
Step 5: Provide the Port Number.
Step 6: Provide your Username.
Step 7: Provide your Password.
Step 8: Provide the name of the Database that contains the table you want to write to.
Step 9: Provide the name of the Table that you want to write to.
Advanced Options
Validation Webhook
We support the use of Validation Webhooks to prevent bad data from being written to your systems, adding another layer of protection to the built-in validations that Osmos provides. The Webhook URL can be posted here.
Connector Options
The connector can be deleted, edited and duplicated.
Duplication
To save time, the connector can be duplicated. This new connector needs to be named and can be edited, as needed.

Last updated
Was this helpful?