...
| User Facing Name | Type | Description | Constraints | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Label | String | Label for UI | ||||||||||
| Reference Name | String | Uniquely identified name for lineage | ||||||||||
| Host | String | PostgreSQL host | Required (defaults to localhost on UI) | |||||||||
| Port | Number | Specific port where PostgreSQL running on | Optional (default 5432) | |||||||||
| Database | String | Database name to connect | Required | |||||||||
| Import Query | String | Query for import data | Valid SQL query | |||||||||
| Username | String | DB username | Required | |||||||||
| Password | Password | User password | Required | Bounding Query | String | Returns max and minof split-By FiledValid SQL query | Split-By Field Name | String | Field name which will be used to generate splits | Number of Splits to Generate | Number | Number of splits to generate |
| Transaction Isolation Level | Select | Transaction isolation level for queries run by this sink | ||||||||||
| Connection Arguments | Keyvalue | A list of arbitrary string tag/value pairs as connection arguments, list of properties https://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters | ||||||||||
| Table Name | String | Name of a database table to write to | ||||||||||
| Connect Timeout | Number | The timeout value used for socket connect operations. If connecting to the server takes longer than this value, the connection is broken. The timeout is specified in seconds and a value of zero means that it is disabled |
...