Use DBeaver to connect to ADB

Anton Vasilev

To connect to ADB, you can use DBeaver — a third-party client tool that supports different databases.

Starting with version 25.2.1, DBeaver supports Greengage DB. In earlier versions of DBeaver, you can select Greenplum to connect to ADB.

For information on how to install DBeaver, refer to Installation.

Connect to ADB

To connect to ADB, launch DBeaver and follow the steps below:

  1. Click Database → New Database Connection and select Greengage in the Connect to a database window.

    If you use a version of DBeaver lower than 25.2.1, select Greenplum.

    Select a database type
    Select a database type

  2. In the Connection Settings window that opens, specify the following:

    • Host — the address of the ADB master host.

    • Database — the name of a database to connect to, for example adb.

    • Username — the database username, for example gpadmin.

    Supply connection settings
    Supply connection settings

  3. Click Test Connection. If the connection is established correctly, DBeaver displays the versions of Greengage DB and its underlying PostgreSQL.

    Successful connection via DBeaver
    Successful connection via DBeaver

  4. Click Finish.

    The Database Navigator tab displays the content of the ADB database you are connected to.

    Database Navigator in DBeaver
    Database Navigator in DBeaver

Run a sample query

You can now use DBeaver to interact with ADB. For example:

  1. On the Database Navigator tab, right-click the public schema and select SQL Editor → Open SQL Script.

  2. In the SQL editor that opens, write a command to create a table and populate it with data. For example:

    CREATE TABLE planets (
    planet_id INTEGER,
    name VARCHAR(50),
    distance_from_sun NUMERIC(10,2)
    )
DISTRIBUTED BY (planet_id);

INSERT INTO planets (planet_id, name, distance_from_sun) VALUES
(1, 'Mercury', 57.91),
(2, 'Venus', 108.20),
(3, 'Earth', 149.60);

  3. Click Execute SQL Script to run the two commands in sequence.

  4. Refresh connection to ADB: press F5 or right-click adb on the Database Navigator tab and select Refresh. The newly created planets table then appears on the Database Navigator tab. You can double-click the table to view its content.

Sample query in DBeaver
Sample query in DBeaver
Found a mistake? Seleсt text and press Ctrl+Enter to report it