Skip to main content
The Construct Struct transformation component lets you create structured data from flat columns and output it into a new column. You map source columns to named target fields, and the component combines them into a BigQuery STRUCT type.

​
Use case

This component is useful when you need to group related flat columns into a single nested structure. For example, you can use it to:
  • Consolidate address fields such as street, city, and ZIP code into a single struct column.
  • Combine related metadata fields into a nested structure before loading data to a target system.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Column mappings
column editor
required
Map source columns from the data flow to named target fields in the output struct. Click the field to open the Column mappings dialog.
  • Source Column: Select a source column from the data flow using the drop-down.
  • Target Column: Enter the name for the corresponding field in the output struct.
Use the drag handles on the left of each row to reorder mappings. Select the checkbox next to a row to mark it for removal.
  • Add all: Click Add all to add all available source columns as mappings at once.
  • Click + to add a new empty mapping row.
  • Click - to remove the selected mapping rows.
Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables.
​
Output column
string
required
The name of the new column that your structured data will populate.