MSSQL

ibis.memtable Support

The MS SQL Server backend supports memtables by constructing a string with the contents of the in-memory object. This will be very inefficient for medium to large in-memory tables. Please file an issue if you observe performance issues when using in-memory tables.

Install

Install ibis and dependencies for the MSSQL backend:

pipcondamamba

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: August 1, 2023