Contents
Cirrus Link Resources
Cirrus Link Website
Contact Us (Sales/Support)
Forum
Cirrus Link Modules Docs for Ignition 7.9.x
Inductive Resources
Ignition User Manual
Knowledge Base Articles
Inductive University
Forum
Page History
...
Find the IoT Bridge Setup Assistant Snowflake application in the Snowflake Marketplace.
Click into the offering and click the Request button to submit a request for the IoT Bridge Setup Assistant application.
Cirrus Link will typically approved the request within 24 hours. Once the request has been fulfilled, the IoT Bridge Setup Assistant application will be visible in Data Products → Apps. Click the 'Get' button download and install the application.
After completing this step, the IoT Bridge Setup Assistant is installed as shown below.
The IoT Bridge Setup Assistant 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: To run the application, simply click on the installed IoT Bridge Setup Assistant Snowflake application running post-install>application and follow the steps shown.
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.
| Tip | ||
|---|---|---|
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.
|
<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 by running the script generated in this step in a worksheet, the application will display the following message indicating that setup is now complete..
Confirm your Snowflake resources (databases, stored procedures, user defined functions, roles, warehouses, etc) have been successfully created by the script execution.
<Screenshot Placeholder: IoT Bridge Setup Assistant Snowflake 'Setup Complete'>
IoT Bridge Setup
...
Overview
Content Tools