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.
Example:
http://www.example.net/
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.
Mandatory field.
Example:
pswrd234%!
JDBC options
Specify JDBC URL for connecting to Azure Synapse, and the neccessary options.
Optional field.
Example:
jdbc:sqlserver://yourserver.database.windows.net:1234;database=mydatabase;
Other notes:
Under Advanced configuration.
JDBC options
Specify the options associated with the JDBC URL.
Optional field.
Example:
jdbc:sqlserver://[serverName[\instanceName][:portNumber]]
Other notes:
Advanced configuration

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 quoates.
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
TS load options
Specify additional parameters passed with the tsload command. The format for these parameters is:
--<param_1_name> <optional_param_1_value>
Optional field.
Example:
--max_ignored_rows 0
Valid Values:

--null_value ""
--escape_character ""
--max_ignored_rows 0
Default:
--max_ignored_rows 0
Reference:
tsload flag reference

Dataflow tips