Using Apache Zeppelin with Astra

• source

One of the most exciting things we get to do around here is to figure out how to connect tools to Astra. In this tutorial I am going to show you how I was able to connect an instance of Apache Zeppelin to Astra.

First I need my secure-bundle and a Database Administrators role’s ClientId & ClientSecret from the Astra UI:

secure-connect-memegen2.zip [ClientId] [ClientSecret] Next I need to download the full binary with all interpreters from main Apache Zeppelin site:

cd /Users/stevenmatison/Downloads/zeppelin-0.9.0-bin-all bin/zeppelin-daemon.sh start bin/zeppelin-daemon.sh stop Next I need to access http://localhost:8080/ and configure the Zeppelin Cassandra Interpeter. The interpreter uses a java driver 4.7x and you need to provide the following settings:

Hosts - Set this to blank

Username - Set this to your ClientID

Password - Set this to your ClientSecret

Keyspace -Set this to your Astra Keyspace

Consistency - Set this to LOCAL_QUORUM

Serial Consistency - SET THIS TO LOCAL_SERIAL

Add value: datastax-java-driver.basic.cloud.secure-connect-bundle and set to full path to your secure bundle. For example: /Users/stevenmatison/Downloads/zeppelin-0.9.0-bin-all/secure-connect-memegen2.zip

Thank you OG Alex Ott for settings I found here.

After saving these settings in the Zeppelin Cassandra Interpreter create a new notebook and test cql commands. For example:

%cassandra

DESCRIBE keyspace memegen2;

And viola you now have Astra CQL in Zeppelin:

What’s Next? Go forth and provide a wonderful CQL experience with Astra using Apache Zeppelin Notebooks.