[FIXED] How to remove connection string info from ipython-sql output?

Issue

I'm using the wonderful ipython-sql

But when I get some data from the database I always see the connection string printed out. See image.

How can I stop the connection string from being shown?

Solution

In April 2019 they added a configuration option called displaycon which you can set to False.

%config SqlMagic.displaycon = False

As of 2020-02-20, though, this version isn't in PyPI. To get it to work, I had to clone the repo and install from the source.

! git clone https://github.com/catherinedevlin/ipython-sql.git
! pip install ipython-sql/
# Successfully installed ipython-sql-0.4.0 prettytable-0.7.2 sqlparse-0.3.0

Answered By - Simon Garcia