Omnisci: "Vega at a Glance"¶

import altair as alt
import ibis_vega_transform

import warnings
try:
    from ibis.backends import omniscidb as ibis_omniscidb
except ImportError as msg:
    warnings.warn(str(msg))
    from ibis import omniscidb as ibis_omniscidb

conn = ibis_omniscidb.connect(
    host='metis.mapd.com', user='demouser', password='HyperInteractive',
    port=443, database='mapd', protocol= 'https'
)
t = conn.table("tweets_nov_feb")
x, y = t.goog_x, t.goog_y

WIDTH = 385
HEIGHT = 564
X_DOMAIN = [
        -3650484.1235206556,
        7413325.514451755
      ]
Y_DOMAIN = [
        -5778161.9183506705,
        10471808.487466192
      ]

scales = alt.selection_interval(
    bind='scales',
)

alt.Chart(t[x, y], width=WIDTH, height=HEIGHT).mark_rect().encode(
    alt.X(
        'goog_x:Q',
        bin=alt.Bin(maxbins=WIDTH),
        title='goog_x',
        scale=alt.Scale(domain=X_DOMAIN)
    ),
    alt.Y(
        'goog_y:Q',
        bin=alt.Bin(maxbins=HEIGHT),
        title='goog_y',
        scale=alt.Scale(domain=Y_DOMAIN)
    ),
    tooltip='count()'
).add_selection(
    scales
).transform_filter(
    scales
)