Source: https://jupyter.org/
Jupyter notebook & its variants
Extensions
Magic commands or Instructions
| Command | Description & Example |
|---|---|
%load_ext sql | This line prepares your Jupyter Notebook environment to understand and execute SQL commands by loading the sql extension.q |
%sql sqlite:///sample.db | Create and connect to SQLite database in the same directory as our jupyter notebook |
%%sql | Run SQL query in the current code cell |