Databases
GreptimeDB
This is the implementation of the GreptimeDB data handler for MindsDB.
GreptimeDB is an open-source, cloud-native time series database features analytical capabilities, scalebility and open protocols support.
Implementation
This handler is implemented by extending the MySQLHandler.
Connect GreptimeDB to MindsDB by providing the following parameters:
host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.database
is the database name.user
is the database user.password
is the database password.
There are several optional parameters that can be used as well.
ssl
is thessl
parameter value that indicates whether SSL is enabled (True
) or disabled (False
).ssl_ca
is the SSL Certificate Authority.ssl_cert
stores SSL certificates.ssl_key
stores SSL keys.
Usage
In order to make use of this handler and connect to the GreptimeDB database in MindsDB, the following syntax can be used:
CREATE DATABASE greptimedb_datasource
WITH
engine = 'greptimedb',
parameters = {
"host": "127.0.0.1",
"port": 4002,
"database": "public",
"user": "username",
"password": "password"
};
You can use this established connection to query your table as follows.
SELECT *
FROM greptimedb_datasource.example_table;
Was this page helpful?