Snowflake
Connect to a Snowflake warehouse from Equals
To connect to Snowflake you need four pieces of information: Account URL
, Database name
, Username
, Password
. The Default schema field is optional.
- To find your
Account URL
, open your Snowflake dashboard and go to Admin > Accounts. - Find the account you want to connect to (you may have one or multiple), hover over the name, and click the link button to copy the URL. Paste this value (it should be of the form
XXX.snowflakecomputing.com
) into Equals. - To find your Database name, click Data in the dashboard sidebar, make sure Databases is selected under Data.
- You will now see a list of your databases, copy the
Database name
of the database you want into Equals. - Finally, you need to enter the
Username
andPassword
with access to the database. If you’re unsure of what to enter here ask for help from whoever set up Snowflake for your company.
Allowing access from our IP
You may need to allow connections from Equals IP address. To do so:
- In the Snowflake dashboard go to Admin > Security, ensure Network policies is selected in the tab bar at the top.
- If you have no active policies, Equals should be able to access your database. If you have an active policy, continue following these steps.
- Click the “…” menu beside your active policy, then “Edit Policy.
- Paste Equals’ IP address
54.68.61.53
in the text field under X allowed IP addresses and press enter. - Click Save changes. Equals should now be able to access your database.
Updated 8 months ago