Install Ibis

Using pip

We suggest starting with the DuckDB backend. It's performant and fully featured.

pip install 'ibis-framework[duckdb]'

If you would like to use a different backend, all of the available options are listed below.

bigqueryclickhousedaskdatafusiondruidduckdbimpalamssqlmysqloraclepandaspolarspostgrespysparksnowflakesqlitetrino

pip install 'ibis-framework[bigquery]'

pip install 'ibis-framework[clickhouse]'

pip install 'ibis-framework[dask]'

pip install 'ibis-framework[datafusion]'

pip install 'ibis-framework[druid]'

pip install 'ibis-framework[duckdb]'

pip install 'ibis-framework[impala]'

pip install 'ibis-framework[mssql]'

pip install 'ibis-framework[mysql]'

pip install 'ibis-framework[oracle]'

pip install 'ibis-framework[pandas]'

pip install 'ibis-framework[polars]'

pip install 'ibis-framework[postgres]'

pip install 'ibis-framework[pyspark]'

pip install 'ibis-framework[snowflake]'

pip install 'ibis-framework[sqlite]'

pip install 'ibis-framework[trino]'

Note that the ibis-framework package is not the same as the ibis package in PyPI. These two libraries cannot coexist in the same Python environment, as they are both imported with the ibis module name.

Using conda or mamba

condamamba

The base ibis-framework package includes support for the duckdb backend. This is our recommended backend for local execution.

conda install -c conda-forge ibis-framework

If you would like to use a different backend, all of the available options are listed below.

bigqueryclickhousedaskdatafusiondruidduckdbimpalamssqlmysqloraclepandaspolarspostgrespysparksnowflakesqlitetrino

conda install -c conda-forge ibis-bigquery

conda install -c conda-forge ibis-clickhouse

conda install -c conda-forge ibis-dask

conda install -c conda-forge ibis-datafusion

conda install -c conda-forge ibis-druid

conda install -c conda-forge ibis-duckdb

conda install -c conda-forge ibis-impala

conda install -c conda-forge ibis-mssql

conda install -c conda-forge ibis-mysql

conda install -c conda-forge ibis-oracle

conda install -c conda-forge ibis-pandas

conda install -c conda-forge ibis-polars

conda install -c conda-forge ibis-postgres

conda install -c conda-forge ibis-pyspark

conda install -c conda-forge ibis-snowflake

conda install -c conda-forge ibis-sqlite

conda install -c conda-forge ibis-trino

The base ibis-framework package includes support for the duckdb backend. This is our recommended backend for local execution.

mamba install -c conda-forge ibis-framework

If you would like to use a different backend, all of the available options are listed below.

bigqueryclickhousedaskdatafusiondruidduckdbimpalamssqlmysqloraclepandaspolarspostgrespysparksnowflakesqlitetrino

mamba install -c conda-forge ibis-bigquery

mamba install -c conda-forge ibis-clickhouse

mamba install -c conda-forge ibis-dask

mamba install -c conda-forge ibis-datafusion

mamba install -c conda-forge ibis-druid

mamba install -c conda-forge ibis-duckdb

mamba install -c conda-forge ibis-impala

mamba install -c conda-forge ibis-mssql

mamba install -c conda-forge ibis-mysql

mamba install -c conda-forge ibis-oracle

mamba install -c conda-forge ibis-pandas

mamba install -c conda-forge ibis-polars

mamba install -c conda-forge ibis-postgres

mamba install -c conda-forge ibis-pyspark

mamba install -c conda-forge ibis-snowflake

mamba install -c conda-forge ibis-sqlite

mamba install -c conda-forge ibis-trino

---

After you've successfully installed Ibis, try going through the tutorial:

Go to the Tutorial

---

Last update: July 15, 2023