Transformation Components

Window Calculation Component

Window Calculation Component Allows the user to set up a calculation using a window function. Window functions allow users to query tables for a partition of a data set, termed a 'window'....

Rewrite Table Component

Rewrite Table Component Write the input data flow out to a new table. Runtime errors may occur, for example if a data value overflows the maximum allowed size of a field. Note:...

Table Output Component

Table Output Component Write the input data flow out to an (existing) output table Note: Successful validation of this component ensures the target table exists, and the target columns have been found....

Delete Rows Component

Table Delete Rows Component Delete rows from a target table. Rather than delete a set of rows based on a static condition, this component deletes rows based on matching rows to the...

Table Update Component

Table Update Component Update a target table with a set of input rows. The rows to update are based on matching keys. It is very important that the keys uniquely identify the...

Split Field Component

Split Field Component Split up the value of a column in an input flow according to a specified delimiter. This delimiter can be any valid character or sequence of characters. Properties Property...

Transpose Columns Component

Transpose Columns Map sets of input columns into new output columns. This effectively performs an unpivot on the data. This component re-shapes data by outputting multiple rows for each individual input row....

Transpose Rows Component

Transpose Rows Component This component is the opposite of the the Transpose Columns component. Like other aggregates, multiple rows are combined into a single output row (one for each value of the...

Detect Changes Component

Detect Changes Component Scan two separate yet similar tables, and insert a new column detailing if data has been inserted, deleted, changed or is unchanged. Any rows with key columns containing null...

Create View Component

Create View Component The "Create View" component allows you to output a view definition to the Redshift cluster. In some circumstances, that may be preferable to writing the data to a physical...