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

TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, and Industrial IoT. It enables efficient, real-time data ingestion, processing, and monitoring of TB and even PB scale data per day, generated by billions of sensors and data collectors. TDengine differentiates itself from other time-series databases with numerous advantages, such as high performance, simplified solution, cloud-native, ease of use, easy data analytics, and open-source.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

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

Implementation

This handler is implemented using taos/taosrest, a Python library that allows you to use Python code to run SQL commands on the TDEngine server.

The required arguments to establish a connection are as follows:

  • user is the username associated with the server.
  • password is the password to authenticate your access.
  • url is the URL to the TDEngine server. For local server, the URL is localhost:6041 by default.
  • token is the unique token provided while using TDEngine Cloud.
  • database is the database name to be connected.

Usage

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

CREATE DATABASE tdengine_datasource
WITH
    ENGINE = 'tdengine',
    PARAMETERS = {
    "user": "tdengine_user",
    "password": "password",
    "url": "localhost:6041",
    "token": "token",
    "database": "tdengine_db"
    };

You can specify token instead of user and password while using TDEngine.

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

SELECT *
FROM tdengine_datasource.demo_table;