Last updated
Copyright © 2023 Arize AI, Inc
Last updated
One-time setup for the Arize File Importer Role and Snowflake Warehouse.
Scroll down to the if you've already completed the steps in this section.
Make sure you're using the securityadmin
Snowflake role, and create a Snowflake role called ARIZE_FILE_IMPORTER_ROLE
.
Create a Snowflake user called ARIZE_FILE_IMPORTER
Set the default role for the user as the ARIZE_FILE_IMPORTER_ROLE
role
Set the default warehouse for the user as the warehouse that was provisioned for Arize ()
Grant the ARIZE_FILE_IMPORTER_ROLE
role to the ARIZE_FILE_IMPORTER
user
Set the RSA_PUBLIC_KEY
for the ARIZE_FILE_IMPORTER
user
You can find the RSA Public Key in the Arize UI when setting up the Snowflake import job.
Grant the ARIZE_FILE_IMPORTER_ROLE
role USAGE
on the warehouse provisioned for Arize.
Follow the below steps when configuring access for new tables/schemas for Arize.
You can skip over steps 1 + 2 if you've already done those for the Snowflake database that contains your table/schema.
Create a Snowflake schema called arize
in your database if it doesn't already exist.
CREATE SCHEMA IF NOT EXISTS [DATABASE_NAME].arize;
Create a table within the arize
schema called arize_ingestion_keys
with the following columns: object_name
[string], object_type
[string], tag_name
[string], tag_value
[string]. This table is used to store the Arize Ingestion Keys. These keys act as challenge keys to prove ownership of Snowflake tables/schemas.
Insert a record into the arize_ingestion_keys
table for the table/schema you want to give Arize access to. The record should contain the Snowflake table/schema name as the object_name
, table
or schema
as the object_type
, arize-ingestion-key
as the tag_name
, and your Arize Ingestion Key (you can find this in the Arize UI when setting up the Snowflake import job) as the tag_value
.
Grant the following permissions to the ARIZE_FILE_IMPORTER_ROLE
:
USAGE
on the database (skip this if done previously)
USAGE
on the Snowflake schema that contains the table with your data
SELECT
on the Snowflake table that contains your data
USAGE
on the arize
Snowflake schema (skip this if done previously)
SELECT
on the arize_ingestion_keys
Snowflake table (skip this if done previously)
If you are still running into issues with connecting to Snowflake, please check your Snowflake network policy. You may need to whitelist the general .
If you aren't directly running the setup script in the Arize UI, this page goes over the permissions necessary to setup the Snowflake connector.