Using Jupyter Notebook
Jupyter Notebook is an interactive web-based notebook frequently used for data analysis and visualization. You can access data stored in Datomic for analysis in Jupyter Notebook (or any Python-based system) using the PyHive Presto library.
Important: First, follow the steps in the Python Setup documentation.
Installing Jupyter
Using the venv created previously:
# From the directory created when making the venv (my-python-env): . venv/bin/activate # Install Jupyter: pip install jupyterlab
Using Jupyter Notebook with Datomic Analytics
Start a Jupyter Notebook with:
jupyter notebook
- Browse to the URL reported by this command.
- Create a new Python3 notebook
Use the following configuration to connect to your Datomic Analytics from Jupyter:
from pyhive import presto conn = presto.connect( host='<host>', port=<port>, catalog='<catalog>', schema='<schema>', username='presto' ) cur = conn.cursor()
Run a test query.
cur.execute('SELECT * FROM system.runtime.nodes') print(cur.fetchall())