First-Last

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

• Snowflake Window functions.
• AWS Window functions.
• BigQuery Window functions.

Properties

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.

---

Strategy

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

• Snowflake First Value.
• Snowflake Last Value.
• Redshift First Value and Last Value.
• BigQuery First Value.
• BigQuery Last Value.

---

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