DB - Snowflake

review the snowflake integration guide docid\ wdtwysda i4vp9j71kwip overview snowflake integration enables an edge system to connect with snowflake’s data warehouse supported communication outbound (write from edge to snowflake) yes inbound (read from snowflake to edge) no account privilege requirements review the snowflake account privilege requirements for successfully connecting sysadmin allows you to connect and create a new database table accountadmin allows you to connect, but you can't create a new database table the following account privileges won't allow you to successfully connect public, useradmin, and securityadmin configurations variable detail required name enter a name for the connector yes account snowflake account id with region ( \<accountid> \<region> ) yes username username yes password password yes database database name yes schema schema name yes warehouse warehouse name yes table table name yes create table create the table if it doesn’t exist you must have the appropriate permissions no throttling limit set a limit on the number of outbound messages per second if sending data to a server that has restrictions on the rate of incoming messages, this ensures that no messages are lost no persistent storage if enabled, messages in the outbound queue are stored on disk if there are interruptions in connection or power loss, messages will be retained and eventually sent when the connection is restored no queue mode select the sequence of data transfer fifo or lifo selecting fifo (first in first out) will send the earliest message first selecting lifo (last in first out) will send the latest message first no