Jupyter Notebook ipython-sql Plugin
Jupyter Notebook is the original web application for creating and sharing computational documents. It offers a simple, streamlined, document-centric experience. Using this python-based notebook with the ipython-sql plugin allows you to incorporate SQL connections into your workflow.
Connecting to Jupyter to bit.io
In order to connect to a Jupyter Notebook with bit.io, you'll need to find your PosgreSQL connection credentials from the bit.io Connect Tab of the database to which you would like to connect. You can find everything you need to know about your PostgreSQL credentials here
If you have not yet installed the ipython-sql plugin for Jupyter, you will have to do that next.
Just insert your query string from bit.io's Connect tab, and you should now be able to query your bit.io database directly from your notepad!
Using Jupyter with bit.io
Once we've set up our connection, we can inject dynamic SQL data into our Jupyter workflow to create documents truly driven by dynamic data.
Here is a great introduction on some ways you can begin to analyze and present your bit.io data in Jupyter.
Updated about 2 months ago