Integrations
Written by
Updated at August 23, 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
Data source | Reads | Writes | Description |
---|---|---|---|
Object Storage | Description | ||
Yandex Managed Service for PostgreSQL | Description | ||
Yandex Managed Service for ClickHouse® | Description | ||
Yandex Managed Service for YDB | Description |
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 | Instructions | 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 | Instructions | Description |
---|---|---|---|
Jupyter Notebooks | DML | Guide | Using yandex-query-magics |
DataSphere | DML | Guide | Using yandex-query-magics |
Visualizing data
Environment | Support level | Instructions |
---|---|---|
DataLens | Full | Guide |
Orchestration
Environment | Support level | Instructions |
---|---|---|
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.