{"type":"doc","content":[{"type":"paragraph","content":[{"text":"In this article","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"2"},"_parentId":{"value":"1438834"},"exclude":{"value":"Older Versions|Additional Resources|Related Links|Related Information"}},"macroMetadata":{"macroId":{"value":"fa1f1ed3-4d15-49af-b1fb-099651fd55e4"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"a8b51f6e-73e5-48df-8a45-8eb850b3baba"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"You can use this Snap to execute arbitrary Snowflake SQL. This Snap works only with single queries.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":122447,"__fileMimeType":"image/png","width":480,"id":"dcbcc3f4-d4d7-434a-9a55-f0591557bd1e","collection":"contentId-1438834","type":"file","__fileName":"snowflake-execute-sp-overview1.png","height":491}}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"The Snap substitutes the valid JSON paths that are defined in the WHERE clause for queries/statements with the values present in the incoming document. If the incoming document does not carry a substituting value, the document is written to the error view. If the Snap executes a SELECT query, it merges the query results into the incoming document and overwrites the values of all existing keys. On the other hand, the Snap writes the original document if there are no results from the query. If an output view is available and an UPDATE/INSERT/MERGE/DELETE statement is executed, the original document that was used to create the statement becomes output with the status of the statement executed.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Snap Type","type":"text"}]},{"type":"paragraph","content":[{"text":"The Snowflake - Execute Snap is a Write-type Snap that executes arbitrary Snowflake SQL. Depending on your query type, this Snap can also read data.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisites","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"Snowflake - Bulk Load"},"_parentId":{"value":"1438834"},"_referencedContentId":{"value":"1438549"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"f05f64d8-2ef2-4fb5-bb52-7a3d40f694ee"},"schemaVersion":{"value":"1"},"title":"Insert excerpt"}},"localId":"96947de5-ccb5-48e3-a71c-919fdd1c2362"}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Security Prerequisites","type":"text"}]},{"type":"paragraph","content":[{"text":"You should have the following permissions (but not limited to) in your Snowflake account to execute this Snap:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Usage (DB and Schema): Privilege to use database, role, and schema.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create table: Privilege to create a table on the database. role, and schema.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The following commands enable minimum privileges in the Snowflake Console:","type":"text"}]},{"type":"codeBlock","content":[{"text":"grant usage on database to role ;\ngrant usage on schema .;\n \ngrant \"CREATE TABLE\" on database to role ;\ngrant \"CREATE TABLE\" on schema .;","type":"text"}]},{"type":"paragraph","content":[{"text":"For more information on Snowflake privileges, refer to ","type":"text"},{"text":"Access Control Privileges","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide/security-access-control-privileges.html"}}]},{"text":". ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Internal SQL Commands","type":"text"}]},{"type":"paragraph","content":[{"text":"The permissions to grant for usage on database and creating tables depend on the queries you provide in this Snap.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Support for Ultra Pipelines","type":"text"}]},{"type":"paragraph","content":[{"text":"Works in ","type":"text"},{"text":"Ultra Pipelines","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1437955/Ultra+Pipelines"}}]},{"text":". ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Limitations","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User-defined functions (UDFs) created in the Snowflake console can be executed using Snowflake - Execute Snap. See ","type":"text"},{"text":"Execute-Snowflake Execute Snap supports UDFs","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":" in examples. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Snap may break existing Pipelines if the JDBC Driver is updated to a newer version.","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Snowflake Execute and Multi-Execute Snaps may break existing Pipelines if the JDBC Driver is updated to a newer version.","type":"text"}]},{"type":"paragraph","content":[{"text":"With the updated JDBC driver (version 3.12.3), the Snowflake Execute and Multi-Execute Snaps' output displays a ","type":"text"},{"text":"Status","type":"text","marks":[{"type":"strong"}]},{"text":" of \"","type":"text"},{"text":"-1","type":"text","marks":[{"type":"em"}]},{"text":"\" instead of \"","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"text":"\" without the ","type":"text"},{"text":"Message","type":"text","marks":[{"type":"strong"}]},{"text":" field upon successfully executing DDL statements. If your Pipelines use these Snaps and downstream Snaps use the ","type":"text"},{"text":"Status","type":"text","marks":[{"type":"strong"}]},{"text":" field's value from these, you must modify the downstream Snaps to proceed on a status value of -1 instead of 0.","type":"text"}]},{"type":"paragraph","content":[{"text":"This change in the Snap behavior follows from the change introduced in the ","type":"text"},{"text":"Snowflake JDBC driver in version 3.8.1","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/release-notes/client-change-log-jdbc.html"}}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"\"Statement.getUpdateCount() and PreparedStatement.getUpdateCount() return the number of rows updated by DML statements. For all other types of statements, including queries, they return -1.\"","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Known Issues","type":"text"}]},{"type":"paragraph","content":[{"text":"Because of performance issues, all Snowflake Snaps now ignore the ","type":"text"},{"text":"Cancel queued queries when pipeline is stopped or if it fails","type":"text","marks":[{"type":"strong"}]},{"text":" option for ","type":"text"},{"text":"Manage Queued Queries","type":"text","marks":[{"type":"strong"}]},{"text":", even when selected. Snaps behave as though the default ","type":"text"},{"text":"Continue to execute queued queries when the Pipeline is stopped or if it fails ","type":"text","marks":[{"type":"strong"}]},{"text":"option were selected.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"__fileSize":20517,"__fileMimeType":"image/png","width":542,"id":"985b8059-e322-439a-8733-c6c64d52d424","collection":"contentId-1438834","type":"file","__fileName":"snowflake-cancel-queued queries.png","height":97}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Behavior Change","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In 4.26, when the stored procedures were called using the Database Execute Snaps, the queries were treated as write queries instead of read queries. So the output displayed message and status keys after executing the stored procedure.","type":"text"},{"type":"hardBreak"},{"text":"In 4.27, all the Database Execute Snaps run stored procedures correctly, that is, the queries are treated as read queries. The output now displays message key, and OUT params of the procedure (if any). The status key is not displayed.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the stored procedure has no OUT parameters, only the message key is displayed with value success.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From 4.30 Release, the ","type":"text"},{"text":"Snowflake Execute","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438834"}}]},{"text":" Snap writes the output value as-is for FLOAT or DOUBLE datatype columns if these columns have the value as NaN (Not a Number). Earlier, the Snap displayed an exception error when the FLOAT or DOUBLE datatype column has the value as NaN. This behavior is not backward compatible.","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"If you have any existing Pipelines that are mapped with status key or previous description then those Pipelines will fail. So, you might need to revisit your Pipeline design.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Snap Views","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"bd31ceab-53dd-439e-851f-f72a9e5df8ec"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Format","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[267.0]},"content":[{"type":"paragraph","content":[{"text":"Number of Views","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[387.0]},"content":[{"type":"paragraph","content":[{"text":"Examples of Upstream and Downstream Snaps","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[587.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Input","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Document","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[267.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Min: 0","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Max: 1","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[387.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"JSON Generator","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Binary to Document","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[587.0]},"content":[{"type":"paragraph","content":[{"text":"Incoming documents are first written to a staging file on Snowflake's internal staging area. A temporary table is created on Snowflake with the contents of the staging file. An update operation is then run to update existing records in the target table and/or an insert operation is run to insert new records into the target table.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Output","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Document","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[267.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Min: 0","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Max: 1","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[387.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mapper","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Snowflake Execute","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[587.0]},"content":[{"type":"paragraph","content":[{"text":"If an output view is available, then the output document displays the number of input records and the status of the bulk upload as follows:","type":"text"},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Error","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":4,"rowspan":1,"colwidth":[200.0,267.0,387.0,587.0]},"content":[{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"When errors occur ","type":"text","marks":[{"type":"strong"}]},{"text":"list under the ","type":"text"},{"text":"Views ","type":"text","marks":[{"type":"strong"}]},{"text":"tab:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Stop Pipeline Execution","type":"text","marks":[{"type":"strong"}]},{"text":": Stops the current pipeline execution if the Snap encounters an error.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Discard Error Data and Continue","type":"text","marks":[{"type":"strong"}]},{"text":": Ignores the error, discards that record, and continues with the remaining records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Route Error Data to Error View","type":"text","marks":[{"type":"strong"}]},{"text":": Routes the error data to an error view without stopping the Snap execution.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Learn more about ","type":"text"},{"text":"Error handling in Pipelines","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/81526859"}}]},{"text":".","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Snap Settings","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Asterisk (","type":"text"},{"text":"*","type":"text","marks":[{"type":"strong"}]},{"text":"): Indicates a mandatory field.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Suggestion icon (","type":"text"},{"type":"emoji","attrs":{"id":"2fa452fe-3127-4e25-a103-1daf1d018f2f","text":":Suggest_Icon:","shortName":":Suggest_Icon:"}},{"text":"): Indicates a list that is dynamically populated based on the configuration.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Expression icon (","type":"text"},{"type":"emoji","attrs":{"id":"eafa7218-7a8b-4f28-ac02-063a11f06808","text":":Expression_Enabler:","shortName":":Expression_Enabler:"}},{"text":"): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about ","type":"text"},{"text":"Using Expressions in SnapLogic","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438042/Understanding+Expressions+in+SnapLogic"}}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add icon (","type":"text"},{"type":"emoji","attrs":{"id":"246af6d7-b82b-40db-9d59-39d08287d22b","text":":Plus:","shortName":":Plus:"}},{"text":"): Indicates that you can add fields in the field set.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Remove icon (","type":"text"},{"type":"emoji","attrs":{"id":"1f6c9214-8d14-4bf4-ae18-f0d4ed595846","text":":Minus:","shortName":":Minus:"}},{"text":"): Indicates that you can remove fields from the field set.","type":"text"}]}]}]}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"77507dff-b95d-460d-bd68-252923376c8a"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Field Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Field Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Label*","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Snowflake - Execute","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Load Employee Tables","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"String","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Specify the name for the Snap. You can make the name more specific, especially if your Pipeline has more than one of the same Snap.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"SQL Statement*","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"N/A","type":"text"}]},{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"INSERT into SnapLogic.book (id, book) VALUES ($id,$book)","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"String/Expression","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Specify the Snowflake SQL statement to execute on the server. ","type":"text"}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"We recommend you to add a single query in the SQL Statement field.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Document value substitution is performed on literals starting with '$', for example, $people.name is substituted with its value available in the incoming document.","type":"text"}]},{"type":"paragraph","content":[{"text":"In DB Execute Snaps, if the Snowflake SQL statement is not an expression, the JSON path, such as $para, is allowed in the WHERE clause only.","type":"text"}]},{"type":"paragraph","content":[{"text":"If the query statement starts with SELECT (case-insensitive), the Snap regards it as a select-type query and executes once per input document. If not, the Snap regards it as a write-type query and executes in batch mode.","type":"text"}]},{"type":"paragraph","content":[{"text":"This Snap does not allow you to inject Snowflake SQL, for example, select * from people where $columnName = abc.","type":"text"},{"type":"hardBreak"},{"text":"Only values can be substituted since it uses prepared statements for execution, which, for example, results in select * from people where address = ?.","type":"text"}]},{"type":"paragraph","content":[{"text":"Without using expressions","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"EmpId = 12","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"email = 'you@example.com'","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":"Using expressions","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"\"EMPNO=$EMPNO and ENAME=$EMPNAME\"","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"email = $email","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"emp=$emp","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"\"emp='\" + $emp + \"'\"","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"\"EMPNO=\" + $EMPNO + \" and ENAME='\" + $EMPNAME+ \"'\"","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Using expressions that join strings together to create SQL queries or conditions has a potential SQL injection risk and is hence unsafe. Ensure that you understand all implications and risks involved before using concatenation of strings with '=' Expression enabled. ","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If '$' is not part of the JSON path, escape it as \"\\$\" so that it can be executed as it is, such as SELECT \\$2, \\$3 FROM mytable.","type":"text"},{"type":"hardBreak"},{"text":"If the character before '$' is alphanumeric, there is no need to escape '$'. For example, SELECT metadata$filename ... ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When an escape character is an integral part of an expression-enabled query statement, precede it with another escape character.","type":"text"},{"type":"hardBreak"},{"text":"For example, if you enable expression for the ","type":"text"},{"text":"SQL statement","type":"text","marks":[{"type":"strong"}]},{"text":" property, precede the backslash with another backslash when entering such a statement. See the following image:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":22830,"__fileMimeType":"image/png","width":564,"id":"fde301d5-9027-4387-85d7-434fc7525a35","collection":"contentId-1438834","type":"file","__fileName":"Snowflake_Execute-Select_EscapeCharacter.png","height":179}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The '$' sign and identifier characters, such as double quotes (“), single quotes ('), or back quotes (`), are reserved characters and should not be used in comments or for purposes other than their originally intended purpose.","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Single quotes in values must be escaped","type":"text"}]},{"type":"paragraph","content":[{"text":"Any relational database (RDBMS) treats single quotes (","type":"text"},{"text":"'","type":"text","marks":[{"type":"code"}]},{"text":") as special symbols. So, single quotes in the data or values passed through a DML query may cause the Snap to fail when the query is executed. Ensure that you pass two consecutive single quotes in place of one within these values to escape the single quote through these queries.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example:","type":"text"}]}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"nested-table","text":"","parameters":{"cxhtml":"

If String	To pass this value	Use
Has no single quotes	Schaum Series	`'`Schaum Series`'`
Contains single quotes	`O'Reilly's Publication`	'`O''Reilly''s Publication`'

","nestedContent":{"type":"doc","content":[{"type":"table","attrs":{"__autoSize":true},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"If String ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"To pass this value","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Use","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Has no single quotes","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Schaum Series","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"'Schaum Series'","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Contains single quotes","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"O'Reilly's Publication","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"'","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"O''Reilly''s ","type":"text","marks":[{"type":"code"}]},{"text":"Publication","type":"text","marks":[{"type":"code"}]},{"text":"'","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]}]}],"version":1},"adf":"{\"type\":\"doc\",\"content\":[{\"type\":\"table\",\"attrs\":{\"__autoSize\":true},\"content\":[{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableHeader\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"If String \",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]},{\"type\":\"tableHeader\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"To pass this value\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]},{\"type\":\"tableHeader\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Use\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Has no single quotes\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Schaum Series\",\"type\":\"text\",\"marks\":[{\"type\":\"subsup\",\"attrs\":{\"type\":\"sup\"}}]}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"'Schaum Series'\",\"type\":\"text\",\"marks\":[{\"type\":\"subsup\",\"attrs\":{\"type\":\"sup\"}}]}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Contains single quotes\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"O'Reilly's Publication\",\"type\":\"text\",\"marks\":[{\"type\":\"subsup\",\"attrs\":{\"type\":\"sup\"}}]}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"'\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]},{\"text\":\"O''Reilly''s \",\"type\":\"text\",\"marks\":[{\"type\":\"code\"}]},{\"text\":\"Publication\",\"type\":\"text\",\"marks\":[{\"type\":\"code\"}]},{\"text\":\"'\",\"type\":\"text\",\"marks\":[{\"type\":\"textColor\",\"attrs\":{\"color\":\"#000000\"}}]}]}]}]}]}],\"version\":1}","reason":"A table in a table cell can't be created or edited in the new editor."}}}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Query type","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value: ","type":"text","marks":[{"type":"strong"}]},{"text":"Auto","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Read","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown list/Expression","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Select the type of query for your SQL statement (","type":"text"},{"text":"Read","type":"text","marks":[{"type":"em"}]},{"text":" or ","type":"text"},{"text":"Write","type":"text","marks":[{"type":"em"}]},{"text":").","type":"text"}]},{"type":"paragraph","content":[{"text":"When ","type":"text"},{"text":"Auto","type":"text","marks":[{"type":"em"}]},{"text":" is selected, the Snap tries to determine the query type automatically.","type":"text"},{"type":"hardBreak"},{"text":"If the execution result of the query is not as expected, you can change the query type to ","type":"text"},{"text":"Read","type":"text","marks":[{"type":"em"}]},{"text":" or ","type":"text"},{"text":"Write","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Pass through","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Selected","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Checkbox","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Select this checkbox to enable the Snap to pass the input document to the output view under the key named ","type":"text"},{"text":"original","type":"text","marks":[{"type":"code"}]},{"text":". This option applies only to the Execute Snaps with SELECT statement.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Ignore empty result","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Deselected","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Checkbox","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Select this checkbox to not write any document to the output view when a SELECT operation does not produce any result. If this checkbox is not selected and the Pass-through checkbox is selected, the input document is passed through to the output view.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Number of Retries","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"3","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Specify the maximum number of retry attempts the Snap must make in case there is a network failure and is unable to read the target file. The request is terminated if the attempts do not result in a response.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the ","type":"text"},{"text":"Number of retries","type":"text","marks":[{"type":"strong"}]},{"text":" value is set to ","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"text":" (the default value), the retry option is disabled, and the Snap does not initiate a retry. The pipeline will not attempt to retry the operation in case of a failure—any failure encountered during the database operation will immediately result in the pipeline failing without any retry attempts to recover from the errors.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the Number of retries value is greater than ","type":"text"},{"text":"0","type":"text","marks":[{"type":"em"}]},{"text":", the Snap initiates a download of 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 then attempts to download the file again from the beginning. After 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.","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"Ensure that the local drive has sufficient free disk space to store the temporary local file.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Minimum value","type":"text","marks":[{"type":"strong"}]},{"text":": 0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Retry Interval (seconds)","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"1","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"10","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Use Result Query","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Deselected","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Checkbox","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Select this checkbox to write the query execution result to the Snap's output view after the successful execution. The output of the Snap will be enclosed within the key ","type":"text"},{"text":"Result Query,","type":"text","marks":[{"type":"code"}]},{"text":" and the value will be the actual output produced by the SQL query. See the example ","type":"text"},{"text":"Snowflake Execute with Use Result Query enabled","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"self","anchorName":"SnowflakeExecutewithUseResultQueryenabled"},"href":"#Snowflake-Execute-SnowflakeExecutewithUseResultQueryenabled"}}]},{"text":" to know more about this option. ","type":"text"}]},{"type":"paragraph","content":[{"text":"This option allows users to effectively track the query's execution by clearly indicating the successful execution and the number of records affected, if any, after the execution.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Handle Timestamp and Date Time Data","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default value","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"text":" Default Date Time format in UTC Time Zone","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"Example: ","type":"text","marks":[{"type":"strong"}]},{"text":"SnapLogic Date Time format in Regional Time Zone","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown list","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Choose an option for handling timestamp and date time data. The available options are:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Default Date Time format in UTC Time Zone","type":"text","marks":[{"type":"em"}]},{"text":": The Snowflake date time data are represented in UTC Time Zone.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SnapLogic Date Time format in Regional Time Zone","type":"text","marks":[{"type":"em"}]},{"text":": The Snowflake date time data are represented in the same regional time zone value, as provided in the Snowflake account.","type":"text"}]}]}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Timestamp_recommendationINLINE

falseRecommendation:

If you use the Timestamp TZ and Timestamp LTZ in this Snap, we recommend you to use SnapLogic Date Time format in Regional TimeZone to ensure that you get the Timestamp data output of the target table in the same format as in the source table.

Source Table

Target Table

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"multiexcerpt-macro","parameters":{"macroParams":{"_parentId":{"value":"1438834"},"name":{"value":"Timestamp_recommendation"},"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"d6c8deb5-436c-42bb-b847-71afb6520ae1"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://raw.githubusercontent.com/fuegokit/appfire-design-systems-brand-svg/main/single-color-brand-icons/af-logo-multi-excerpt-24.svg"}}],"title":"MultiExcerpt"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Recommendation:","type":"text"}]},{"type":"paragraph","content":[{"text":"If you use the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Timestamp TZ","type":"text","marks":[{"type":"em"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" and ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Timestamp LTZ","type":"text","marks":[{"type":"em"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" in this Snap, we recommend you to use ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"SnapLogic Date Time format in Regional TimeZone","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" to ensure that you get the Timestamp data output of the target table in the same format as in the source table.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":"Source Table","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"wide"},"content":[{"type":"media","attrs":{"__fileSize":39691,"__fileMimeType":"image/png","width":979,"id":"db8278fe-cd7c-491a-87dc-decb42af3883","collection":"contentId-1438834","type":"file","__fileName":"timestamp_source.png","height":179}}]},{"type":"paragraph","content":[{"text":"Target Table","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"wide"},"content":[{"type":"media","attrs":{"__fileSize":39864,"__fileMimeType":"image/png","width":979,"id":"2db00417-5f81-4e30-ac24-31e4c30a8cfd","collection":"contentId-1438834","type":"file","__fileName":"timestamp_target.png","height":170}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1}}}}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"text":"Manage Queued Queries","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default value:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Continue to execute queued queries when pipeline is stopped or if it fails","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Cancel queued queries when the Pipeline is stopped or if it fails","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown list","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"text":"Select an option from the list to determine whether the Snap should continue or cancel the execution of the queued Snowflake Execute SQL queries when you stop the Pipeline. The available options are:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Continue to execute queued queries when pipeline is stopped or if it fails","type":"text","marks":[{"type":"em"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cancel queued queries when pipeline is stopped or if it fails","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"panel","attrs":{"panelType":"note"},"content":[{"type":"paragraph","content":[{"text":"If you select ","type":"text"},{"text":"Cancel queued queries when pipeline is stopped or if it fails","type":"text","marks":[{"type":"em"}]},{"text":", the read queries under execution are canceled, whereas the write type of queries under execution are not canceled. Snowflake internally determines which queries are safe to be canceled and cancels those queries.","type":"text"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[366.0]},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"multiexcerpt-include-macro","parameters":{"macroParams":{"_parentId":{"value":"1438834"},"name":{"value":"Snap Execution"},"page":{"value":"SOAP Execute"}},"macroMetadata":{"macroId":{"value":"3c628d36-4cf2-46b4-a7d7-8a0b513e97bc"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://raw.githubusercontent.com/fuegokit/appfire-design-systems-brand-svg/main/single-color-brand-icons/af-logo-multi-excerpt-24.svg"}}],"title":"MultiExcerpt Include"}},"localId":"69204e47-6732-452a-b60b-03ea76c4e625"}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Default Value","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Execute only","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"Example","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"Validate & Execute","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[224.0]},"content":[{"type":"paragraph","content":[{"text":"Dropdown list","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1021.0]},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"multiexcerpt-include-macro","parameters":{"macroParams":{"_parentId":{"value":"1438834"},"name":{"value":"Execution_Detail_Write"},"page":{"value":"SOAP Execute"}},"macroMetadata":{"macroId":{"value":"85e2c354-0c2e-46e8-846d-df226d696dbf"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://raw.githubusercontent.com/fuegokit/appfire-design-systems-brand-svg/main/single-color-brand-icons/af-logo-multi-excerpt-24.svg"}}],"title":"MultiExcerpt Include"}},"localId":"b7a94022-2cd9-4866-b757-460b653043b5"}}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Examples ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Snowflake Execute with Use Result Query enabled","type":"text"}]},{"type":"paragraph","content":[{"text":"This example Pipeline demonstrates how to insert data into a table using the Snowflake Execute Snap. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":"First, we configure the Snowflake Execute Snap as follows. Note that we select the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Use Result Query","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" checkbox to view the statement result output.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"type":"hardBreak"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"87d4ad16-f887-4dc7-b5e7-215565d22b26","collection":"contentId-1438834","height":""}}},{"type":"hardBreak"},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Upon execution, we see the following output enclosed within the key Result Query.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"facb3321-2cc7-4772-a300-506539a3505f","collection":"contentId-1438834","height":""}}}]},{"type":"paragraph","content":[{"text":"The following screenshot displays the output preview when we disable the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Use Result Query","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" checkbox.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"__fileSize":16728,"__fileMimeType":"image/png","width":1097,"id":"d219a2ab-fd87-403d-9d96-8580afc21b8c","collection":"contentId-1438834","type":"file","__fileName":"SnowflakeExec_4a.png","height":270}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Executing the Snowflake SQL query using the Execute Snap","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"The following example demonstrates the execution of Snowflake SQL query using the Snowflake Execute Snap.","type":"text"}]},{"type":"paragraph","content":[{"text":"First, we configure the Execute Snap with this query—","type":"text"},{"text":"select * from \"PRASANNA\".\"ADOBEDATA\" ","type":"text","marks":[{"type":"em"}]},{"text":", which returns the data from ","type":"text"},{"text":"ADOBEDATA.","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"},{"type":"hardBreak"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"5ad90616-96e7-43fb-a8be-200afb98d466","collection":"contentId-1438834","height":""}}}]},{"type":"paragraph","content":[{"text":"Upon successful execution, the Snap displays the following output in its data preview.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":60.0},"content":[{"type":"media","attrs":{"__fileSize":127837,"__fileMimeType":"image/png","width":889,"id":"0aef4611-a3ad-49bf-a2a8-8c63d33322cb","collection":"contentId-1438834","type":"file","__fileName":"SnowflakeExecute2.png","height":497}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Snowflake Execute Snap supports UDFs","type":"text"}]},{"type":"paragraph","content":[{"text":"User-defined functions (UDFs) created in the Snowflake console can be executed using Snowflake - Execute Snap. In the following example, the SQL statement is defined and then the Snap is executed with that conditions. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":16696,"__fileMimeType":"image/png","width":488,"id":"aeb5d99c-c749-4dd0-b981-37a42b9895a3","collection":"contentId-1438834","type":"file","__fileName":"image2021-11-12_19-37-10.png","height":147}}]},{"type":"paragraph","content":[{"text":"First, the Snowflake Execute Snap is used to give the user-defined SQL statement.","type":"text"},{"text":" area_of_circle(3.0)","type":"text","marks":[{"type":"em"}]},{"text":" is a UDF here. The Snap settings and the output view are as follows:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":35.0},"content":[{"type":"media","attrs":{"__fileSize":15660,"__fileMimeType":"image/png","width":486,"id":"81065536-4783-48b3-8bae-5ecfba91ecf7","collection":"contentId-1438834","type":"file","__fileName":"Snowflake_Snap settings.png","height":603}}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":7669,"__fileMimeType":"image/png","width":646,"id":"e89d4432-b9cf-4d4c-87ab-587dac04895f","collection":"contentId-1438834","type":"file","__fileName":"Snowflake_output view.png","height":237}}]},{"type":"paragraph","content":[{"text":"Then the Mapper Snap is used to define columns that need to be picked up from the Output of the Snowflake Execute. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":80.0},"content":[{"type":"media","attrs":{"__fileSize":22596,"__fileMimeType":"image/png","width":1032,"id":"e8bed20c-dd32-46d0-bb67-9135ca67a64b","collection":"contentId-1438834","type":"file","__fileName":"Mapper Snap Settings.png","height":727}}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":7282,"__fileMimeType":"image/png","width":689,"id":"1da30817-128b-45c5-b4ac-7fa1f4e9741c","collection":"contentId-1438834","type":"file","__fileName":"Mapper output.png","height":252}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"See Also","type":"text"}]},{"type":"paragraph","content":[{"text":"https://docs.snowflake.com/en/developer-guide/udf/sql/udf-sql-scalar-functions.html","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/developer-guide/udf/sql/udf-sql-scalar-functions.html"}}]}]},{"type":"paragraph","content":[{"text":"https://docs.snowflake.com/en/sql-reference/udf-overview.html","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/sql-reference/udf-overview.html"}}]}]},{"type":"paragraph","content":[{"text":"https://docs.snowflake.com/en/user-guide-getting-started.html","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.snowflake.com/en/user-guide-getting-started.html"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Snap Pack History","type":"text"}]},{"type":"expand","attrs":{"title":""},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"Snowflake Snap Pack"},"_parentId":{"value":"1438834"},"name":{"value":"Snowflake_SPH"},"_referencedContentId":{"value":"1438092"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"409a2b44-0be0-4cb3-ac33-a400fa13e0d3"},"schemaVersion":{"value":"1"},"title":"Insert excerpt"}},"localId":"f05a40de-9d00-452b-b4ab-6e1510b3701a"}}]}]}],"version":1}

Browser not supported