Azure Synapse connection reference

Learn about the fields used to create an Azure Synapse connection with ThoughtSpot DataFlow.

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

AzureSynapseConnection

Connection type

Choose the Azure Synapse connection type. Mandatory field.

Example:

Azure Synapse

Host

Specify the name of the server. Mandatory field.

Port

Specify the connection port for Azure Synapse. Mandatory field.

Example:

1234

User

Specify the user who connects to Azure Synapse. This user must have data access privileges. Mandatory field.

Example:

user1

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]]
Other notes:

Advanced configuration.

Database

Specify Database details like name, alias name, schema. Mandatory field.

Example:

di_src

Sync properties

Data extraction mode

Specify the extraction type. Optional field.

Example:

BCP

Valid Values:

JDBC, BCP

Default:

JDBC

Column delimiter

Specify the column delimiter character. Mandatory field.

Example:

, (comma)

Valid Values:

Any character, (comma, semicolon) or a number. If using a number, system uses its ASCII value as delimiter.

Default:

, (comma)

Null value

Specify the string literal that represents NULL on the source. When loading data, the system replaces this with NULL. Optional field.
Available only when Data extraction mode is BCP.

Example:

NULL

Valid Values:

Any string literal

Default:

NULL

Enclosing character

Specify if text columns in the source data are enclosed in quotes; if yes, single quotes or double quotes. Optional field.

Example:

Double

Valid Values:

Single, Double

Default:

Double

Other notes:

Required if text data uses newline character or delimiter character.

Escape character

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

Example:

\"

Valid Values:

Any ASCII character

Default:

\"

Fetch size

Specify the number of rows fetched into memory at the same time. If the value is 0, system fetches all rows at the same time. Optional field.
Available only when Data extraction mode is JDBC.

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 tsload command, in addition to the commands already included by the application. The format for these parameters is:

--<param_1_name> = <param_1_value>
--<param_2_name> = <param_2_value>

Optional field.

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