Generate Sequence
    • Dark
      Light

    Generate Sequence

    • Dark
      Light

    Article Summary

    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.

    Properties

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Starting ValueIntegerThe sequence value of the first generated row.
    Increment ValueIntegerThe number to increment the sequence by on each iteration.
    End ValueIntegerThe maximum value of the sequence. This does not need to be part of the sequence.
    Output ColumnStringSpecify the name of the output column that contains the sequence value.