Page History

Default Configuration

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"

"private_key_file": "/opt/ibsnow/conf/rsa_key.p8"

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

Modifying Configuration

You will need to modify this file to match your system configuration and setup as follows:

• user
  
  • Replace with the the user provisioned in Snowflake with the "CL_BRIDGE_PROCESS_RL" role
  • If following the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents, this is the user created with username "IBSNOW_INGEST"
• 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://rab12345.prod3.us-west-2.aws.snowflakecomputing.com

Image Added

• 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
  • 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
  • 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 for URL example https://ueb45678.us-east-1.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 scripts provided in the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents, this is 'stage_db'
• database
  • Replace with the staging_db created by the Snowflake setup in SQL Script 07
  • If using the default scripts provided in the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents, 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:443 for URL example https://ueb45678.us-east-1.snowflakecomputing.com
  • jdbc:snowflake://rab12345.prod3.us-west2.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 scripts provided the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents, this to 'cl_bridge_ingest_wh'
• role
  • Replace with the processor_role created by the Snowflake setup in SQL Script 07
  • If using the default scripts provided in the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents, this to 'cl_bridge_process_rl'

Configuration Examples

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

Account Format 1

Image Removed

Account Identifier: ORGANIZATION.ACCOUNT

Account URL: https:/LOCATOR.us-east-1.snowflakecomputing.com

This account format results in a working configuration of:

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

Account Format 2

Image Removed

Account Identifier: ORGANIZATION.ACCOUNT

Account URL: https:/LOCATOR.snowflakecomputing.com

This account format results in a working configuration of:

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

Using modified scripts

{
  "user": "MY_IBSNOW_INGEST_USER",
  "url": "https://LOCATORueb12345.snowflakecomputing.com:443",
  "account": ueb12345"xxxxxxxx",
  "private_key_file": "zzzzzzzzzz/mycerts/privatekeys/my_rsa_key.p8",
  "port": 443,
  "host": "LOCATORueb12345.snowflakecomputing.comcom",
  "schema": "stagemy_staging_db",
  "scheme": "https",
  "database": "clmy_bridge_stage_db",
  "connect_string": "jdbc:snowflake://LOCATORueb12345.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_whmy_warehouse",
  "role": "clmy_bridge_process_rlrole"
}