Schema Transformations

When creating a view, you can virtually transform the schema of any of the fields within the indexed data structure. The ChaosSearch virtual transformations provide powerful features to create additional or custom view columns while leaving the source indexed data intact and available for different transformations with other views for other users or purposes.

To create a transformation:

1. While in the create view process, and in the Schema Transformation window, select or search for the column that you want to transform.
2. Click the gear icon at the right end of the column row. The Schema Transformation window opens.

3. In the Schema Transformation window, you can select from several predefined transformations.
4. Select the desired transformation type, and supply any additional content as applicable, then click Save Transform.

The transformation options include the following:

The Treat as transforms essentially set the data type for the column to the specified data type for the purposes of visualization and analysis. The Materialize transforms are used to create additional specific columns in the view for analysis and filtering, as described in the following sections.

Regular Expression Transformations

As an example of a Materialize with Regex transformation, if you have a log file with a field that contains a string of web URL data, you might want to transform the field into three virtual/materialized columns that each contain a specific part such as the domain, port, and path components for use with analysis or filtering purposes.

After selecting the URL field and clicking the gear icon to transform it:

1. Make sure that Materialize with Regex is selected as the transformation.
2. Type the regular expression pattern to use for each field, such as (\\S+[ :])(\\d+)(\\S+) as an example. See Refinery Transformation Regex for other sample patterns.
3. Click Add Field to add three fields, and name them domain, port, and path. Make sure that domain and path are STRING types, while port is a NUMBER type.
4. Click Refresh to update the Preview pane and review the transformation. If there are any errors or changes, you can update the regular expression and/or fields and refresh again.
5. Click Save Transform when finished.

After saving your transformation changes, the Schema Transformation window shows the transformed fields as in the following example:

JSONPath Transformations

If an indexed data field contains JSON string content, you can use this transformation to specify one or more specific JSON properties as a materialized column for analytics. In many implementations, JSON string content supports only text searching within their content, but the ChaosSearch Materialize with JSONPath transformation allows you to specify a JSON path value to select a property within the JSON string, and to create a materialized column for the view. The JSON string blob remains intact for text searches and other analysis.

After selecting the JSON string field and clicking the gear icon to transform it:

1. Make sure that Materialize with JSONPath is selected as the transformation.
2. Click Add Field to create a placeholder for each field that you want to transform.

3. Type the JSONPath expression pattern to identify each property that you want to materialize as a column. You can use third-party tools such as the online JSON path formatter to create the required JSON path value. In this example, a simple JSNPath is used to isolate the connect:version property as a new column named version.
4. Click Refresh to update the Preview pane and review the transformation. If there are any errors or changes, you can update the path expression and/or fields and refresh again.
5. Click Save Transform when finished. The new virtual column shown on the Schema Transformation window.