Connecting Snowflake to Rupert allows Sylvan to tap into your query-ready datasets and power real-time, intelligent monitoring — without requiring you to move or duplicate your data.
Once connected, Sylvan 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 Sylvan Labs
To connect a Snowflake instance to Sylvan, 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 Sylvan
Navigate to the Connections page in Sylvan, 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 Sylvan.
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 Sylvan 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 Sylvan’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. Sylvan 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 Sylvan will issue for you.
Please us send via the intercom messenger the following details:
Account identifier
User
DB name
ℹ️ You can read more about this process here