| Property | Requirement | Type | Default | Description |
|---|---|---|---|---|
| Host | ✓ | String | - | |
| Port | ✓ | String | default | A port number or ‘default’ |
| Database | ✓ | String | - | |
| Table Name | ✓ | String | - | |
| Limit | Long | - | Max output count | |
| Offset | Long | - | Starting point of output | |
| Keyword Search? | Boolean | false | ||
| ↳ Keyword Search Column | String | - | ||
| ↳ Keywords to Search | String | - | “[‘hello’, ‘world’], {‘mode’:‘any’}” OR “[‘hello’, ‘world’], {‘mode’:‘all’}” | |
| Progressive? | Boolean | false | ||
| ↳ Batch by Column | String | - | ||
| ↳ Min | String | auto | ||
| ↳ Max | String | auto | ||
| ↳ Batch by Interval | Long | 1000000000 | ||
| Geo Search? | Boolean | false | ||
| ↳ Geo Search By Columns | List | - | Column(s) to check if any of them is in the bounding box below | |
| ↳ Geo Search Bounding Box | List | - | At least 2 entries should be provided to form a bounding box. format of each entry: long, lat | |
| Regex Search? | Boolean | false | ||
| ↳ Regex Search By Column | String | - | ||
| ↳ Regex to Search | String | - | ||
| Filter Condition? | Boolean | false | ||
| ↳ Predicates | List | - | Multiple predicates in OR | |
| ↳ Attribute | ✓ | String | - | |
| ↳ Condition | ✓ | =, >, >=, <, <=, !=, is null, is not null | - | |
| ↳ Value | String | - |
| Port | Mode |
|---|---|
| 0 | Set Snapshot |