Databases
ScyllaDB
Databases
ScyllaDB
This is the implementation of the ScyllaDB data handler for MindsDB.
ScyllaDB is an open-source distributed NoSQL wide-column data store. It was designed to be compatible with Apache Cassandra while achieving significantly higher throughputs and lower latencies.
Implementation
This handler is implemented using the scylla-driver
Python library.
The required arguments to establish a connection are as follows:
host
is the host name or IP address of the ScyllaDB.port
is the port to use when connecting.user
is the user to authenticate.password
is the password to authenticate the user.keyspace
is the keyspace to connect to. It is a top level container for tables.protocol_version
is not required, and default to 4.
Usage
In order to make use of this handler and connect to the ScyllaDB server in MindsDB, the following syntax can be used:
CREATE DATABASE scylladb_datasource
WITH
ENGINE = 'scylladb',
PARAMETERS = {
"user": "user@mindsdb.com",
"password": "pass",
"secure_connect_bundle": "/home/zoran/Downloads/secure-connect.zip"
};
You can use this established connection to query your table as follows:
SELECT *
FROM scylladb_datasource.keystore.example_table
LIMIT 10;