Skip to main content

Concepts

Concepts for using the JSON properties to external table transform method

Abstract

concepts for using the JSON properties to external table transform method

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 "jsonPropertiesToExternalFields" 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).

Important

The "jsonToDifferentTableFields" transform does not manage the relational integrity between the output and input tables. This means that if an output integration table is deleted, the records that have been transformed into an external table will remain.