Search…
Snowflake
This article outlines the integration steps for Telmai with Snowflake.

Introduction

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.
1 : Download script(download)
2: Modify the parameters in the script :
set user_password = '4556-$%%-oooo-#@'; -- Change this password
set warehouse_name = 'COMPUTE_WH'; -- Change to your warehouse name
set database_name = 'TESTDB'; -- Change this database name to your database
set db_schema_name = 'TESTSCHEMA'; -- Change this schema name to your schema
set db_table_name = 'SUPPLIER'; -- Change this table name to your table
alter user identifier($user_name) set rsa_public_key = 'MII...'; -- change to the public key from step 1
3: Run the update script in your snowflake console.

3: Add Snowflake source to Telmai

Now add the above source to Telmai using REST API or UI

REST API reference

UI Configuration

2: Go to left navigation, Configuration -> Connect to Data->Snowflake
3: Provide connection details
Account : This is the Hostname of snowflake service
Database : database from step 2
Schema : hostname from step 2
Table : name of table/view
User and Private Key from step 2
Create Snowflake source
Note : Whitelisting Telmai IP’s
Telmai makes calls to your warehouse from one of the following static IPs:
34.83.35.170, 34.127.25.248, 35.197.36.54, 35.247.63.70, 35.247.82.119, 35.247.83.128
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
Copy link
On this page
Introduction
1: Create Telmai user account
2: Provide access to tables/views
3: Add Snowflake source to Telmai