Flat file connection reference

Learn about the fields used to create a Flat file connection with ThoughtSpot DataFlow.

Here is a list of the fields for a Flat file 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:

FilesConnection

Connection type

Choose the Files connection type. Mandatory field.

Example:

Files

File location

Specify the base location of the file on the server. Mandatory field.

Example:

/home/admin/dataflow/data

Files on remote location

Specify if the files on remote server. Mandatory field.

Default:

No

Other notes:

These are under Advanced configuration.

Protocol

Select the required remote server connection. Mandatory field.
For remote location files only.

Example:

FTP

Valid Values:

FTP, SFTP

Default:

FTP

Authentication type

Specify the authentication type for SFTP Protocol. Mandatory field.
For SFTP protocol only.

Example:

Password

Valid Values:

Key, Password

Default:

Password

Host

Specify the Hostname or the IP address of the remote server. Mandatory field.
For remote location files only.

Example:

www.example.com

Port

Specify the Port to connect the remote server. Mandatory field.
For remote location files only.

Example:

1234

User

Specify the user to connect to remote server. This user must have data access privileges. Mandatory field.
For remote location files only.

Example:

userdi

Password

Specify the password for the User.

Optional field.

Example:

pswrd234%!

Note:

For remote location files only, when using password authentication.

Key file

Specify the key file and its fully qualified path. Mandatory field.
For remote location files only, when using key authentication.

Example:

/app/key/sftp.key

Passphrase for key file

Specify the passphrase for the key file. Optional field.
For remote location files only, when using key authentication.

Example:

!hello

Note:

Advanced Configuration.

Sync properties

Enclosing character

Specify if the text columns in the source data needs to be enclosed in quotes. Optional field.

Example:

Single

Valid Values:

Single, Double

Default:

"

Escape character

Specify the escape character if using a text qualifier in the source data. Optional field.

Example:

\\

Valid Values:

Any ASCII character

Default:

"

Null value

Specifies the string literal that indicates the null value for a column. During the data load, the column value matching this string will be loaded as null in the target. Optional field.

Example:

NULL

Valid Values:

Any string literal

Default:

Empty

Date style

Specifies how to interpret the date format. Optional field.

Example:

YMD

Valid Values:

YMD, MDY, DMY, DMONY, MONDY, Y2MD, MDY2, DMY2, DMONY2, and MONDY2

Default:

YMD

Other notes:

MDY: 2-digit month, 2-digit day, 4-digit year
DMY: 2-digit month, 2-digit day, 4-digit year
DMONY: 2-digit day, 3-character month name, 4-digit year
MONDY: 3-character month name, 2-digit day, 4-digit year
Y2MD: 2-digit year, 2-digit month, 2-digit day
MDY2: 2-digit month, 2-digit day, 2-digit year
DMY2: 2-digit day, 2-digit month, 2-digit year
DMONY2: 2-digit day, 3-character month name, 2-digit year
MONDY2: 3-character month name, 2-digit day, 2-digit year

Date delimiter

Specifies the separator used in the date format. Optional field.

Example:

-

Valid Values:

Only the default value

Default:

-

Time style

Specifies the format of the time portion in the data. Optional field.

Example:

24HOUR

Valid Values:

12 Hour, 24 Hour

Default:

24HOUR

Time delimiter

Specifies the character used as separate the time components. Optional field.

Example:

:

Valid Values:

Only the default value

Default:

:

Reader encoder

Specify the encoding format of the source system. Optional field.

Example:

UTF-8

Valid Values:

ISO-8859-1, UTF-16, UTF-16BE, WINDOWS-1252

Default:

UTF-8

Boolean representation

Specifies the representation of data in the boolean field. Optional field.

Example:

true_false

Valid Values:

true_false, TRUE_FALSE, t_f, T_F, y_n,Y_N, 1_0, T_NULL, t_null

Default:

true_false

Max ignored rows

Abort the transaction after encountering 'n' ignored rows. Optional field.

Example:

0

Valid Values:

Any numeric value

Default:

0

tsload options

Specifies the parameters passed with the tsload command, in addition to the commands already included by the application. The format for these parameters is:

<param_1_name> = <param_1_value>
Example:
date_time_format = %Y-%m-%d
date_format = %Y-%m-%d;time_format = %H:%M:%S
Valid Values:
null_value = NULL
max_ignored_rows = 0
Default:
max_ignored_rows = 0

Related information


Was this page helpful?