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.


Properties

Name = string

A human-readable name for the component.


Column Mappings = 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.

Click the Add all button to automatically populate the Source and Target columns with all the column names from the input source. You can then selectively edit the list if required, but if you click Add all again it will return the list to the default fully populated state, removing any changes you have made.


Output Slot string

The name of the outputted constructed variant column.


Snowflake Databricks Amazon Redshift (preview)