How to Add Column Materialization Rules

Select your data source on the Pipeline Designer page

Navigate to the Transformation/Security tab

Search for the desired attribute in the editable grid

Scroll horizontally to view more columns

Update the materialization transformation type to SQL Expression

Enter the materialization transformation expression

For the JSON Tutorial, please [deploy the database tutorial objects], then for the expression use:

udf_std_part_number({attribute_name})

Enter the materialization transformation description

Click save attributes to apply changes