Skip to content

Construct Struct

Creates structured data from flat columns and outputs the structure into a new column.

The structured data can be thought of as key:value pairs. This component creates new 'Target' Columns with the form <StructName>.<KeyName> and each row in that column would be <Value>.


Name = string

A human-readable name for the component.

Column Mapping = column editor

Choose a Source Column from the data flow in your Transformation job and map it to a new Target Column with a name of your choosing. In the context of structured data, the Source Column is a list of values and the Target Column is their respective key.

Output Column = string

Specify a new column that your structured data will populate. When sampling data, this will appear as a prefix to Target Column names. Thus, all columns with the same prefix can be considered part of that same structure.

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