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_DB | SPARKPLUG_DEVICE_MESSAGES | SPARKPLUG_DEVICE_MESSAGES SPARKPLUG_DEVICE_REGISTRY SPARKPLUG_EDGE_NODE_REGISTRY SPARKPLUG_TEMPLATE_DEFINITION_REGISTRY SPARKPLUG_TEMPLATE_INSTANCE_REGISTRY |
| Streams under CL_BRIDGE_NODE_DB.STAGE_DB | DEVICE_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_DB | DEVICE_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 |
| Tables under CL_BRIDGE_STAGE_DB.STAGE_DB | SPARKPLUG_RAW | SPARKPLUG_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_MESSAGES | Contains a DDATA_MSG column with the JSON payloads | Metric values are extracted out into separate columns |