Page History

...

If you don't have a Snowflake account, open a Web Browser and go to https://www.snowflake.com. Follow the instructions there to start a free trial. After creating an account, log in to Snowflake via the Web Console. You should see something like what is shown below.

IoT Bridge Setup Assistant

Find the IoT Bridge Setup Assistant Snowflake application in the Snowflake Marketplace and install it. This application will aid in creating and configuring all required Snowflake databases, stored procedures, user defined functions, roles, warehouses, etc. 

...

• 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_sparkplug_subscriptions

  • Optionally, customize your Sparkplug MQTT subscriptions
• mqtt_subscriptions
  • Optionally, uncomment and customize your non-Sparkplug MQTT subscriptions
• mqtt_username
  • The username for the MQTT connection if required
  • If using Chariot MQTT Server, the default username is 'admin'
• mqtt_password
  • The password for the MQTT connection if required
  • If using Chariot MQTT Server, the default password is 'changeme' 
• 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 'SPARKPLUG_RAW'
• snowflake_notify_db_name
  • This is the cl_bridge_node_db 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 is the stage_db created 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 is the cl_bridge_ingest_wh created by the Snowflake setup in SQL Script 07
  • If the default Snowflake setup scripts were used, this is 'cl_bridge_ingest_wh'

...