Vertica connection reference
Learn about the fields used to create a Vertica connection with ThoughtSpot DataFlow.
Here is a list of the fields for a Vertica connection in ThoughtSpot DataFlow. You need specific information to establish a seamless and secure connection.
Connection properties
- Connection name
-
Name your connection.
Mandatory field.
- Example
-
VerticaConnection
- Connection type
-
Choose the Vertica connection type.
Mandatory field.
- Example
-
Vertica
- Host name
-
Specify the hostname or the IP address of the Vertica system
Mandatory field.
- Example
-
www.example.com
- Port
-
Specify the port associated to the Vertica system
Mandatory field.
- Example
-
1234
- Default
-
5433
- User
-
Specify the user id that will be used to connect to the Vertica system. This user should have necessary privileges to access the data in the databases.
Mandatory field.
- Example
-
userdi
- Password
-
Specify the password for the User
Mandatory field.
- Example
-
pswrd234%!
- Database
-
Collection of information that is organized so that it can be easily accessed, managed, and updated.
Mandatory field.
- Example
-
database
- SSL encryption
-
To ensure the data is encrypted use additional security feature such as SSL.
Optional field.
- Trust store
-
Specify the TLS/SSL client certificate store for SSL Client Authentication (2-way SSL)
Mandatory field.
- Example
-
trust store path
- Trust store password
-
Specify the password for the TLS/SSL client certificate.
Mandatory field.
- Example
-
password
Sync properties
- Column delimiter
-
Specify the column delimiter character.
Mandatory field.
- Example
-
1
- Valid values
-
Any printable ASCII character, or the decimal value for an ASCII character
- Default
-
The delimiter specified in sync
- Escape character
-
Specify the escape character if using a text qualifier in the source data.
Optional field.
- Example
-
""
- Valid values
-
Any ASCII character
- Default
-
""
- Enclosing character
-
Specify if the text columns in the source data must be in quotes, and the quote types.
Optional field.
- Example
-
DOUBLE - Valid values
-
Single, Double
- Default
-
DOUBLE
- TS load options
-
Specifies the parameters passed with the
tsloadcommand, in addition to the commands already included by the application.The format for these parameters is:
--<param_1_name><optonal_param_1_value> --<param_2_name><optonal_param_21_value>
Optional field.
- Example
-
--max_ignored_rows 0
- Valid values
-
--null_value """" --escape_character """" --max_ignored_rows 0
- Default
-
--max_ignored_rows 0
- Max ignored rows
-
Abort the transaction after encountering 'n' ignored rows. Optional field.
- Example:
-
0 - Valid Values:
-
Any numeric value
- Default:
-
0
- Fetch size
-
Specify the number of rows to fetch at one time, and process in memory.
If the value specified is
0, then DataFlow extracts all rows at the same time.Optional field.
- Example
-
1000 - Valid values
-
Any numeric value
- Default
-
1000
- JDBC options
-
Specify the options associated with the JDBC URL.
Optional field.
- Example
-
jdbc:sqlserver://[serverName[instanceName][:portNumber]]
Related information
