● SNOWFLAKE

Managing your Connections is easy. Here are the steps:

  1. To add a new connection, navigate to the File tab and click on Edit Connections, or press [⌘ + O] | [Ctrl + O].
  2. In the dialog box, click the Add icon (➕) next to the Connections header and select Snowflake.

mceclip1.png

3. To finish creating a connection, enter valid data in the fields of the New connection dialog.

mceclip0.png

  • Connection name – Replace the default New Connection with a meaningful value.
  • Database JDBC DRIVER – Specify user drivers for the data source, or click the 'download them' link below this field settings area. For detailed instructions on setting up drivers, see Add a user driver to an existing connection.
  • Host – Snowflake automatically determines the host address by concatenating the account name you specified and the Snowflake domain (com).

🔎 TIP:  See an example with an account name by region using this link

  • Authentication – The default value is Standard, which uses the internal Snowflake authenticator.

Another available type is SAML – Snowflake's externalbrowser uses your web browser to authenticate with Okta, ADFS, or any other SAML 2.0-compliant identity provider (IdP) that has been defined for your account.

  • User and Password – Enter your Snowflake credentials.
  • Role – Specify your security role within your team. If you don't know your role, leave this field blank.
  • Database – Select the default database you're going to use in the client session.
  • Warehouse – Select a warehouse that will support the operations in a Snowflake session. If you don't know which specific warehouse to use, contact your Snowflake DBA.
  • Connection timeout (sec) – Specify the value to tell the session when to disconnect.
  • Advanced Properties – Supply additional JDBC parameters if needed.
  1. Click Test to ensure that the connection to the data source is successful.
  2. Click Save. A newly created connection will be displayed in your Database Explore panel just right under the Connections header.

🔎 NOTE:  If you need more advanced information on how to set up a Snowflake connection, please, contact us through support@aginity.com

 🔎 TIP:  Here is the link to other configurable parameters supported within Snowflake's JDBC driver

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.