User Guide

1.3
- 1.2
- 1.1
- 1.0

Back Next

Avro Generic Schema Format

An Avro schema that uses the generic format can be used for any source table. The schema represents the source columns as an array of fields for data and metadata. Most of the columns have the type "string" to be generic across multiple source table types. The column name and type is included in every Avro message along with the data.

A generic schema has the following format:

{"name" : "columns",
    "type" : [ "null", {
      "type" : "array",
      "items" : {
        "type" : "record",
        "name" : "column",
        "doc" : "A column for the table",
        "fields" : [
        {"name" : "name", "type" : [ "null", "string" ], "default" : null},
        {"name" : "value", "type" : [ "null", "string" ], "default" : null},
        {"name" : "isPresent","type" : [ "null", "boolean" ],"default" : null},
        {"name" : "beforeImage","type" : [ "null", "string" ], "default" : null},
        {"name" : "isPresentBeforeImage", "type" : [ "null", "boolean" ], "default" : null}
        ]
      }
    } ]

Rename Saved Search

Table of Contents

User Guide

User Guide

Avro Generic Schema Format

Avro Generic Schema Format