Connecting Snowflake to Rupert allows Rupert to tap into your query-ready datasets and power real-time, intelligent monitoring — without requiring you to move or duplicate your data.
Once connected, Rupert can use its advanced analyzing capabilities, like anomaly detection and root cause analysis, to trigger smart workflows, surface insights, and help teams act faster and with greater confidence.
In this article we are going to cover the following topics:
In this article we are going to cover the following topics:
Step 1 - Create a user for Rupert
To connect a Snowflake instance to Rupert, open a new dedicated user with a read only permissions or use an existing user with the same permissions
Make sure the user is assigned the relevant warehouse as the default warehouse
Using an existing user
If you're using an existing user to connect Snowflake, make sure that user has default role and default relevant warehouse assigned.
There are 2 ways to change default warehouse / role:
Running the following queries:
ALTER USER [insert user name] SET DEFAULT_ROLE = 'insert role';
ALTER USER [insert user name] SET DEFAULT_WAREHOUSE = 'insert warehouse';In the UI, go to Admin > Users & Roles > edit the relevant user
Step 2 - Add the credentials in Rupert
Navigate to the Connections page in Rupert, go to Connections > Snowflake and open the Snowflake connection form.
Fill in the required fields
Source Name: Choose a clear name for this Snowflake source (e.g.,
Product Analytics,Marketing Warehouse)Account Identifier:
Log in to Snowflake.
On the left sidebar, scroll to the bottom and click your name (your user icon/profile).
In the menu that appears, under Account, click View account details.
In the Account Details dialog, you’ll see your Account Identifier (and related information).
Copy the identifier displayed and paste it in the account identifier field in Rupert.
Should look like this: ABCDEF - XYZ123 (but can be shorter).
Tip: if you switch roles or have multiple accounts, make sure the correct account is selected before viewing the details.
Database Name: The name of the Snowflake database Rupert should access.
Database User: Use the user with read-only user you've created or use an existing user
Generate & Register the Public Key
In Rupert, click "Generate Public Key"
Copy the SQL code that appears
Paste it into a worksheet in Snowsight under the target database
Run the command
✅ You should see: "Statement executed successfully."
Allow Rupert’s IP Address (if needed)
If your Snowflake environment is protected by a firewall, allow inbound access from:
34.123.149.4Click Connect
Once everything is filled out and the key has been added, click Connect. Rupert will verify the connection and securely link to your Snowflake instance.
Note: If you would like to connect another database, add another Snowflake source and make sure the source name describe the DB you've connect
Connect an account with two factor authentication
If your organization has 2 factor authentication, the connection will be formed using private keys Rupert will issue for you.
Please us send via the intercom messenger or to support@hirupert.com the following details:
Account identifier
User
DB name
ℹ️ You can read more about this process here