1. Data Integrations
  2. 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