Decoders
Decode data formats into kdb.
CSV
Parse CSV data to a table.
| item | description |
|---|---|
| Delimiter | Field separator for the records; default to ,. |
| Header | Defines whether source CSV file has a header row; default to Always, alternatives are First Row and Never. |
| Schema | Schema of output data. A list of types to cast the data to as q type characters. |
Schema example
"SS*ip"
- See Column Types for more information.
JSON
Decodes JSON Content.
- Decode Each
- When enabled, parsing is done on each value of a message.
JSON schema
The JSON decoder expects to receive a JSON string that defines an array of objects that contain <column name>: <value> pairs, e.g. [{column1: 1, column2: 1}, {column1: 2, column2: 2 }]
Protocol Buffers
Decodes Protocol Buffer encoded data.
| item | description |
|---|---|
| Message Name | Name of the Protocol Buffer message object to use for decoding objects |
| Message Definition | The definition of the Protocol Buffer message format to decode. |
| Includes Fields | When enabled, the output will include field names and values |
Definition Example
json
Person {
string name = 1;
int32 id = 2;
string email = 3;
}