Versions Compared

Old Version 90

changes.mady.by.user Nathan Davenport

Saved on

compared with

New Version 91

changes.mady.by.user Nathan Davenport

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

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.

Warning
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  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 Snowflake IoT Bridge EC2 instance via SSH. See this document for information on how to do this.

...