Snowflake

nile has enhanced its capabilities by adding support for snowflake, enabling the transmission of three distinct categories of data once snowflake is properly configured in the control center (nile portal), it administrators can select the specific data to be sent, which includes alerts, audit logs, and end user device events the alerts category comprises five subcategories nile service alerts, nile infrastructure alerts, security alerts, application related alerts, and customer infrastructure alerts, specifically pertaining to their dhcp, radius, and dns servers audit events serve to document the change tracking activities that admin users perform within the control center, commonly referred to as the nile portal this comprehensive tracking mechanism ensures accountability and transparency regarding modifications made by admin users in parallel, the end user device events provide a detailed account of each device's connectivity logs, capturing crucial information for both wired and wireless devices this dual approach not only facilitates the monitoring of user actions but also enables the assessment of device connectivity, thereby enhancing overall network management and security these capabilities enables nile's customers to run their own analytics, retain data for compliance and auditing purpose and security settings to integrate nile with snowflake, the following need to be configured on the snowflake nile supports user and password or user and private key option for authentication please refer to this document on private key based authentication on snowflake https //docs snowflake com/en/user guide/key pair auth https //docs snowflake com/en/user guide/key pair auth snowflake settings url user / password (for basic auth) or private key (for key based authentication) warehousename database name schema name table name role name typically, snowflake admins would create a warehouse, add a database, schema and a table for purposes of ingesting the incoming nile data a role would have to be created and assigned to the user that is intended for use by nile that will authenticate with snowflake and make write, post, read requests nile settings in the control center (nile portal) go to global settings > integrations > click on the '+' to add a new integration, choose snowflake from the listed options on the next screen, select the categories to subscribe to events, alerts related to selected category will be sent from the nile cloud into snowflake click save ❗the name of the integration needs to be set to the string 'default' whichever integration is set to name as 'default' that is treated as the primary siem integration from nile's perspective if the 'name' of the integration being added is not set to 'default' that receiver will not get any data from nile cloud once the snowflake settings are saved, a tile showing snowflake configured will appear as below under the integrations the categories of data subscribed to can be seen on the tile for snowflake testing capability the snowflake tile will show a 'test' button to test the connectivity and authentication from nile cloud to the snowflake a successful test will show the status as up, if the authentication or connectivity from nile cloud is failing, the status will show as down