Ibis
  • Getting started
    • Installation
    • Tutorial: getting started
    • Tutorial: Ibis for dplyr users
    • Tutorial: Ibis for pandas users
    • Tutorial: Ibis for SQL users

    • Data Platforms
    • Starburst Galaxy
  • Concepts
    • Why Ibis?
    • Composable data ecosystem
    • Internals
    • User testimonials
    • Versioning policy
    • Who supports Ibis?
  • Backends
    • BigQuery
    • ClickHouse
    • Dask
    • DataFusion
    • Druid
    • DuckDB
    • Exasol
    • Flink
    • Impala
    • MSSQL
    • MySQL
    • Oracle
    • pandas
    • Polars
    • PostgreSQL
    • PySpark
    • Snowflake
    • SQLite
    • Trino
    • Operation support matrix
  • How-to
    • Configure
    • Basic configuration

    • Input Output
    • Basic input/output
    • Work with multiple backends

    • Analytics
    • Basic analytics
    • Chaining expressions

    • Visualization
    • Altair + Ibis
    • matplotlib + Ibis
    • Plotly + Ibis
    • plotnine + Ibis
    • seaborn + Ibis
    • Streamlit + Ibis

    • Extending
    • Reference built-in functions
    • Add an elementwise operation
    • Add a reduction operation
    • Using SQL strings with Ibis
  • Reference
    • Expression API
    • Table expressions
    • Column selectors
    • Generic expressions
    • Numeric and Boolean expressions
    • String expressions
    • Temporal expressions
    • Collection expressions
    • Geospatial expressions

    • Type system
    • Data types
    • Schemas

    • UDFs
    • Scalar UDFs

    • Connection APIs
    • Top-level connection APIs

    • Configuration
    • ContextAdjustment
    • Interactive
    • Options
    • Repr
    • SQL
  • Posts
  • Release notes
  • Contribute
    • Contribute
    • Setting up a development environment
    • Contribute to the Ibis codebase
    • Style and formatting
    • Maintaining the codebase
    • Test Class Reference
  • Source code
  • Report a bug
  • Report a documentation issue
  • Submit a feature request
  • Ask the community for help
Operation support matrix
Welcome to the operation support matrix!

This is a Quarto dashboard that shows the operations each backend supports.

Due to differences in SQL dialects and upstream support for different operations in different backends, support for the full breadth of the Ibis API varies.

Tip

Backends with low coverage are good places to start contributing!

Each backend implements operations differently, but this is usually very similar to other backends. If you want to start contributing to ibis, it’s a good idea to start by adding missing operations to backends that have low operation coverage.

Number of backends

20

Number of SQL backends

14

Backend bigquery clickhouse dask datafusion druid duckdb exasol flink impala mssql mysql oracle pandas polars postgres pyspark risingwave snowflake sqlite trino
API coverage 234 (78%) 216 (72%) 200 (67%) 164 (55%) 129 (43%) 250 (83%) 117 (39%) 176 (59%) 160 (53%) 142 (47%) 201 (67%) 138 (46%) 200 (67%) 171 (57%) 249 (83%) 188 (63%) 203 (68%) 214 (71%) 165 (55%) 214 (71%)
Category Operation
Loading... (need help?)
 
 
  • Edit this page
  • Report an issue