SQL in Jupyter Notebook (JupySQL + VS Code + Jupyter Notebook)
Motivation As a Data Scientist I often work with SQL and Python. I wanted to find a way to blend work with both of these environments seamlessly. I wanted to avoid switching between tools, because I often need to query a database and transfer the result into Python for further processing. Here I present the setup I came up with for VS Code. TL;DR Connect to the database using one of the VS Code…