Page History

...

Configuring the Snowflake properties

Modify the file /opt/ibsnow/conf/ibsnow.properties file. Set the following:

• 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
•  mqtt_ca_cert_chain_path
  • The path to the Root Certificate if required
• mqtt_client_cert_path
  • The path to the Client Certificate if required
• mqtt_client_private_key_path
  • The path to the Client Private Key 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 must be 'SPARKPLUG_RAW' based on the scripts we previously used to provision Snowflake
• snowflake_notify_db_name
  • This must be 'cl_bridge_node_db' based on the scripts we previously used to provision Snowflake
• snowflake_notify_schema_name
  • This must be 'stage_db' based on the scripts we previously used to provision Snowflake
• snowflake_notify_warehouse_name
  • This must be 'cl_bridge_ingest_wh' based on the scripts we previously used to provision Snowflake

...

Configuring the snowflake streaming profile

Now, modify the file /opt/ibsnow/conf/snowflake_streaming_profile.json file as described in Setting snowflake_streaming_profile configuration

...