Page History

Data can be view in the databases created by the Snowflake Setup Scripts during your initial setup:

• Staging database created by SQL Script 01 (e.g., CL_BRIDGE_STAGE_DB)
• Node database created by SQL Script 02 (e.g., CL_BRIDGE_NODE_DB)

Terminology

As the data moves from the Ignition Edge device through MQTT Sparkplug and into Snowflake, different terminology will be used:

• model = Ignition UDT Definition = Sparkplug Template = Template_Reference in Snowflake tables/views
• model instance = Ignition UDT instance = Sparkplug Template instance = Device_Name in Snowflake tables/views

Data can be view in the databases created by the Snowflake Setup Scripts :

...

Staging Database

The Staging database contains only a single table, SPARKPLUG_RAW. This table contains information derived from each Sparkplug message, like the Sparkplug IDs: GroupId, EdgenodeId and DeviceId, the message timestamp, the model / model instance, the raw message payload in JSON, etc.

...