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;