Concepts

When a JSON object is provided in a message, it is sometimes desirable to convert the properties that are identified within that JSON object into separate fields (columns). This allows SQL and other traditional database APIs to access the properties.

Data can be formatted in various ways according to your needs (for more information see "binaryFormat").

The "jsonToTableFields" transform action can be used to take specified properties from a JSON object in one table and store them as separate fields in a record in a separate table.

You can define a transform using the "createTransform", "alterTransform", or "describeTransform" JSON actions (for additional information on transform actions, see Advanced transforms concepts).