Index

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

A

Add byte offset within the file

Creates a new column containing each row’s byte offset in its source file.

Add file modification time

Creates a new column containing the modification time of the file where each row originated from.

Add file path

Creates a new column containing the path of the file where each row originated from.

C

Calculate Columns

Applies simple arithmetic to two columns.

Combine Columns

Concatenates multiple columns to a new column with an optional glue string.

Convert column from CamelCase to snake_case

Convert names of all columns or specific columns from CamelCase to snake_case.

Copy

Creates a new column with the same content as an existing column.

Copy Previous Value

In a column, fills blank cells with the last non-blank value above them.

Cut Text

Cut text from a column.

D

Decode a column

Replaces encoded text (base64 or URI) with its decoded counterpart.

Delete Columns

Removes the specified columns.

Delete Rows

Removes all rows that match a given filter.

Drop Columns

Removes the specified columns.

Duplicate Column

Creates a new column with the same content as an existing column.

E

Edit Text

Replace the whole content or parts of the content in a column.

Extract JSON Array to Sub-table

Extracts each value in a JSON array to a row in a sub-table.

Extract JSON Values with JMESPath

Creates a new column using the result of a JMESPath query.

Extract Root-Level Fields from JSON Object

Extracts each key and value at the root level of a JSON object into a new column, using the key as the column name and value as the cell content.

Extract Text

Pulls text out from a column into a new column.

F

Fill from Above

In a column, fills blank cells with the last non-blank value above them.

Fill Blank Cells

In a column, fills blank cells with the last non-blank value above them.

Flatten JSON Object

Parses a JSON tree and create a new column for each leaf property, using the key path as the column name and value as the cell content.

Fold Columns

Creates new rows by combining the values of multiple columns into one.

H

Hash Column

Replaces content with it’s hashed value using MD5 or SHA256.

I

Interpret Column as Date/DateTime

Converts column from text to a date or date time type using a custom specified format.

Interpret Timestamp

Interprets columns as epoch timestamps, and set the column time to datetime.

L

Look up geolocation from IP address

Resolves an IP address to its various geolocation attributes such as country, longitude, and latitude.

M

Merge

Concatenates multiple columns to a new column with an optional glue string.

P

Parse Text

Extracts text from a column to new columns using regular expression capturing groups.

Parse URL

Separates a URL into columns for hostname, path and query.

Parse URL query string

Creates a new column for each parameter in a URL query string.

Partition Output by Values

Partitions data in your data lake using column values. You can find more information on data partitioning here.

Promote row to header

Use the values in a specific row as column names.

S

Split JSON Array to Rows

Creates one row per value in a JSON array while duplicating other column values.

Split Column

Splits a single column into multiple columns or rows.

T

Transform Letter Case

Transform the letter case of text within a column.

Truncate Text to Redshift Varchar

Truncates text within a column to the maximum length of a Redshift VARCHAR.

U

Unfold Columns

Creates new columns by grouping the values of multiple rows in a single column.