run SQL Script for Snowflake

[talendstar]

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]

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

[Anonymous]

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.