Jupyter SQL

Jupyther notebooks are an excellent tool for exploring and presenting data processing.
Not limited to python only could be used even with SQL!

ipython-sql · PyPI




Jupyter Magics with SQL – Towards Data Science

In [1]:

import pandas as pd
from sqlalchemy.engine import create_engine

# Presto
engine = create_engine('presto://localhost:8080/system/runtime') 

#Read Presto Data query into a DataFrame
df = pd.read_sql('select * from queries limit 1', engine)
df.head()

Out[1]:

	node_id	query_id	state	user	source	query	queued_time_ms	analysis_time_ms	distributed_planning_time_ms	created	started	last_heartbeat	end
0	ffffffff-ffff-ffff-ffff-ffffffffffff	20180526_115416_00010_nwiis	RUNNING	satybald	pyhive	select * from queries limit 1	1	17