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