Generate Sequence

This article is specific to the following platforms - Snowflake - Redshift - BigQuery - Synapse.

Generate Sequence Component

The Generate Sequence component generates a sequence of rows from a starting value to an end value with a user-defined increment.

This component can be used to generate empty rows of data from nothing, for use in a job.

Property	Setting	Description
Name	String	A human-readable name for the component.
Starting Value	Integer	The sequence value of the first generated row.
Increment Value	Integer	The number to increment the sequence by on each iteration.
End Value	Integer	The maximum value of the sequence. This does not need to be part of the sequence.
Output Column	String	Specify the name of the output column that contains the sequence value.

Table of contents