# How to Modify the Schema

### 1. Navigate to the Data Sources page

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/70687be1-bc6b-46e1-ba6a-c12e9fde1845/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=93,238)

### 2. Select the data source

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/0646f064-84ea-463f-9088-dc410aa10156/ascreenshot.jpeg?tl_px=0,49\&br_px=1376,818\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=430,277)

### 3. Scroll down to the Schema Transformation section

Schema transformations are used to modify the source schema during the materialization process.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/5c810102-82a4-4148-a7eb-3fc335dbf410/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=340,167)

### 4. Click the + symbol in the bottom row to add a new schema transformation

To delete a row move your mouse to the leftmost column in the table to reveal a checkbox, check the box, and press the delete key.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/4e7b11b6-75cc-4fed-a69c-c25d8910a83f/ascreenshot.jpeg?tl_px=0,38\&br_px=1376,807\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=267,277)

### 5. Add the required schema transformation properties

For this guide we will add four transforms. See the table below the screenshots for exact values

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/c68b83f0-01fb-439d-b475-6500dd06e91f/ascreenshot.jpeg?tl_px=164,53\&br_px=1541,822\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=722,277)

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/37bc5ea0-a876-4210-a190-537a8633a228/ascreenshot.jpeg?tl_px=164,81\&br_px=1541,850\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=593,277)

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/4a04a08c-9850-4c24-a38a-62d1cb051194/ascreenshot.jpeg?tl_px=164,110\&br_px=1541,879\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=536,276)

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/3427c7aa-5dcc-418a-8a6d-64a52e2f0cea/ascreenshot.jpeg?tl_px=164,148\&br_px=1540,917\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=524,277)

| Name         | Transformation Type        | Search Attribute Path | Search Expression                                                                                             | Replace Expression | String List Type | String Delimiter Value |
| ------------ | -------------------------- | --------------------- | ------------------------------------------------------------------------------------------------------------- | ------------------ | ---------------- | ---------------------- |
| transform\_1 | consolidate schema         |                       | Y\|Cre\|Shipment\|                                                                                            | \|\d+              |                  |                        |
| transform\_2 | transform string to array  | special\_tags\_pipe   |                                                                                                               |                    | primitive        | \|                     |
| transform\_3 | transform string to array  | batch\_tags\_pipe     |                                                                                                               |                    | primitive        | \|                     |
| transform\_4 | transform objects to array | operation\_logs       | ^op\_\[a-z]+-\[0-9a-fA-F]{8}-\[0-9a-fA-F]{4}-\[1-5]\[0-9a-fA-F]{3}-\[89abAB]\[0-9a-fA-F]{3}-\[0-9a-fA-F]{12}$ | codeId             |                  |                        |

### 6. Save the Schema Transformations

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/0ff4330c-61f6-4a26-8f37-2cb0f938bb61/ascreenshot.jpeg?tl_px=0,189\&br_px=1376,959\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=308,363)

### 7. Ensure the transformations/consolidations updated successfully

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-11-13/46750836-97be-4a2f-9d7c-dbfc8bdee1a3/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=480,137)