Database driver Materialize - bobbyiliev/dbeaver GitHub Wiki

Overview

This guide provides instructions for setting up and using Materialize with DBeaver.

Minimum requirements: DBeaver 23.1.3

To connect to Materialize using DBeaver, follow the documentation to create a connection and use the Materialize database driver with the credentials provided in the Materialize console.

The Materialize database driver depends on the PostgreSQL JDBC driver. If you don't have the driver installed locally, DBeaver will prompt you to automatically download and install the most recent version.

Connect to a specific cluster

By default, Materialize connects to the pre-installed default cluster. To connect to a specific cluster, you must define a bootstrap query in the connection initialization settings.

  1. Click on Connection details.

  2. Click on Connection initialization settings.

  3. Under Bootstrap queries, click Configure and add a new SQL query that sets the active cluster for the connection:

    SET cluster = other_cluster;

You can find the official Materialize documentation here.