Year: 2021
Snowflake generate sequence without gaps
This example shows how to use ROW_NUMBER to generate a sequence without gaps:
Snowflake JSON
Example SQL reading native JSON data:
JVM arguments: Massively parallel talend processes
-Xms8g -Xmx100g -XX:+UseParallelGC -XX:+UseAdaptiveSizePolicy -XX:GCTimeRatio=19 -XX:MinHeapFreeRatio=20 -XX:InitiatingHeapOccupancyPercent=10
Display Runtime SQL: Talend
If you need to print a SQL run by any tDBinput_ component: System.out.println(((String)(((org.talend.components.snowflake.tsnowflakeinput.TSnowflakeInputProperties)globalMap.get(“tDBInput_3_COMPONENT_RUNTIME_PROPERTIES”)).getValuedProperty(“query”).getValue()))); ? You just need to ensure you’re giving the right “tDBInput_” name