Install dependencies for Ibis’s SQLite dialect:

pip install 'ibis-framework[sqlite]'

Create a client by passing a path to a SQLite database to ibis.sqlite.connect():

>>> import ibis
>>> ibis.sqlite.connect('path/to/my/sqlite.db')

See http://blog.ibis-project.org/sqlite-crunchbase-quickstart/ for a quickstart using SQLite.


The SQLite client is accessible through the ibis.sqlite namespace.

Use ibis.sqlite.connect to create a SQLite client.

Backend.connect([path, create])

Create an Ibis client connected to a SQLite database.

Backend.attach(name, path[, create])

Connect another SQLite database file


Return a Database object for the name database.

Backend.list_tables([like, database])

Return the list of table names in the current database.

Backend.table(name[, database])

Create a table expression that references a particular table in the SQLite database