Page History

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

Modifying Configuration

You will need to modify the /opt/ibsnow/conf/snowflake_streaming_profile.json file to match your system configuration and setup as follows:

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

...