Snowflake Integration Guide

review the following guide for setting up an integration between litmus edge and the snowflake data warehouse before you begin you will need a snowflake account with the sysadmin privilege step 1 add device follow the steps to connect a device docid 3eyafppweuvmblcey17sq the device will be used to store tags that will be eventually used to create outbound topics in the connector make sure to select the enable data store checkbox step 2 add tags after connecting the device in litmus edge, you can add tags docid 8se7z3pmrfwl1nmzcwalx to the device create tags that you want to use to create outbound topics for the connector step 3 create snowflake database you will need to create a database in snowflake that will be used to receive the data from litmus edge to create the snowflake database log in to snowflake navigate to data > databases click + database the new database dialog displays enter a name for the database optionally, add a comment click create the new database is created click the new database name, and then click + schema the new schema dialog displays enter a name for the schema optionally, add a comment if needed, select the checkbox for managed access click create the new schema is created you can now set up the connector in litmus edge to send data to this new database and schema step 4 add the db snowflake connector follow the steps to add a connector docid\ ogw7fkqbwidbabn4wl5rr and select the db snowflake provider configure the following parameters name enter a name to identify the connector account enter the snowflake account name and id refer to the account identifier located under the account details in snowflake see account identifiers to learn more example qcllymw bz92275 username enter your snowflake username password enter your snowflake password database enter the database name you configured in step 3 schema enter the schema name you configured in step 3 warehouse enter the warehouse name that will be used for the integration navigate to admin > warehouse for your list of current warehouses see virtual warehouses to learn more table enter a table name where the data will be displayed create table select this checkbox if the table name configured doesn't exist yet a new table will be created commit timeout enter the transaction commit timeout in (ms) max transaction size enter the maximum number of messages before a transaction is committed, regardless of timeout parameter bulk insert count to buffer messages, enter a value bulk insert will be performed once this value is reached throttling limit the maximum number of messages per second to be processed the default value is zero, which means that there is no limit persistent storage when enabled, this will cause messages to undergo a store and forward procedure messages will be stored within litmus edge when cloud providers are online queue mode select the queue mode as lifo (last in first out) or fifo (first in first out) selecting lifo means that the last data entry is processed first, and selecting fifo means the first data entry is processed first step 5 enable the connector after adding the connector, click the toggle in the connector tile to enable it if you see a failed status, you can review the manage connectors docid 3u7jzldinehy8shvifd d and relevant error messages step 6 create outbound topics for connector you will now need to import the tags you added in step 2 to the connector as topics to create outbound topics click the connector tile the connector dashboard appears click the topics tab click the add tags icon the add subscription dropdown appears click the +add a new subscription in dropdown menu the create subsubscription dialog appears for publishing litmus edge data to aws sitewise asset measurement, define the following data direction = local to remote outbound local topic = any topic in litmus edge remote topic = asset measurement alias defined on the aws sitewise portal the measurement alias is a user defined string for each measurement can be found under the alias column description = description for the subscription optional field click ok to add the subscription step 7 enable topics ensure the topics you imported are enabled by returning to the topics tab and clicking the enable all topics icon step 8 verify connection in snowflake database access the snowflake database you created to verify that data is successfully being sent