«

Using Jupyter Notebook

To start with Jupyter Notebook, first follow the steps in the Python set up documentation.

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.

Installing Jupyter

Use the venv created previously to perform the steps below.

  • From the directory created when making the venv (my-python-env):
venv/bin/activate
  • Install Jupyter by running:
pip install jupyterlab

Using Jupyter Notebook with Datomic Analytics

  • Start a Jupyter Notebook with the following command:
jupyter notebook
  • Browse to the URL reported by this command
  • Create a new Python3 Notebook
  • To connect to your Datomic Analytics from Jupyter, use the configuration below:
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())