Column Transform

Transforms are optional pieces of logic that can be applied to a column to either alter its data, or generate new separate data.

📘

Supported Transformations

Coalesce supports all transformation functions supported by Snowflake.

Transformation logic can be authored inline by double clicking in the Transform field or within the Column Editor. Optionally, Macros may be used to encapsulate logic and to reduce code duplication for frequently used transformations. By default, if no transformation is specified, a column will reference the column specified in the Source column of the Mapping Grid.

🚧

Remember the Data Type!

Set the data type of your column to match the expected output of your transformation!