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
...
The You will need to modify the /opt/ibsnow/conf/snowflake_streaming_profile.json file contains the following default properties:
"user": "IBSNOW_INGEST"
"url": "https://ACCOUNT_ID.snowflakecomputing.com:443"
"account": "ACCOUNT_ID"
...
file
...
"port": 443
"host": "ACCOUNT_ID.snowflakecomputing.com"
"schema": "stage_db"
"scheme": "https"
"database": "cl_bridge_stage_db"
"connect_string": "jdbc:snowflake://ACCOUNT_ID.snowflakecomputing.com:443"
"ssl": "on"
"warehouse": "cl_bridge_ingest_wh"
"role": "cl_bridge_process_rl"
You will need to modify this file to match your system configuration and setup as follows:
...
ueb12345 for URL example https://ueb12345.snowflakecomputing.com
ueb12345.snowflakecomputing.com for URL example https://ueb12345.snowflakecomputing.com
jdbc:snowflake://ueb12345.snowflakecomputing.com:443 for URL example https://ueb12345.snowflakecomputing.com
...
Excerpt |
---|
{ "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" } |
{
"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"
}
{
"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"
}
{
"user": "MY_IBSNOW_INGEST_USER",
"url": "https://ueb12345.snowflakecomputing.com",
"account": ueb12345",
"private_key_file": "/mycerts/privatekeys/my_rsa_key.p8",
"port": 443,
"host": "ueb12345.snowflakecomputing.com",
"schema": "my_staging_db",
"scheme": "https",
"database": "my_bridge_db",
"connect_string": "jdbc:snowflake://ueb12345.snowflakecomputing.com:443",
"ssl": "on",
"warehouse": "my_warehouse",
"role": "my_bridge_role"
}