Page History

...

• mqtt_server_url
  • This is the MQTT Server endpoint URL. It must be of the form: ssl://ENDPOINT_URL:8883
• mqtt_server_name
  • Give it a meaningful name if desired
• mqtt_username
  • The username for the MQTT connection if required
• mqtt_password
  • The password for the MQTT connection if required
• primary_host_id
  • Set it to a text string such as 'IamHost'
• snowflake_streaming_client_name
  • Some text string such as 'MY_CLIENT'
• snowflake_streaming_table_name
  • This is the staged_sparkplug_raw_table created by the Snowflake setup in SQL Script 02
  • If the default Snowflake setup scripts were used, this is must be 'SPARKPLUG_RAW' based on the scripts we previously used to provision Snowflake
• snowflake_notify_db_name
  • This must be 'is the cl_bridge_node_db ' based on the scripts we previously used to provision Snowflake
  snowflake_
  • created by the Snowflake setup in SQL Script 06
  • If the default Snowflake setup scripts were used, this is 'cl_bridge_node_db'
• snowflake_notify_schema_name
  • This must be 'is the stage_db ' based on the scripts we previously used to provision Snowflakecreated by the Snowflake setup in SQL Script 06
  • If the default Snowflake setup scripts were used, this is 'stage_db'
• snowflake_notify_warehouse_name
  • This must be 'is the cl_bridge_ingest_wh ' based on the scripts we previously used to provision Snowflakecreated by the Snowflake setup in SQL Script 07
  • If the default Snowflake setup scripts were used, this is 'cl_bridge_ingest_wh'

When complete, it should look similar to what is shown below.

...

Configuring the snowflake streaming profile

...