This article outlines the integration steps for Telmai with Snowflake.
Snowflake is a multi-cloud data warehouse optimized for analytics workloads and requiring little maintenance.
Telmai monitors the data in the Snowflake instance to identify anomalies like outliers and drifts. Telmai is designed to read your data once and process it outside your DW architecture to reduce any monitoring load on your Snowflake DW.
This article outlines the integration steps with Snowflake.
1: Create Telmai user account
Generate a key-pair in your snowflake account for Telmai. Instructions can be found here, step 1 through 3 needs to be followed.
2: Provide access to tables/views
Now create a dedicated, read-only user for Telmai and grant permissions on the tables you want Telmai to monitor.
Please make sure you are whitelisting those IP addresses. These IPs are for the SaaS version of the product, running in the US West. For the private cloud or other regions deployment they will be provided separately.
By default, Snowflake instances are open to every IP address, so no action is required. However, if you have set up network policies to restrict the IP addresses communicating with Snowflake instance, you'll need to modify these policies to allow the Telmai IP address. There are two types of network policies : account level and user level.
Account level policies apply to all users unless the policy is overridden by a user level policy. User level policies only apply to the users that the policy is assigned and user level policies will override account level policies. Please refer to the Snowflake documentation for more information on modifying network policies.
[TODO] Support for Change data capture and batch processing