Versions Compared

Old Version 28

changes.mady.by.user Gill Houghton

Saved on

compared with

New Version Current

changes.mady.by.user Gill Houghton

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • account
    • Replace with the subdomain of your URL

    • ueb12345 for URL example https://ueb12345.snowflakecomputing.com

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

    • ueb12345ueb45678.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 configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'stage_db'
  • database
    • Replace with the staging_db created by the Snowflake setup in SQL Script 07
    • If using the default configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, 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://ueb12345ueb45678.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 configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, 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 configuration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'cl_bridge_process_rl'

...