Optional.A document that provides values for one or more properties of the Snap or for pass-through purpose.

• Mapper
• JSON Generator

Document for each record retrieved.

• Mapper
• JSON Formatter

String

Required.Specify a unique name for the Snap.

Default value: Azure Synapse SQL - Select

Example: Azure_Synapse_SQL_Select

String/Expression

Specify the database schema name. If it is not defined, then the suggestion for the Table Name retrieves all tables names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values.

Default value: None

Example: dbo

String/Expression

Required.Specify the name of a table on which the select query is to be executed.

Default value: None

Example: dbo.people

String/Expression

Specify the where clause of the select statement. This field supports document value substitution (for example, $person.firstname is substituted with the value found in the incoming document at the path).

Default value: None

Example:

Without using expressions

• EmpId = 12
• email = '[email protected]'

Using expressions

• "EMPNO=$EMPNO and ENAME=$EMPNAME"
• email = '[email protected]' or email = $email
• emp=$emp
• "emp='" + $emp + "'"
• "EMPNO=" + $EMPNO + " and ENAME='" + $EMPNAME+ "'"

String/Expression

Use this field set to define the column names for sorting the results. If you do not specify column names, the Snaps uses the default database sort order.

Default value: None

Example: name, email

String/Expression

Use this field set to define the output fields for SQL Select statement. Specify the output fields for the SQL SELECT statement. To select all fields, leave them blank.

Default value: None

Example: name, email, address, first, last

Checkbox

Select this checkbox to include only the selected fields or columns in the Output Schema (second output view). If you do not provide any Output fields, all the columns are visible in the output. If you provide output fields, we recommend you to select Fetch output fields in schema checkbox.

Default value: Not selected

Example: Selected

Checkbox

Select this checkbox if you do not want to write to the output view when a SELECT operation does not produce any result or is empty. If you do not select this property and with the default Pass through property, the input document is written to the output view.

Default value: Deselected

Dropdown list

Select one of the following options to override the state of the Auto Commit property on the account:

• True - The Snap executes with auto commit enabled regardless of the value set for Auto Commit in the Account used by the Snap.
• False - The Snap executes with auto-commit disabled regardless of the value set for Auto Commit in the Account used by the Snap.
• Use account setting - The Snap executes with the Auto Commit property value inherited by the Account used by the Snap.

Default value: False

Example: True

Checkbox

Select this checkbox to match the output data type when the Output Fields property is empty (SELECT * FROM ...). The output preview is in the same format as the one when SELECT * FROM is implied and all the contents of the table are displayed. This property applies only when the Output Fields property is provided with any field values.

Default value: Deselected

String/Expression

Specify the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.

If the value is larger than 0, the Snap first downloads the target file into a temporary local file. If any error occurs during the download, the Snap waits for the time specified in the Retry interval and attempts to download the file again from the beginning. When the download is successful, the Snap streams the data from the temporary file to the downstream Pipeline. All temporary local files are deleted when they are no longer needed.

Ensure that the local drive has sufficient free disk space to store the temporary local file.

Default value: 0

Example: 3

String/Expression

Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception.

Default value: 1

Example: 10

Dropdown list

Select a value from the following options to specify the location to store input documents between retries when the value in the Number of retries field is greater than 0:

• In memory: The query results are stored in the Snaplex memory. If the query is too large to fit in the memory space, it might cause the Snap to fail, so choose the On disk option.
• On disk: The query results are stored on the disk in a temporary (tmp) directory that is managed by the SnapLogic platform. This directory is deleted automatically when the Snap terminates.

To disable staging, enter 0 in the Number of retries field.

Default value: In memory

Example: On disk

Snap execution

Default value: Execute only

Example: Validate & execute