Apache Cassandra

Supported NoSQL

Catalog Cassandra keyspaces, tables and columns through a CQL JDBC driver.

Capabilities

CapabilitySupportNotes
Tables, views & columns Partial
Keys, constraints & indexes Not available Partition and clustering keys can be imported with a custom query on system_schema.columns.
Procedures & functions Not available
Data lineage Not available
Lineage from query history Not available
Business glossary links Partial
Data quality probes Partial
Data profiling Partial
Data classification Partial
Chat with your data Partial

Connection settings

Create the connection on the Blindata Agent from Settings > Agents > Connections with the connection wizard, choosing Apache Cassandra in the technology step.

Driver classcom.simba.cassandra.jdbc42.Driver
JDBC URLjdbc:cassandra://localhost:9042
Authentication
Service principal (shared technical user)
User principal (personal credentials, BYOC)
Ephemeral credentials (asked at each run)
Crawling strategyJDBC

The Blindata Agent does not include this driver: download the vendor JDBC driver and copy the .jar into the agent drivers folder, as described in Add JDBC drivers. Driver properties can be added under Advanced settings in the connection wizard.

Prerequisites & permissions

  • A Blindata Agent installed with network access to Apache Cassandra.
  • The vendor JDBC driver installed on the agent (see Add JDBC drivers).
  • A role with DESCRIBE permission on the keyspaces (access to system_schema).

Set up metadata crawling

  1. Create the connection to Apache Cassandra on the agent (see Connection settings) and use Test to verify it.
  2. Create or open the system that represents Apache Cassandra in the catalog and link it to the connection.
  3. In the CRAWLING tab add a crawling job with strategy JDBC.
  4. Run a TEST to check the number of extracted objects, then RUN or schedule the job.

The job options and the column aliases of every extraction query are described in the Generic JDBC reference.