%sqlcmd connect
#
New in version 0.10.1.
%sqlcmd connect
displays a widget that allows you to create new connections and manage existing ones.
Installation#
Since %sqlcmd connect
uses the optional ipywidgets
package:
pip install ipywidgets --upgrade
Create a new connection#
Click on the + Create new connection
button and fill out the form:
Delete a connection#
Click on trash bin icon and confirm:
Edit an existing connection#
Click on the pencil button, edit details, and click on Update
:
Connect to an existing connection#
Click on the Connect
button:
The connections file#
All your connections are stored in the %config SqlMagic.dsn_filename
file
(~/.jupysql/connections.ini
by default). You can change the file location
and edit it manually, to learn more, see: Using a connection file