This is the implementation of the Databend data handler for MindsDB.

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

​
Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or use MindsDB Cloud.
  2. To connect Databend to MindsDB, install the required dependencies following this instruction.
  3. Install or ensure access to Databend.

​
Implementation

This handler is implemented by extending the ClickHouse handler.

The required arguments to establish a connection are as follows:

  • protocol is the protocol to query Databend. Supported values include native, http, https. It defaults to native if not provided.
  • host is the host name or IP address of the Databend warehouse.
  • port is the TCP/IP port of the Databend warehouse.
  • user is the username used to authenticate with the Databend warehouse.
  • password is the password to authenticate the user with the Databend warehouse.
  • database is the database name to use when connecting with the Databend warehouse.

​
Usage

In order to make use of this handler and connect to the Databend database 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"
    };

You can use this established connection to query your table as follows:

SELECT *
FROM databend_datasource.example_tbl;