Scylla University Live | July 28 & 29 Free Virtual Training Event
Learn More >

Basic Data Modeling

This is the first Data Modeling lesson in a two-part series. Data modeling is the process of identifying the entities in our domain, the relationships between these entities and how they will be stored in the database.
The main steps of data modeling in Scylla are:


The focus of this lesson is the parts of data modeling that are unique to Scylla (and Apache Cassandra) and not general data modeling. It is assumed that you have some prior data modeling experience.

Note that in addition to the instructions provided in this lesson for running Scylla on a machine with Docker, you can find the hands-on part of this lesson in the Katacoda learning environment here. The Katacoda environment provides an interactive virtual machine where you can execute all the commands directly from your browser without the need to configure anything.

After this lesson you will be able to:

  • Describe the Scylla data model
  • Understand what a Keyspace, Table, Column, and Row are
  • Explain the differences between a Primary Key, Partition Key, Compound Key, and Clustering Key
  • Run a cqlsh and perform basic queries