Dremio connection reference
Learn about the fields used to create a Dremio connection with ThoughtSpot DataFlow.
Here is a list of the fields for a Dremio 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
-
DremioConnection
- Connection type
-
Choose the Dremio connection type.
Mandatory field.
- Example
-
Dremio
- Host
-
Specify the hostname or the IP address of the Dremio system.
Mandatory field.
- Example
-
www.example.com
- Port
-
Specify the port associated to the Dremio system.
Mandatory field.
- Example
-
1234
- Default
-
31010
- User
-
Specify the user to connect to Dremio. This user must have data access privileges.
Mandatory field.
- Example
-
userdi
- Password
-
Specify the password for the User.
Mandatory field.
- Example
-
pswrd234%!
- JDBC options
-
Specify the options associated with the JDBC URL.
Optional field.
- Example
-
jdbc:sqlserver://[serverName[\instanceName][:portNumber]]`
- Note
-
Advanced configuration
Sync properties
- Column delimiter
-
Specify the column delimiter character.
Mandatory field. Example;; 1 Valid values;; Any printable ASCII character or the decimal value for ASCII character Default;; 1
- Enclosing character
-
Specify when the text columns in the source data must be enclosed in quotes.
Optional field.
- Example
-
DOUBLE
- Valid values
-
SINGLE, DOUBLE
- Default
-
DOUBLE
- Note
-
Required when the text data contains newline or delimiter characters.
- Escape character
-
Specify this if the text qualifier is mentioned. This should be the character which escapes the text qualifier character in the source data.
Optional field.
- Example
-
\""
- Valid values
-
Any ASCII character
- Default
-
\""
- Sync Properties
-
Optional field.
- 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
- Max ignored rows
-
Abort the transaction after encountering 'n' ignored rows. Optional field.
- Example:
-
0 - Valid Values:
-
Any numeric value
- Default:
-
0
- 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
Related information
