It should take only 5 minutes!

Reminder: Only admins can connect a new data source!

Go to your Data Sources page in the Settings

In the upward corner, click on your workspace, and go to Settings

Select Snowflake in the list of data providers

In Settings, subcategory Data Sources - Select Snowflake

It will open a modal.

Snowflake connection modal - Refer Name, Host, Port, Database, Username, Password, Warehouse name, Rôle name

Fill in the connection form

Start by giving this new data source a relevant display name. It will help you identify this data source in Husprey.

Enter your Snowflake account, in the account_locator.region form. Your Snowflake account is whatever comes before snowflakecomputing.com when you sign into Snowflake directly. Then, enter the database name, and your credentials (username and password).

Note that these credentials will be used for all queries run in Husprey. If you rather want each analyst to use their own personal set of credentials, please contact us so that we can activate the appropriate option on your workspace.

Optional parameters

If you wish, you can specify the default warehouse and role to be used for each query run in Husprey.
See Appendices below for more details on warehouses and roles.

Connect

You should now be good to go! As soon as the first data model sync finished, you can run your first query 🥳


Update the default warehouse

After setting up your Snowflake database, you still have the possibility to edit the connection settings. Go to the Data Sources page in the Settings, and open the 3-dot menu of the Snowflake data source. Select Edit connection.

In Settings, subcategory Data Sources. Go to your Snowflake connection 3-dot menu. Select Edit connection

It will then open a modal.

Edit connection modal - Change default connection warehouse

You can select another default connection warehouse from available ones.


Troubleshooting

If you experience any issue while trying to connect to your data source, please ensure that your firewall accepts incoming requests from the following IP addresses:

15.188.244.40
15.236.67.17

In any case, do not hesitate to contact us directly on support@husprey.com so we can help you out connecting your data source in Husprey.


Appendix: Warehouses

Using different warehouses can help you balance query speed and costs. Learn more about Snowflake warehouses with this Getting Started video from Snowflake.

Warehouse selection is performed in Snowflake with the following priority:

  • At the query level. Enforce a warehouse for a specific query using USE <warehouse> SQL statement.

  • At the connection level. Define a default warehouse in Husprey connection form

  • At the user account level. Default warehouse for a user. This can be edited from Snowflake settings. (Suggested default usage)

Read more about warehouse usage in Snowflake documentation.


Appendix: Roles

Snowflake uses roles to control objects that users can access (virtual warehouses, databases, tables, etc.). Snowflake provides a set of predefined roles, as well as a framework for defining a hierarchy of custom roles.

Read more about roles in Snowflake documentation.

Did this answer your question?