Skip to main content
PostgreSQL is the live destination connector documented for the current MantrixFlow app.

​
Required access

Use a database user with write access to the destination schema and tables. MantrixFlow does not create final destination tables during delivery. Create the table with the pipeline setup action or with SQL before starting a run.

​
Connection fields

​
Destination table requirements

Create or verify the target table from a published output assignment in the destination editor, or create it manually before the first run. The Quick Start contains a complete PostgreSQL destination-table example. In Destinations, open the saved destination. Under Published output targets, enter final targets as schema.table, for example analytics.orders_live.

​
Write behavior

The live write mode is Upsert.
  • If the destination table has a primary key, MantrixFlow uses merge-style delivery.
  • If the destination table has no primary key, MantrixFlow appends rows and records a no-primary-key warning.

​
Setup flow

  1. Open Connections.
  2. Click + New Connection.
  3. Set role to Destination.
  4. Choose PostgreSQL.
  5. Fill the form.
  6. Click Test Connection.
  7. Save only after the test succeeds.