Skip to content


The First/Last component allows users to create groups of data and then return only the first or last rows from the group.


Name = string

A human-readable name for the component.

Grouping Columns = _dual listbox

Defines how the input data is grouped. This works like an SQL "group by" statement. The first or last element of each group will be selected.

Ordering within partitions = column editor

  • Input Column: The input column name for sorting within the grouped data. You can drag to reorder.
  • Ordering: The order of the sorting: Ascending (Asc) or Descending (Desc).

First/Last Columns = column editor

  • Column: The name of the input column to be passed to the output.
  • First/Last: Return the First or Last element of the chosen column in the grouped data.

Ignore Nulls = drop-down

Select whether to ignore null values. The default setting is No.


Generates a select statement with a window function in line using the OVER keyword.

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics