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