Table Functions

Adds a new column with values computed from a function applied to each row.

Adds a sequential index column to a table.

Buffers a table into memory, ensuring it is fully evaluated and its row order is preserved.

Returns the column names of a table as a list of text values.

Appends multiple tables into a single table by stacking their rows.

Removes duplicate rows from a table based on all columns or specified criteria.

Duplicates a column in a table with a new name.

Expands a column of records into individual columns.

Expands a column of nested tables into individual columns in the parent table.

Replaces null values in specified columns with the most recent non-null value above.

Fills null values in specified columns with the next non-null value below.

Returns the first N rows from a table, or rows matching a condition.

Creates a table from a list of records.

Groups rows by key columns and applies aggregation functions to produce summary results.

Returns true if a table contains the specified column or columns.

Returns true if a table contains no rows.

Returns the last N rows from a table, or rows matching a condition from the end.

Joins two tables on matching key columns and returns the matched rows from the second table as a nested table column.

Rotates distinct values from an attribute column into new column headers, aggregating corresponding values.

Prefixes all column names in a table with a given text value.

Returns a profile of the values in each column of a table.

Promotes the first row of a table to column headers.

Returns a specified number of rows from a table starting at a given offset.

Removes the specified columns from a table.

Removes duplicate rows from a table based on one or more key columns.

Renames one or more columns in a table.

Reorders columns in a table to a specified order.

Replaces occurrences of a value in specified columns using a replacer function.

Reverses the order of rows in a table.

Returns the number of rows in a table.

Returns a table describing the columns (schema) of the input table.

Returns a table with only the specified columns.

Returns a table of rows from the input table that match a selection condition.

Skips the first N rows of a table, or rows matching a condition.

Sorts the rows of a table using one or more comparison criteria.

Applies transformation functions to the values in one or more columns.

Transforms the types of the specified columns in a table.

Transforms specified columns into attribute-value pairs, normalizing a wide table into a tall, narrow format.

Unpivots all columns except the specified ones into attribute-value pairs.