Page History

Prerequisites

• Install IoT Bridge for Snowflake into your Azure account
  • Before being able to access the Virtual Machine you must have completed the installation process here.

• Install an MQTT Server configured with a real signed TLS certificate

  
  

  Tip
  This quickstart guide uses the Chariot MQTT Server which can be installed as a free trial from the Azure Marketplace. Review the Chariot MQTT Server Configuration for details on how to upload the necessary certificates and keys for enabling SSL/TLS

  
  

  Note

  If you choose not to use Chariot MQTT Server, any Sparkplug compliant MQTT Server will work. Warning Azure IoT Hub is not Sparkplug compliant Warning AWS IoT Core has a message size limit of 128KB and will disconnect the client if it receives a message that exceeds this limit. If you have a large number of UDT definitions/instances and/or have very large UDTs, you will very likely hit this limit when sending your UDTs to AWS IoT Core. Review this document for ways to reduce the message size.

  
  

  
  

  
  

...

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. 

<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake application in the Marketplace>

Once the IoT Bridge Setup Assistant is installed, launch it by navigating to the application under Data Products → Apps.

<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake application running post-install>

Navigate to 'Setup Step 1' to accept default configuration as it defined or customize the configuration as desired. Note the cl_bridge_reader_warehouse must already exist and the cl_bridge_snowflake_user_public_key must contain the public key created following the steps below.

Generate an unencrypted key pair and copy the public key contents into the cl_bridge_snowflake_user_public_key text area. This will be used for authentication by the IoT Bridge for Snowflake application to push data to Snowflake via the Snowflake Streaming API.

See this document for details on how to generate this unencrypted key pair: https://docs.snowflake.com/en/user-guide/key-pair-auth. The IoT Bridge Setup Assistant will create the required IoT Ingest user and assign the public key provided to this user.

Note: The step "Configuring the Snowflake Client to User Key Pair Authentication" in the linked tutorial can be skipped.
The generated key MUST NOT be encrypted

<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake 'Setup Step 1'>

When 'Setup Step 1' configuration is finalized, click the 'Setup Environment' button and wait for the step to complete. Once complete, navigate to 'Setup Step 2'. This step will output a custom Snowflake SQL script with the configuration provided in Step 1 and this script will create all required Snowflake artifacts when executed. To run this script, follow the instructions in 'Setup Step 2'.

<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake 'Setup Step 2'>

Once Step 2 is complete, the application will display the following message indicating that setup is now complete.

<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake 'Setup Complete'>

IoT Bridge Setup

First you will need access to the Azure Virtual Machine via SSH. See this document for information on how to access the VM.

...