topic run SQL Script for Snowflake in Talend Studio

run SQL Script for Snowflake

talendstar — Thu, 12 Sep 2019 20:41:40 GMT

Is it possible to run a SQL Script for Snowflake from within Talend.

The SQL consists of various statements. Some create temporary tables that are referenced later in the SQL.

Basically it is a multi-statement SQL script.

thanks

manodwhb — Fri, 13 Sep 2019 07:22:59 GMT

@talendstar ,As per my knowledge , tSnowflakeRow is not supporting to execute multiple scripts,you can execute for one script.

Anonymous — Thu, 08 Oct 2020 07:27:22 GMT

The simplest solution consists in 3 components:

load your script with tFileInputDelimited or tFixedFlowInput from pasted text within "inline content"
- configure row separator as ";" and field separator as "#"
- add attribute column "content" of type String
iterate over individual query statements (newline separators are allowed)
- link your input row with tFlowToIterate (e.g. row1)
- link your iteraation with tSnowflakeRow
execute query: (String)globalMap.get("row1.content")

In case you need to render your script from input parameters, then you may want to look at Talend SQL templates.