Skip to content

Construct Variant

This component allows the user to create a variant-type column that collapses rows into arrays of key:value pairs.

Each value in the new column takes the form of a Snowflake object, see OBJECT_CONSTRUCT for more information.


Name = string

A human-readable name for the component.

Column Mapping = column editor

Select pairings for Source and Target columns. In the resulting Key:Value pairs, the values are taken from the Source columns and the Keys are the Target column names.

Output Slot = string

The name of the outputted constructed variant column.

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