| Warning |
|---|
| title | New IoT Bridge for Snowflake Available |
|---|
|
This document covers v2.0.0 and older versions of IoT Bridge for Snowflake. It now ships as part of Chariot. To see the latest IoT Bridge for Snowflake documentation, go to IoT Bridge for Snowflake in Chariot. |
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 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_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 Contains the column IS_GOOD |