New IoT Bridge for Snowflake Available

This document covers v2.0.0 and older versions of IoT Bridge for Snowflake. It now ships as part of Chariot. To see the latest IoT Bridge for Snowflake documentation, go to IoT Bridge for Snowflake in Chariot.


These are the new additions to the ibsnow.properties file from V1 to V2: 

# IBSNOW schema version. Defines the IoT Bridge for Snowflake schema to be used when calling stored procedures
# Schema Versions
#   1 - deployed through SQL scripts on https://docs.chariot.io
#   2 - deployed through SQL scripts via the IoT Bridge Setup Assistant native Snowflake application
ibsnow_schema_version = 1
# Comma separated list of MQTT subscription topic:QoS pairs (e.g. a/#:0,b/#:0)
# mqtt_subscriptions.1 = 
# Maximum number of rows to insert into the snowflake_streaming_table at once. Set to 0 for no limit.
snowflake_max_streaming_insert_batch_size = 0

# Maximum number of rows to insert into the snowflake_mqtt_streaming_table at once. Set to 0 for no limit.  
snowflake_max_mqtt_streaming_insert_batch_size = 0

# Do raw MQTT inserts one topic at a time
snowflake_topic_based_mqtt_streaming_insert = false

# Ingest task execution period (in seconds)
snowflake_streaming_ingest_task_period = 1

# Raw MQTT ingest task execution period (in seconds) 
snowflake_mqtt_streaming_ingest_task_period = 1
# Snowflake streaming connection properties - A channel name prefix to the channel scheme defined above
# This is required when IBSNOW is deployed in a redundant configuration
# This prefix should be unique to this IBSNOW instance
#snowflake_streaming_channel_scheme_prefix = 
# Snowflake streaming connection properties - The Table name for RAW MQTT data.
snowflake_mqtt_streaming_table_name = MQTT_RAW

# Maximum number of streaming channels for RAW MQTT messages
# snowflake_max_mqtt_streaming_channels =
# The number of times to retry the NotifyIngest task on failure 
snowflake_notify_nbirth_retries = 10
# NotifyTimerTask keep alive in seconds. This setting allows to kill inactive threads after keep-alive expires.
snowflake_notify_task_keep_alive = 60

# Enable performance metrics such as 'NotifyIngest thread pool info' and 'Message Inflow Rates' per EdgeNode or topic.
snowflake_enable_performance_metrics = true
  • No labels