I would like to generate a Physical data model of tables and relationships using a tool that could reverse engineer a Cassandra database. Please advise.
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
Kashliev Data Modeler (KDM) is an automated data modeling tool for Apache Cassandra which allows you to easily browse a cluster's schema.
Hackolade is a data modeling software for JSON, NoSQL and several multi-model databases. It comes with an out-of-the-box plugin that allows you to connect to Apache Cassandra and DSE clusters.
These tools allow users to generate Chebotko diagrams -- graphical representations of Cassandra schema which show the logical and physical data model using Chebotko notation.
I haven't used them myself but both software have been around for a number of years. You have to pay to use them but they come with a free trial (see the respective websites). There are other IDEs for connecting to Cassandra but these are the two I'm aware of that can generate the diagrams.
For more info on Chebotko notation, see this tutorial at DataStax Academy. Cheers!
6 People are following this question.