Skip to main content

Connect DbVisualizer

DbVisualizer is a popular SQL client you can install on your local machine.

Prerequisites​

  • Install DbVisualizer here.

Step 1: Get your SQL endpoint URL​

  1. In the Onehouse console, open the Clusters page, then click into your SQL Cluster. sql_endpoint_url
  2. Next, you will securely connect to the SQL endpoint URL through your virtual private cloud (VPC). The following sections will walk you through each approach.

Step 2: Connect to your VPC​

By default, SQL Clusters only accept traffic from within your VPC. To submit queries with DbVisualizer on your local machine, follow these steps to connect through a VPN or bastion host.

Step 3: Connect DbVisualizer to your SQL Cluster​

  1. In DbVisualizer, connect to a new database and select Hive.
  2. Under the Database section, enter the SQL Cluster endpoint connection details.
    1. Host:
      1. If connecting through a VPN, use the SQL endpoint URL from the Onehouse console
      2. If connecting through a bastion host, use localhost
    2. Port: 10000 (or your local forwarded port)
  3. After successful connection, DbVisualizer will show all databases and tables in the catalog.
  4. Use DbVisualizer to run read/write queries on your data.

dbvisualizer_console