...
Known Issues
None.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| If an input view is defined, then values from an incoming document can be used as input parameters to the stored procedure. |
Output | Document |
|
| If the procedure contains any OUT parameters, they are written to the output view. |
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:
Learn more about Error handling in Pipelines. |
Snap Settings
Info |
---|
|
Field Name | Field Type | Description | ||
---|---|---|---|---|
Label* Default Value: Azure Synapse SQL - Stored Procedure | String | Specify a unique name for the Snap. | ||
Schema Name Default Value: N/A | String/Expression/Suggestion | Specify the schema name of the database where the Stored Procedure resides. | ||
Package Name Default Value: N/A | String/Expression/Suggestion | Specify the package name that contains the Stored Procedures. | ||
Stored Procedure Name Default Value: N/A | String/Expression/Suggestion | Specify the Stored Procedure name to execute. If a package is defined, then it will only return the procedures of that package. If a schema is defined and no package is defined, then the Snap returns all procedures of that schema. | ||
Parameter Values | Use this field set to specify advanced parameters that you want to include in the request. | |||
Parameter Value Default Value: None | String/Expression | Select the input parameter values for the stored procedure. The parameter values are bound to the input columns in the order they appear in the list. Therefore, you must define the values in the same order as they appear in the Stored Procedure definition.
| ||
Snap Execution Default Value: | Dropdown list | Select one of the three modes in which the Snap executes. Available options are:
|
Example
Calling a Stored Procedure
...
...