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>.

---

Properties

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
❌	❌	❌	✅	❌