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

You can use "jsonPropertiesToExternalFields" to create transforms for different integration tables that input to the same external table. External tables identify which integration table the records come from by database_name, schema_name, and table_name. This allows the same transform pipeline to be assigned to more than one integration table at the same time.

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.