Apache Parquet connection reference

Learn about the fields used to create an Apache Parquet connection with ThoughtSpot DataFlow.

Here is a list of the fields for an Apache Parquet 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:

ApacheParquetConnection

Connection type

Choose the Apache Parquet connection type. Mandatory field.

Example:

Apache Parquet

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

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

Example:

!hello

Other notes:

Advanced configuration

Sync properties

Null value

Specifies the string literal 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:

NULL

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:

Any printable ASCII character

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:

Any printable ASCII character

Default:

:

Boolean representation

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

Example:

true_false

Valid Values:

true_false, T_F, 1_0, T_NULL

Default:

true_false

Skip trailer rows

Skip trailer row while processing the data.
Optional field.

Example:

5

Valid Values:

Any numeric value

Default:

0

Reader encoder

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

Example:

UFT-8

Valid Values:

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

Default:

UFT-8

Parallel thread limit

Specify the number of parallel threads to unload data. Optional field.

Example:

4

Valid Values:

Any numeric value

Default:

1