This document will help you connect your Snowflake data warehouse to Zenlytic to access modern, LLM-powered business intelligence.

First, you'll name your connection. This name is how Zenlytic's model connects the credentials you'll enter in the next step to your data warehouse. You can name the credential whatever you want, but we usually recommend naming it something like my_company_name to keep things simple.

The account in Snowflake is how we know which Snowflake warehouse to connect to. To get this value look at the URL for your Snowflake (e.g. https://blah12345.us-east-1.snowflakecomputing.com/console) and take the part after https:// and before snowflakecomputing.com.

In this example, you'd enter blah12345.us-east-1 for your account.

This is the username of your user in Snowflake. This can be found in the upper right hand of the page when you're logged in.

In this example, the username is pblankley

This is the password associated with the user you logged in with. Enter the value in the input.

Warehouses in Snowflake are units of compute, not a place to store data. The default warehouse is COMPUTE_WH, but you can use whichever warehouse you want. To see warehouse options for your role, select from the drop-down in the Snowflake UI.

In this example, we'll use the REPORT_WH warehouse.

Here you'll select the snowflake database you want to use as a default in Zenlytic. You can always use data from other databases. This one just acts as a default. You can also see database options in the drop-down in the Snowflake UI.

In this example, we're using the ZENLYTIC database.

The role in Snowflake is the set of permissions you want your user to have. This field is optional, and if you leave it blank, Snowflake will use your user's default role. You can find roles your user has access to in the upper right of the Snowflake UI.

In this example, we're using the REPORTER role. Note: if the role you select doesn't have access to certain data in your warehouse, Zenlytic will be unable to access that data as well.

This is the schema you want to use as a default. This field is optional and is usually left blank.

We also offer the ability to connect with an ssh key pair in addition to username / password as shown above. To connect, contact your Zenlytic rep to get the public key to use when creating the access in Snowflake.

If you use IP whitelisting in your data warehouse, whitelist the following IP addresses:

You can ignore this section if you're not using a Snowflake Share directly.

Advanced settings in Snowflake deal with situations where you're running analysis directly on data you've received via a Snowflake Share. Since Zenlytic uses Temporary Tables for functionality like Explain Change, you'll need to specify a Zenlytic database and schema Zenlytic will use to manifest temporary tables. To fulfill this requirement, you can create any database and schema with nothing in them.

Create a database and enter that database name (e.g. zenlytic_database)

Create a schema and enter that schema name (e.g. zenlytic_schema)