Databend

​

Databend

Databend is a modern cloud data warehouse that empowers your object storage for real-time analytics.

https://databend.rs/

​

Implementation

This handler was implemented by extending ClickHouse Handler class

The required arguments to establish a connection are,

• protocol: the protocol to query Databend. Supported: native, http, https. Default: native’.
• host: the host name or IP address of the Databend warehouse. NOTE: use ‘127.0.0.1’ instead of ‘localhost’ to connect to local server.
• port: the TCP/IP port of the Databend warehouse.
• user: the username used to authenticate with the Databend warehouse.
• password: the password to authenticate the user with the Databend warehouse.
• database: the database name to use when connecting with the Databend warehouse.

​

Usage

In order to make use of this handler and connect to Databend in MindsDB, the following syntax can be used,

CREATE DATABASE databend_datasource
WITH
engine='databend',
parameters={
    "protocol": "https",
    "user": "root",
    "port": 443,
    "password": "password",
    "host": "some-url.aws-us-east-2.default.databend.com",
    "database": "test_db"
};

Now, you can use this established connection to query your data warehouse as follows,

SELECT * FROM databend_datasource.example_tbl