In order for Rupert to run queries, it needs to get restricted access. A read only user account allows your data team members to query your connected DB, without having to authenticate each time they use Rupert.
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 you 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 - Account identifier
Locate and copy your account identifier: located on the bottom of the worksheets view. Click the identifier to see the "copy to clipboard" option
Step 3 - Add the credentials in Rupert
Click the Manage Sources tab and add a new Snowflake source
Source name: name your source in Rupert, this should be short and meaningful
Account identifier
A read-only Snowflake username
A read-only Snowflake password for this username
Database name
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