SQL-on-Cassandra-with-Open-Source-Notebooks

Introduction to a few open source notebooks that can be used to do SQL and joins on Cassandra, a NoSQL database. We cover Jupyter, Zeppelin, Quix, and Polynote, with live demos of Jupyter (using Spark + Cassandra) and Quix (using Presto + Cassandra)

Accompanying Materials

• Blog
• Webinar
• Slideshare
• Doing SQL and Reporting on Apache Cassandra with Open Source Tools Series:
  1. Presto and Cassandra
  2. Spark and Cassandra
  3. Open Source Notebooks and Cassandra
  4. Open Source BI Tools and Cassandra

Quix Notebook

• No importable/exportable notebooks currently
• Will be using queries that are available in the Code.txt file here. Live instructions can be seen in the webinar linked above.

Jupyter Notebook

• Notebook For Demo

DataStax Studio for creating demo keyspace, creating tables, and seeding tables

• Notebook For Demo
• If using CQLSH vs DataStax Studio Notebook, then you can still take the notebook above and use the CQL commands and queries in the Code.txt file