Using Snowflake with Interzoid

Connecting Interzoid to your Snowflake account is simple. All you need is a connection string that tells Interzoid how to reach your Snowflake instance. You can copy and paste the format below and replace the placeholders with your own values.

Basic Connection String


{user}:{password}@{account}/?warehouse={warehouse}&db={database}&schema={schema}

Replace {user}, {password}, {account}, {warehouse}, {database}, and {schema} with your own values. This is all you need to get started.

Advanced: Read-Only Access

For added security, we recommend granting Interzoid access through a read-only setup. With Snowflake, this can be done either by creating a dedicated read-only user/role or by setting up a Snowflake Reader Account.

Option 1: Read-Only User and Role

Create a new user just for Interzoid (for example, INTERZOID_APP_RO).
Assign a role with read-only permissions to the databases, schemas, or tables you want Interzoid to use.
Use that user and role in your connection string.


interzoid_app_ro:StrongPassword123@myaccount.us-east-1.aws/?warehouse=interzoid_wh&db=interzoid_db&schema=public&role=INTERZOID_READONLY

Option 2: Snowflake Reader Account

A Reader Account is a special Snowflake feature that allows you to securely share the desired data with an external party (like Interzoid).

Your Snowflake admin creates a Reader Account dedicated to Interzoid.
You share only the specific databases, schemas, tables, or views you want Interzoid to read.
You create a user and role inside that Reader Account for Interzoid, with read-only permissions.
You provide the connection details to Interzoid, just like a normal connection string.


interzoid_tool_user:StrongPassword@interzoid_reader.us-east-1.aws/?warehouse=interzoid_wh&db=interzoid_db&schema=public&role=INTERZOID_READER_ROLE

Using a Reader Account gives you complete control. You decide exactly what to share, and you can revoke access at any time by disabling the user, revoking the role, or unsharing the data.

Key Notes

You remain in full control of your Snowflake data.
You can revoke third party access at any time by disabling the user, removing the role, or unsharing the objects.
Reader Accounts are especially useful when you want to isolate external access from your primary Snowflake account.

Questions? Contact support@interzoid.com.