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.
In order to connect to X 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!
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 26 days ago