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 purposefully designed to offer compatibility with Apache Cassandra while outperforming it with higher throughputs and reduced latencies. For a comprehensive understanding of ScyllaDB, visit ScyllaDB’s official website.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

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

Implementation

The ScyllaDB handler for MindsDB was developed using the scylla-driver library for Python. The required arguments to establish a connection are as follows:

• host: Host name or IP address of ScyllaDB.
• port: Connection port.
• user: Authentication username.
• password: Authentication password.
• keyspace: The specific keyspace (top-level container for tables) to connect to.
• protocol_version: Optional. Defaults to 4.
• secure_connect_bundle: Optional. Needed only for connections to DataStax Astra.

Usage

To set up a connection between MindsDB and a Scylla server, utilize the following SQL syntax:

CREATE DATABASE scylladb_datasource
WITH
  ENGINE = 'scylladb',
  PARAMETERS = {
    "user": "[e-mail]",
    "password": "pass",
    "host": "127.0.0.1",
    "port": "9042",
    "keyspace": "test_data"
  };

The protocol version is set to 4 by default. Should you wish to modify it, simply include “protocol_version”: 5 within the PARAMETERS dictionary in the query above.

With the connection established, you can execute queries on your keyspace as demonstrated below:

SELECT * FROM scylladb_datasource.keystore.example_table LIMIT 10;