UsageError: Line magic function `%sql` not found

user_14272156 0
Viewed 10196

%reload_ext sql
%sql sqlite://

The second line can't be compiled and the report says: UsageError: Line magic function %sql not found. With Python3.8, jupyter notebook.

sqlite python
2 Answers

To load sql:

%load_ext sql

To connect SqlLite:

%sql sqlite://
user_164969800

The issue was solved for me using conda to install "ipython-sql", NOT using PIP.

conda install -c conda-forge ipython-sql

user_41029570
Related