Versions Compared

Old Version 24

changes.mady.by.user Nathan Davenport

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.


Info
titleUpcoming IoT Bridge for Snowflake v2.0.0 release

We are in the process of updating this documentation for the upcoming release of the This documentation is for the IoT Bridge for Snowflake v2.0.0.

The IoT Bridge Snowflake Streaming profile configuration documentation v1.0.0 through v1.0.3 can be found found here.


The IoT Bridge Snowflake Streaming Profile (snowflake_streaming_profile.json) contains configuration specific to ingesting bridge data into Snowflake through the Snowpipe Streaming API.

...

  • user
    • Replace with the user provisioned in Snowflake and granted the processor_role created by the Snowflake setup in SQL Script 07IoT Bridge Setup Assistant
    • If following the IBSNOW: AWS QuickStart or IBSNOW: Azure QuickStart documents and using the default Snowflake setup scriptsconfiguration when running the IoT Bridge Setup Assistant to setup Snowflake resources, 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:

...

  • account
    • Replace with the subdomain of your URL

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

    • ueb12345 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 Snowflake setup scriptsconfiguration 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 Snowflake setup scriptsconfiguration 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 Snowflake setup scriptsconfiguration 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 Snowflake setup scriptsconfiguration when running the IoT Bridge Setup Assistant to setup Snowflake resources, this is 'cl_bridge_process_rl'

...