Integrations
Written by
Updated at October 22, 2024
This section provides the basic information about integrating Yandex Query with various Yandex Cloud services and third party systems.
Data sources
Yandex Query supports analytical and streaming data sources.
Analytical sources
Streaming sources
| Data source | Reads | Writes | Description |
|---|---|---|---|
| Yandex Data Streams | Description | ||
| Monitoring | Description | ||
| Yandex Cloud Logging | Via Yandex Data Streams | Description | |
| Yandex IoT Core | Via Yandex Data Streams | ||
| Yandex Audit Trails | Via Yandex Data Streams | Description |
SDK
| Libraries | Programming language | Support level | Repository |
|---|---|---|---|
| database/sql | Go | DML | Repository |
| ydb-go-sdk | Go | DML | Repository |
| JDBC | Java | DML | Repository |
| ydb-java-sdk | Java | DML | Repository |
| ydb-python-sdk | Python | DML | Repository |
| ydb-php-sdk | PHP | DML | Repository |
| ydb-cpp-sdk | C++ | DML | Repository |
| ydb-dotnet-sdk | .Net | DML | Repository |
| ydb-rs-sdk | Rust | DML | Repository |
Note
- Currently, Yandex Query supports only scripting requests.
- All supported SDKs use the same approach to working with Yandex Query and operate similarly. This is best demonstrated by the Python SDK example.
GUI Clients
| Environment | Support level | Guide | Description |
|---|---|---|---|
| Yandex Query UI | Full | ||
| DBeaver | DML | Guide | Using a JDBC driver |
| JetBrains Database viewer | DML | Guide | Using a JDBC driver |
| DataGrip | DML | Guide | Using a JDBC driver |
| Other JDBC-compatible clients | DML | Guide | Using a JDBC driver |
Interactive data analysis
| Environment | Support level | Guide | Description |
|---|---|---|---|
| Jupyter Notebooks | DML | Guide | Using yandex-query-magics |
| DataSphere | DML | Guide | Using yandex-query-magics |
Visualizing data
| Environment | Support level | Guide |
|---|---|---|
| DataLens | Full | Guide |
Orchestration
| Environment | Support level | Guide |
|---|---|---|
| Apache Airflow™ | DML | Guide |
| Yandex Managed Service for Apache Airflow™ | DML | Guide |
Note
- DML: Data Manipulation Language. It allows you to read and write data, but not manage such entities as bindings or connections.