Upcoming IoT Bridge for Snowflake v2.0.0 release

We are in the process of updating this documentation for the upcoming release of the IoT Bridge for Snowflake v2.0.0. The IoT Bridge Snowflake Streaming profile configuration documentation v1.0.0 through v1.0.3 can be found here.


The IoT Bridge Snowflake Streaming Profile (snowflake_streaming_profile.json) contains configuration specific to ingesting bridge data into Snowflake through the Snowpipe Streaming API.

Modifying Configuration

You will need to modify the /opt/ibsnow/conf/snowflake_streaming_profile.json file to match your system configuration and setup as follows:

  • user
    • Replace with the user provisioned in Snowflake and granted the processor_role by the IoT Bridge Setup Assistant
    • If following the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents and using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is the "IBSNOW_INGEST" user granted the "cl_bridge_process_rl" role
  • url
    • Replace with the copied account URL from your Snowflake account. Variations include:
      • https://ueb12345.snowflakecomputing.com
      • https://ueb45678.us-east-1.snowflakecomputing.com
      • https://abcdgbi-lw11250.snowflakecomputing.com
      • https://rab12345.prod3.us-west-2.aws.snowflakecomputing.com


  • account
    • Replace with the subdomain of your URL
    • ueb12345 for URL example https://ueb12345.snowflakecomputing.com

    • ueb12345 for URL example https://ueb45678.us-east-1.snowflakecomputing.com
    • abcdgbi-lw11250 for URL example https://abcdgbi-lw11250.snowflakecomputing.com
    • rab12345 for URL example https://rab12345.prod3.us-west-2.aws.snowflakecomputing.com
  • private_key_file
    • Replace with the file path of your private key file
  • port
    • Must be set to "443"
  • host
    • Replace with the domain name of your URL
    • ueb12345.snowflakecomputing.com for URL example https://ueb12345.snowflakecomputing.com

    • ueb12345.us-east-1.snowflakecomputing.com for URL example https://ueb45678.us-east-1.snowflakecomputing.com
    • abcdgbi-lw11250.snowflakecomputing.com for URL example https://abcdgbi-lw11250.snowflakecomputing.com
    • rab12345.prod3.us-west2.aws.snowfalkecomputing.com for URL example https://rab12345.prod3.us-west-2.aws.snowflakecomputing.com
  • schema
    • Replace with the staging_schema created by the Snowflake setup in SQL Script 06
    • If using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'stage_db'
  • database
    • Replace with the staging_db created by the Snowflake setup in SQL Script 07
    • If using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'cl_bridge_stage_db'
  • connect_string
    • Replace the scheme "http://" in your url with "jdbc:snowflake://" and add the port as "443"
    • jdbc:snowflake://ueb12345.snowflakecomputing.com:443 for URL example https://ueb12345.snowflakecomputing.com

    • jdbc:snowflake://ueb12345.us-east-1.snowflakecomputing.com:443 for URL example https://ueb45678.us-east-1.snowflakecomputing.com
    • jdbc:snowflake://abcdgbi-lw11250.snowflakecomputing.com:443 for URL example https://abcdgbi-lw11250.snowflakecomputing.com/
    • jdbc:snowflake://rab12345.prod3.aws.snowfalkecomputing.com:443 for URL example https://rab12345.prod3.us-west-2.aws.snowflakecomputing.com
  • warehouse
    • Replace with the cl_bridge_ingest_wh created by the Snowflake setup in SQL Script 07 
    • If using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'cl_bridge_ingest_wh'
  • role
    • Replace with the processor_role created by the Snowflake setup in SQL Script 07
    • If using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'cl_bridge_process_rl'


Configuration Examples

Example 1 using default scripts

{
  "user": "IBSNOW_INGEST",
  "url": "https://ueb12345.snowflakecomputing.com",
  "account": "ueb12345",
  "private_key_file": "/opt/ibsnow/conf/certs/rsa_key.p8",
  "port": 443,
  "host": "ueb12345.snowflakecomputing.com",
  "schema": "stage_db",
  "scheme": "https",
  "database": "cl_bridge_stage_db",
  "connect_string": "jdbc:snowflake://ueb12345.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_wh",
  "role": "cl_bridge_process_rl"
}

Example 2 using default scripts

{
  "user": "IBSNOW_INGEST",
  "url": "https://ueb45678.us-east-1.snowflakecomputing.com",
  "account": "ueb45678",
  "private_key_file": "/opt/ibsnow/conf/certs/rsa_key.p8",
  "port": 443,
  "host": "ueb45678.us-east-1.snowflakecomputing.com",
  "schema": "stage_db",
  "scheme": "https",
  "database": "cl_bridge_stage_db",
  "connect_string": "jdbc:snowflake://ueb45678.us-east-1.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_wh",
  "role": "cl_bridge_process_rl"
}

Example 3 using default scripts

{
  "user": "IBSNOW_INGEST",
  "url": "https://rab12345.prod3.us-west-2.aws.snowflakecomputing.com",
  "account": "rab2345",
  "private_key_file": "/opt/ibsnow/conf/certs/rsa_key.p8",
  "port": 443,
  "host": "rab12345.prod3.us-west-2.aws.snowflakecomputing.com",
  "schema": "stage_db",
  "scheme": "https",
  "database": "cl_bridge_stage_db",
  "connect_string": "jdbc:snowflake://rab12345.prod3.us-west-2.aws.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_wh",
  "role": "cl_bridge_process_rl"
}

  • No labels