Jupyter Magics with SQL

Jupyter Magics with SQL

6 years ago
Anonymous $CLwNLde341

https://towardsdatascience.com/jupyter-magics-with-sql-921370099589

Jupyter/IPython notebooks can be used for an interactive data analysis with SQL on a relational database. This fuses together the advantages of using Jupyter, a well-established platform for data analysis, with the ease of use of SQL and the performance of SQL engines.

Jupyter magic functions allow you to replace a boilerplate code snippets with more concise one. Let’s explore Jupyter SQL magic that allows us to interact with Presto or any other relational databases.