Extracting vega lite from altair¶

Let's create an example altair chart:

Using Ibis and Altair for OmniSci¶

In this notebook, we will use Ibis to build OmniSci query and then use Altair to compose a visualization on top of it.

We will be plotting a map of a bunch of tweets.

Assembling the Query¶

First, let's connect to the omnisci backend and assemble the query:

3. Extract Transforms Use Cases¶

In this notebook, I will show some use cases for extracting out the transformations in a Vega Lite spec and computing them in the database instead of on the client.

OmniSci SQL editor¶

Ibis is a great tool for abtracting SQL queries, and for more programmatic query generation. However, there are times when it is still useful to quickly test raw SQL. Fortunately, we can use an ibis connection and some display magics to accomplish this.

First, we make the relevant imports:

Explorations in OmniSci backend rendering with Vega¶

We would like to surface the vega rendering backend to Jupyter notebook users. This will allow people to visualize data that is too large to fit in memory. OmniSci uses Apache Thrift to generate interfaces to the SQL server for various clients. The Javascript client is notably more complete than the Python client.

Establishing a connection¶

pymapd allows us to connect to a OmniSci server using the following code:

We have packaged extractTransform from Vega Lite up as a mime renderer: