- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
- Releases Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- SQL Developer Guide
- Python Developer Guide
- ETL Developer Guide
- FAQ
- Contact Us
Overview
A PostgreSQL data sink can write data to the PostgreSQL database.
Notes
Primary key
All data generated by an ETL data source table is UPSERT data, so it's important that you correctly define the primary key for the PostgreSQL database table.
The primary key defined for the data sink table must be the same as that defined for the physical table. Otherwise, an error may occur after the task is started.
WITH parameters
PostgreSQL data sinks are developed based on JDBC and support the following sink-related configurations:
Parameter | Required | Default Value | Description |
sink.buffer-flush.max-rows | No | 100 | The maximum size of buffered data records before flush. If this is set to 0, no data will be buffered. |
sink.buffer-flush.interval | No | 1s | The maximum interval (ms) between flushes. If sink.buffer-flush.max-rows is 0, and this parameter is not, buffered actions will be processed asynchronously. |
sink.max-retries | No | 3 | The maximum number of retries allowed when a write operation fails. |
Yes
No
Was this page helpful?