Connecting using an IDE

Yandex Query allows Java DataBase Connectivity (JDBC) connections, so you can work with connections in Query using graphical IDEs also supporting this protocol, e.g., DBeaver, DataGrip, etc.

This document describes connecting with DBeaver, but the connection process will be similar for any system supporting JDBC data sources.

DBeaver

DBeaver is a free, open source, cross-platform database management tool with a user-friendly interface for database connections and SQL queries. It supports many databases including MySQL, PostgreSQL, Oracle, SQLite, and others.

JDBC driver

To connect to Yandex Query from DBeaver, you will need a JDBC driver. Yandex Query is based on YDB federated queries, so the connection will use a YDB JDBC driver.

Follow these steps to download the driver:

1. Go to the ydb-jdbc-driver repository.
2. Select the latest release (tagged Latest) and save the ydb-jdbc-driver-shaded-<driver-version>.jar file.

Connecting a JDBC driver to DBeaver

To connect a JDBC driver, follow these steps:

1. Select Database from the DBeaver top menu and click Driver management:

   

2. To create a new driver, click New in the Driver Manager window:

   

3. In the Create driver window that opens, specify Yandex Query in the Driver name field:

   

4. Go to the Libraries section, click Add file, specify the path to the previously downloaded YDB JDBC driver and click OK:

   

5. The Yandex Query driver will appear in the driver list. Double click the new driver and go to the Libraries tab, click Find Class and select tech.ydb.jdbc.YdbDriver from the drop-down list.

   Warning

   Make sure to explicitly select tech.ydb.jdbc.YdbDriver from the drop-down list by clicking it. Otherwise, DBeaver will assume that you have not selected a driver.

   

Creating a Yandex Query connection

To create a connection, you must complete these preliminary steps:

1. Create a service account named dbeaver with the editor role.

2. Create an authorized key for the service account and save it to a file.

After that, follow these steps:

1. In DBeaver, create a new connection by specifying the Yandex Query connection type.

2. In the window that opens, go to Main.

3. In the JDBC URL input field of the General subsection, specify the following path:

   jdbc:ydb:grpcs://grpc.yandex-query.cloud.yandex.net:2135/<folder_id>?saFile=<path_to_auth_key_file.json>
   

   Where:

   • folder_id: ID of the folder in which queries to Yandex Query will be run.
   • path_to_auth_key_file.json: Path to authorized key file.

   

4. Click Test connection ... to test the settings.

   If all settings are correct, you will get a successful connection test message:

   

5. Click Done to save the connection.

Working with Yandex Query

With DBeaver, you can view the list and structure of data bindings:

You can also run data queries: