Transform
Applies a schema to the data.
- Click to edit
- Right-click to remove
Apply Schema
Create a schema; add/remove columns or assign a pre-configured schema.
| item | description |
|---|---|
| Data Format | The stream data format; specify a type to increase performance. |
| Schema | Enter a column name and column type for each column in the data. Missing columns will be dropped, and non-existent columns will be created with null values. |
| item | description |
|---|---|
| Column Name | Give the assigned column a name. |
| Column Type | Define the kdb+ type for the assigned column. |
| Parse Strings | Indicates if parsing of data type is required. Parsing of input data should be done for all time, timestamp, and string fields unless your input is IPC or RT |
Schemas Require a Timestamp Partition Column
Schemas require a timestamp data column. In addition, the table should be partitioned and sorted (interval, historic and/or real-time) by this timestamp column. This can be configured as part of the set up wizard, or with the essential and advanced properties of a schema.
Load Schema
Load a schema from an existing Insights Schema. This will overwrite the configured schema of the node with the schema selected from the dropdown menu.