...
Field Name | Type | Description | ||||
---|---|---|---|---|---|---|
Label* | String | The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. Default Value: ELT Cast Function | ||||
Get preview data | Checkbox | Select this checkbox to include a preview of the query's output. The Snap performs limited execution and generates a data preview during Pipeline validation.
The number of records displayed in the preview (upon validation) is the smaller of the following:
Rendering Complex Data Types in Databricks Lakehouse Platform
| ||||
Pass through | Checkbox | Select this checkbox to specify that the Snap must include the incoming document (SQL query) in its output document.
Default Value: Not selected | ||||
Cast functions | Specify your SQL expressions, data type and the relevant alias using this fieldset. Click to add a new row. Ensure that you specify each expression in a separate row. | |||||
ExpressionFunction* | String/Expression | Specify your function/operation to be performed in the specified columns. Ensure that you specify each function in a separate row. | ||||
ArgumentData Type* | String/Expression | Each of the function needs only one value/argument. Hence, specify an argument Specify the data type for the selected expression/function. Clickto retrieve the list of the supported aggregate functions. This is typically a column name in your source table. Each of the function needs only one value. | ||||
Alias* | String | Specify the column in which the result of the binary function has to be displayed. You can also reference this name in downstream Snaps to process the data further. Default Value: None. |
...
Error | Reason | Resolution |
---|---|---|
Missing property value | You have not specified a value for the mandatory field where this message is displayed. | Ensure that you specify appropriate values for all mandatory fields in the Snap configuration. |
Invalid placement of ELT Cast Function snap | ELT Cast Function Snap cannot be used at the start of a Pipeline. | Move the ELT Cast Function Snap to either the middle or the end of the Pipeline. |
CAST (DEPT AS BINARY) is not a natural function for Snowflake. It displays the following error message. | In the SQL query, | Instead of (DEPT AS BINARY), you can use:
Examples:
|
...
Examples
See Also
...
Endpoint Doc Link 1
...
Endpoint Doc Link 2
...
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439233/Glossary
...