Snowflake generate sequence without gaps
This example shows how to use ROW_NUMBER to generate a sequence without gaps:
Tag: Snowflake
Snowflake JSON
Example SQL reading native JSON data:
Snowflake Local Timezone
To record timestamps in local timezone format nicely in via Talend use datatype: TIMESTAMPLTZ(3) To display without the offset value set session variable: ALTER SESSION SET TIMESTAMP_LTZ_OUTPUT_FORMAT = ‘YYYY-MM-DD HH24:MI:SS.FF3’