title: Split jupyter notebook into several files
body: <p>I am currently creating many tables in python and most of the cells need their own SQL query. I am ending up with a long list of SQL querys. Ideally I would put the table creation of each table in its own file and load the files from a main notebook. </p>
  
  <p>Is there a way to run sub-notebooks (containing the tables) from one main notebook? Mathematica has the <code>EvaulateNotebook[]</code> function which does exactly this. For python I found the <code>nbconvert</code> package which seems to come close to what I need. However, <code>nbconvert</code> seems to run in its own kernel. I would need the sub-notebook to have access to all variables in the main-notebook and subesquently the main-notebook to have acess to the variables in the sub-notebook. </p>
  
  <p>In the end I would like to have the convenience of the notebooks in terms of editing, while not having to scroll through each and every table if I only need to change one table. So I am a bit reluctant to build a standard python package which I import, but would rather have a way to run a sub-ipynb in a way as if the cells where in the main-notebook.</p>