Snowflake

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

ParameterDefaultMeaning
userThe name of the database user
passwordThe database password
warehouseThe name of the data warehouse
schemaThe name of the data schema
databaseThe name of the database
sqlINSERT INTO events (start,end,message) VALUES ('%S','%E','%M')The sql statement to execute, including event codes
timezoneUTCThe timezone to write date data in.

Example (Event)

[
   {
       "type": "event",
       "method": "snowflake",
       "account": "account-id"
       "user": "myuser",   
       "password": "mypass",
       "warehouse": "WH_COMPUTE",
       "schema": "events",
       "database": "eventlog",
       "sql": "INSERT INTO events (start,end,message) VALUES ('%S','%E','%M')",
       "timezone": "Australia/Sydney"
   }
]

Other Modules

Return to the list of output modules.