The "jsonToTableFields" transform extracts values from JSON properties and puts them into table fields. This allows SQL to query MQTT message content, empowering analysts and data scientists to leverage message data for reporting and machine learning.
When the payload of an MQTT message contains a JSON object, it is often desirable to store its properties into user-defined fields in the table. This allows SQL and other traditional database APIs to query the data.
All types of data embedded in JSON strings can be converted to field data according to your needs (see "binaryFormat").
You define a transform using the "transformSteps" property in the "createIntegrationTable" and "alterIntegrationTable" actions.