Versions Compared

Old Version 4

changes.mady.by.user Gill Houghton

Saved on

compared with

New Version 5

changes.mady.by.user Gill Houghton

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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)Image Added

Terminology

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

Ignition EdgeMQTT SparkplugSnowflakeSnowflake tables/views
Ignition UDT DefinitionSparkplug TemplateModelTemplate_Reference
Ignition UDT InstanceSparkplug Template InstanceModel InstanceDevice_Name

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.

...