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

Authentication type

Specifies the type of security protocol to connect to the instance. Based on the type of security, select the authentication type and provide details. Mandatory field.

Valid Values:

Database credentials, Active directory password, Active directory service principal, Active directory MSI

User

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

Example:

user1

Other notes:

Field does not appear when you select "Active Directory service principal" or "Active Directory MSI" authentication types.

Password

Specify the password for the User.

Mandatory field.

Example:

pswrd234%!

Other notes:

Field does not appear when you select "Active Directory service principal" or "Active Directory MSI" authentication types.

AAD secure principal id

Specify the Azure Active Directory secure principal id. Field appears when you select the "Active directory service principal" authentication type.

AAD secure principal secret

Specify the Azure Active Directory secure principal secret. Field appears when you select the "Active directory service principal" authentication type.

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. Mandatory 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. Mandatory 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

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?