====Snowflake====

The Snowflake output module allows you to write data to the Snowflake cloud database.

If your output parameters include a //time// parameter, these are recorded with a matching timestamp, creating a historical record of your data.

If you omit the //time// parameter, it will act like a simple key-value store, with the values being overwritten. 

^Parameter^Default^Meaning^
|**user**||The name of the database user|
|**password**||The database password|
|**account**||The full account name to connect to|
|**warehouse**||The data warehouse where the table is found|
|**schema**||The schema where the table is found|
|**database**||The name of the database|
|**table**||The name of the table to connect to|
|**name**||The name of the field to write the **point name** to|
|**value**||The name of the field to write the **value** to|
|**time**||The name of the field to write the **time** to (if any)|

===Example===

<code>
[
   {
       "method": "snowflake",     
       "user": "myuser",   
       "password": "mypass",
       "warehouse": "WH_COMPUTE",
       "schema": "sensordata",
       "database": "alertdb",
       "table": "alerts",
       "name": "code",
       "value": "status",
       "time": "stamp"
   }
]
</code>

//The above example would connect to Snowflake and write to the **alertdb** database, located within the **sensordata** schema. When new values appear, they'd be written to the **alerts** table, with the point name in the **code** column and the value in the **status** column.//

===Other Modules===

Return to the [[key-value methods|list of output modules]].