View Source

This document covers v2.0.0 and older versions of IoT Bridge for Snowflake. It now ships as part of Chariot. To see the latest IoT Bridge for Snowflake documentation, go to IoT Bridge for Snowflake in Chariot.

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

MQTT Modules for Ignition 8.3 > IBSNOW: Setting snowflake_streaming_profile configuration > snowflakeaccounturl.png

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"
}