Snowflake

This guide describes how to connect Aporia to a Snowflake data source in order to monitor your ML Model in production.

We will assume that your model inputs, outputs and optionally delayed actuals can be queried with SQL. This data source may also be used to connect to your model's training set to be used as a baseline for model monitoring.

Create a read-only Service Account for Snowflake access

In order to provide access to Snowflake, create a read-only Service Account for Aporia in Snowflake.

Please use the SQL snippet below to create the Service Account for Aporia. Before using the snippet, you will need to populate the following:

<aporia_password>: Strong password to be used by the service account user.
<your_database>: Snowflake database with your ML training / inference data.

-- Configuration
set aporia_username='APORIA';
set aporia_password='<aporia_password>';
set aporia_role_name='APORIA_ROLE';
set dbname='<your_database>';

-- Set role for grants
USE ROLE ACCOUNTADMIN;

-- Create the role Aporia will use
CREATE ROLE IF NOT EXISTS identifier($aporia_role_name);

-- Create Aporia's user and grant access to role
CREATE USER IF NOT EXISTS identifier($aporia_username) PASSWORD=$aporia_password DEFAULT_ROLE=$aporia_role_name;
GRANT ROLE identifier($aporia_role_name) TO USER identifier($aporia_username);

-- Grant read-only privileges to the database
GRANT SELECT ON ALL TABLES IN DATABASE identifier($dbname) TO ROLE identifier($aporia_role_name);
GRANT SELECT ON ALL VIEWS IN DATABASE identifier($dbname) TO ROLE identifier($aporia_role_name);

USE DATABASE identifier($dbname);

Create a Snowflake data source in Aporia

Go to Aporia platform and login to your account.
Go to Integrations page and click on the Data Connectors tab
Scroll to Connect New Data Source section
Click Connect on the Snowflake card and follow the instructions
1. Note that the provided URL should be in the following format jdbc:snowflake://<ACCOUNT_IDENTIFIER>.snowflakecomputing.com

PreviousRedshift NextMicrosoft SQL Server

Last updated 1 year ago

-- Configuration set aporia_username='APORIA'; set aporia_password='<aporia_password>'; set aporia_role_name='APORIA_ROLE'; set dbname='<your_database>'; -- Set role for grants USE ROLE ACCOUNTADMIN; -- Create the role Aporia will use CREATE ROLE IF NOT EXISTS identifier($aporia_role_name); -- Create Aporia's user and grant access to role CREATE USER IF NOT EXISTS identifier($aporia_username) PASSWORD=$aporia_password DEFAULT_ROLE=$aporia_role_name; GRANT ROLE identifier($aporia_role_name) TO USER identifier($aporia_username); -- Grant read-only privileges to the database GRANT SELECT ON ALL TABLES IN DATABASE identifier($dbname) TO ROLE identifier($aporia_role_name); GRANT SELECT ON ALL VIEWS IN DATABASE identifier($dbname) TO ROLE identifier($aporia_role_name); USE DATABASE identifier($dbname);