Using OmniSci with JupyterLab

OmniSci Enterprise Edition

OmniSci Enterprise Edition comes with a fully integrated version of JupyterHub. This provides a secure, multi-user notebook environment for data exploration with OmniSci, and is the primary user interface for the OmniSci Data Science Foundation.

You can quickly switch from visual data exploration, to a Data Science environment preloaded with useful open source libraries and tools that work with OmniSci transparently.

You can access JupyterLab, the next generation Jupyter notebook UI from within Immerse via a button located on the dashboard title

Access JupyterLab from within Immerse (OmniSci EE)

In addition, you can also launch JupyterLab from SQL Editor. In this case, a notebook is opened up with the query wrapped in an Ibis expression.

Upon running a query in SQLEditor, the 'Send to Jupyter' icon becomes visible

OmniSci Enterprise allows you to control which users have access to JupyterLab and Data Science tools. This is managed as a separate privilege under the OmnISci role-based permissions model. Refer to the installation instructions for how to set this up for specific users

Open Source Edition

If you are an OmniSci open source edition user, you will not have access to Immerse, but you can still explore OmniSci with the Data Science Foundation tools.

Using Jupyterlab with OmniSci Open Source Edition will require you to connect to OmniSci explicitly from within a Jupyter notebook cell, using Ibis or pymapd connection syntax. Refer to the Ibis or pymapd examples for further details.

Using the Anaconda Package Manager

If you are using the Anaconda package manager, you can install the set of python tools for OmniSci like th

conda install -c conda-forge omnisci-pytools

Using the OmniSci Docker Container for Jupyter tools

You can download a pre-built Docker container for these tools at [insert link], and simply start up these tools as a standalone container.

OmniSci for Mac Preview

Coming soon

Tools and Utilities

OmniSci provides a collection utilities to work with JupyterLab.

This is a collection of useful functions and Jupyter cell magics that allows running commands that are typically possible from omnisql from inside a notebook environment