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