...
| User Facing Name | Type | Description | Constraints | |||
|---|---|---|---|---|---|---|
| Label | String | Label for UI | ||||
| Reference Name | String | Uniquely identified name for lineage | ||||
| Host | String | Oracle host | Required (defaults to localhost on UI) | |||
| Port | Number | Specific port where Oracle running on | Optional (default 1521) | |||
| Database | String | Database name to connect | Required | |||
| Import Query | String | Query for import data | Valid SQL query | |||
| Username | String | DB username | Required | |||
| Password | String | User password | Required | |||
| Bounding Query | String | Returns max and minof split-By Filed | Valid 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://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html | ||||
| Driver type | Select | Oracle driver type | Possible values (thin, oci) |
...