Construct Struct Component

Construct Struct Component


This article is specific to the following platforms - BigQuery.

Construct Struct Component

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

Property Setting Description
Name Text The descriptive name for the component.
Column Mapping Mapping 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 stuctured data, the Source Column is a list of values and the Target Column is their respective key.
Output Column Text 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.