Skip to content

MSSQL

exportbadge

Install

Install ibis and dependencies for the MSSQL backend:

pip install 'ibis-framework[mssql]'

conda install -c conda-forge ibis-mssql

mamba install -c conda-forge ibis-mssql

Connect

ibis.mssql.connect

con = ibis.mssql.connect(
    user="username",
    password="password",
    host="hostname",
)

ibis.mssql.connect is a thin wrapper around ibis.backends.mssql.Backend.do_connect.

Connection Parameters

do_connect(host='localhost', user=None, password=None, port=1433, database=None, url=None, driver='pymssql')

ibis.connect URL format

In addition to ibis.mssql.connect, you can also connect to MSSQL by passing a properly formatted MSSQL connection URL to ibis.connect

con = ibis.connect(f"mssql://{user}:{password}@{host}:{port}")
Last update: June 2, 2023