# 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) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.datapancake.com/guides/how-to-guides-ui/creating-and-configuring-data-sources/how-to-modify-the-schema.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.