Page History

...

Modifying Configuration

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"

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

...

• 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
  • 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 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 Snowflake setup scripts, this is 'stage_db'
• database
  • Replace with the staging_db created by the Snowflake setup in SQL Script 07
  • If using the default Snowflake setup scripts, 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 Snowflake setup scripts, 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 Snowflake setup scripts, this is 'cl_bridge_process_rl'

...