IBSNOW: Account Properties

Account Format 1

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://LOCATOR.us-east-1.snowflakecomputing.com",
  "account": "xxxxxxxx",
  "private_key_file": "/opt/ibsnow/conf/certs/rsa_key.p8",
  "port": 443,
  "host": "LOCATOR.us-east-1.snowflakecomputing.com",
  "schema": "stage_db",
  "scheme": "https",
  "database": "cl_bridge_stage_db",
  "connect_string": "jdbc:snowflake://LOCATOR.us-east-1.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_wh",
  "role": "cl_bridge_process_rl"
}

Account Format 2

Account Identifier: ORGANIZATION.ACCOUNT

Account URL: https:/LOCATOR.snowflakecomputing.com

This account format results in a working configuration of:

{
  "user": "IBSNOW_INGEST",
  "url": "https://LOCATOR.snowflakecomputing.com:443",
  "account": "xxxxxxxx",
  "private_key": "zzzzzzzzzz",
  "port": 443,
  "host": "LOCATOR.snowflakecomputing.com",
  "schema": "stage_db",
  "scheme": "https",
  "database": "cl_bridge_stage_db",
  "connect_string": "jdbc:snowflake://LOCATOR.snowflakecomputing.com:443",
  "ssl": "on",
  "warehouse": "cl_bridge_ingest_wh",
  "role": "cl_bridge_process_rl"
}