These are some differences between the V1 and V2 schemas. They can be used to determine which schema is in use: 


V1 Schema V2 Schema
Tables under CL_BRIDGE_NODE_DB.STAGE_DBSPARKPLUG_DEVICE_MESSAGESSPARKPLUG_DEVICE_MESSAGES
SPARKPLUG_DEVICE_REGISTRY
SPARKPLUG_EDGE_NODE_REGISTRY
SPARKPLUG_TEMPLATE_DEFINITION_REGISTRY
SPARKPLUG_TEMPLATE_INSTANCE_REGISTRY
Streams under CL_BRIDGE_NODE_DB.STAGE_DBDEVICE_RECORDS_STREAM
NBIRTH_STREAM		SPARKPLUG_BIRTH_DEATH_STREAM_DEVICES
SPARKPLUG_BIRTH_DEATH_STREAM_EDGE_NODES
SPARKPLUG_BIRTH_DEATH_STREAM_TEMPLATE_DEFINITION
SPARKPLUG_BIRTH_DEATH_STREAM_TEMPLATE_INSTANCE
SPARKPLUG_MESSAGES_STREAM
Views under CL_BRIDGE_NODE_DB.STAGE_DBDEVICE_RECORDS_VW
NBIRTH_VW
NODE_BIRTH_DEATH_VW
NODE_MACHINE_REGISTRY_VW
SPARKPLUG_MESSAGES_FLATTENED_VW
SPARKPLUG_MESSAGES_VW
SPARKPLUG_MSGS_NODEBIRTH_CONTEXTUALIZED_VW

SPARKPLUG_BIRTH_DEATH_STREAM_DEVICES_VW
SPARKPLUG_BIRTH_DEATH_STREAM_EDGE_NODES_VW
SPARKPLUG_BIRTH_DEATH_STREAM_TEMPLATE_DEFINITION_VW
SPARKPLUG_BIRTH_DEATH_STREAM_TEMPLATE_INSTANCE_VW
SPARKPLUG_BIRTH_DEATH_VW
SPARKPLUG_MESSAGES_FLATTENED_VW
SPARKPLUG_MESSAGES_VW

Tables under CL_BRIDGE_STAGE_DB.STAGE_DBSPARKPLUG_RAWSPARKPLUG_RAW
MQTT_RAW
Edge node views Asof View 
Base View 
Intermediate View 		Asof View 
Intermediate View
Columns in CL_BRIDGE_NODE_DB.STAGE_DB.SPARKPLUG_DEVICE_MESSAGESContains a DDATA_MSG column with the JSON payloads

Metric values are extracted out into separate columns 
Contains the column IS_GOOD

  • No labels

New to MQTT? Start Here!