Page History

...

Modifying Configuration

...

You will need to modify the /opt/ibsnow/conf/snowflake_streaming_profile.json file

...

"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 user provisioned in Snowflake

...

• • granted the processor_role created by the Snowflake setup in SQL Script 07
  • If following the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents using the default Snowflake setup scripts, 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

  ...

  • • 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.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

  ...

  • • 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'

  
  

  Configuration Examples

  ...

  Example 1 using default scripts

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

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

  Using modified scripts

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