First, install the iPython_SQL library, which allows SQL magic. You can do this by running exclamation pip, install- iPython SQL in a code cell of a notebook.

Introduces a %sql (or %%sql) magic. Connect to a database, using SQLAlchemy URL connect strings, then issue SQL commands within IPython or IPython Notebook. If no connect string is supplied, %sql will ...