DataStax
This is the implementation of the DataStax data handler for MindsDB.
DataStax Astra DB is a cloud database-as-a-service based on Apache Cassandra. DataStax also offers DataStax Enterprise (DSE), an on-premises database built on Apache Cassandra, and Astra Streaming, a messaging and event streaming cloud service based on Apache Pulsar.
Implementation
DataStax Astra DB is API-compatible with Apache Cassandra and ScyllaDB. Therefore, its implementation extends the ScyllaDB handler and is using the scylla-driver
Python library.
The required arguments to establish a connection are as follows:
user
is the user to authenticate.password
is the password to authenticate the user.secure_connection_bundle
is the path to thesecure_connection_bundle
zip file.
Usage
In order to make use of this handler and connect to the Astra DB database in MindsDB, the following syntax can be used:
CREATE DATABASE astra_connection
WITH
engine = "astra",
parameters = {
"user": "user",
"password": "pass",
"secure_connection_bundle": "/home/Downloads/file.zip"
};
You can use this established connection to query your table as follows:
SELECT *
FROM astra_connection.keystore.example_table
LIMIT 10;