To use the driver to access data with DbVisualizer:

  1. Open DbVisualizer.
  2. From the menu, select Database>New Connection. When prompted to use the Connection Wizard, click OK.
  3. Provide the following information when prompted; then, click Next to proceed:
    • Connection alias: Type the name to be used when referring to this connection.
    • Driver: Select the alias that you provided for your driver from the drop-down menu.
  4. Provide values for the following fields; then, click Finish.
    • Database URL: Copy and paste your connection URL into this field. The following examples show how to connect using OAuth 2.0 authentication.
      Note: You can also generate connection strings using Snowflake Configuration Manager. For more information, see Generating connection URLs with the Configuration Manager.

      OAuth 2.0 Access token flow

      jdbc:datadirect:snowflake://snowflakecomputing.com;AccountName=account_name;
AuthenticationMethod=OAuth2;AccessToken=access_token;
    • Database UserId: If required by the authentication method being used (UserIdPassword), enter the user name. Alternatively, this value can be specified with the User property in the connection string.
    • Database Password: If required by the authentication method being used (UserIdPassword), enter the password. Alternatively, this value can be specified with the Password property in the connection string.
  5. To execute SQL statements, select SQL Commander>New SQL Commander. A SQL Commander tab opens.
  6. Select values for the following fields:
    • Database Connection: Select connection alias you provided for the connection from the drop-down menu.
    • Schema: Select the schema you want to execute queries against from the drop-down menu.
  7. In the SQL Commander tab, enter SQL commands you want to execute; then select SQL Commander>Execute. For example:

    To select all of the rows from the USERS table: 

    SELECT * FROM USERS

    To select the URLs for a specified issue: 

    SELECT * FROM AGENTS WHERE AGENTID = <ID>

    See "Supported SQL statements and extensions" for the supported syntax used to execute SQL statements.

    Note: If you are fetching large sets of data, you may want to limit the results using the Max Rows and Max Chars fields.
You have successfully accessed your data with DbVisualizer.