Dev4Snow

Go back to ContentsGo back to previous page

Configuring a Snowflake connection

When opening the application you will be prompted with the following screen:

NOTE: The screen may vary indicating that the Snowflake 64-bit ODBC driver is not installed. In that case you will be asked to download it from the link below. Download and install it before proceeding setting up the connection:

https://sfc-repo.snowflakecomputing.com/odbc/win64/latest/index.html

Panel 1 contains the saved connections. You can double-click on a saved connection to log in, or by clicking the Connect button. You can also click the Delete button to remove the highlighted connection after confirmation.

Panel 2 contains a form to define a new connection or to edit an existing connection. To edit an existing connection just click on it on panel 1 and all of its values will show up in panel 2. If you modify a connection but keep the same Name/Description it will replace the connection with the same name.

Name / Description: This is a description that uniquely identifies a connection. When clicking “Create or Update” this name will be compared with the list in panel 1, if the name exists it will replace the connection with the new values that you defined, if not it will create a new connection with the new values that you just defined.

Snowflake Server: Name of the Snowflake server that is used by your organization. Usually this is the format: <account>.snowflakecomputing.com

Authentication type: Select if you are authenticating using Single-Sign On (SSO)–usually verified by Azure, Okta, OAuth or by some other Identity Provider (IdP) configured by your Organization- , or with Snowflake Credentials –a username and password preconfigured directly in Snowflake.

Username: If using SSO this user is usually the email address that you are using to connect to your computer. Dev4Snow will try to infer the email address used in Windows and fill it automatically, but in case it’s different –or it didn’t fill it- just insert it manually.

Password: Only required if authenticating using Snowflake Credentials. If using Snowflake Credentials the password will be saved to Windows Credential Manager but also encrypted –so you cannot change it directly from Windows Credential Manager, in case you need to change it do it from this screen. When using SSO a browser will open automatically and you will be able to enter your credentials directly to the Identity Provider (IdP).

Warehouse: Optional. If left empty and there’s no default warehouse Dev4Snow will pick the smallest started warehouse available. If no warehouse is started the smallest warehouse available will be used.

Role: Optional. If left empty the default role will be used. Consider updating the connection with this field to avoid changing the role after each login.

Database: Optional. Default database that the application will use.

New / Clear fields: Use this button to reset all fields. Similar to manually deleting all fields.

Create or Update: After filling all the connection fields, use this button to validate the connection and create it –in case the Name/Description was not used before- otherwise it will update the existing connection with the new values.