Vertica Reader Activity¶
Reads PostgreSQL table as a view.
Parameters¶
Name |
Description |
Type |
Default |
|---|---|---|---|
Title |
Title of the activity to display on the designer. |
text |
|
Host Name |
Name or address of the server where Vertica database is hosted. |
text |
|
Port |
Port number which Vertica database is configured with. |
int |
5433 |
Database Name |
Name of the database. |
text |
|
User Name |
Valid Vertica user name.
Consider using vault feature with templating (e.g. |
text |
|
Password |
Password associated with above user. Consider
using vault feature with templating (e.g. |
text |
|
Table Name |
Vertica table name. |
text |
|
Batch Size |
Read batch size. Default value is 0 (let driver estimate best number) |
int |
1000 |
As |
Name of the DataRow view linked to the Vertica table. |
text |
|
Options |
Additional options. |
key-value |