# 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