Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This Snap fails to insert null values for date data types, because of an issue with the jOOQ auto cast() expression in the transformed query.

Behavior Change

As part of 436patches25696, when you use a stored procedure in the Azure Synapse SQL - Execute Snap, the Snap displays Message: Success and $UPDATE_COUNT=-1, 0, or 1 (based on the Snap Pack behavior) in the output.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 1

  • Mapper

  • Copy

If the input view is defined, then the where clause substitutes incoming values for a specific query.

Output

Document

  • Min: 0

  • Max: 1

  • JSON Formatter

If an output view is available and an update/insert/merge/delete statement was executed, then the original document that was used to create the statement will be output with the status of the executed statement.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution when the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

...