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.
- Example:
- 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
tsloadcommand, 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
