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