Ibis
  • Getting started
    • 10 minutes to Ibis
    • Installation
    • Online playground

    • Coming from …
    • dplyr
    • pandas
    • SQL

    • Backend examples
    • ClickHouse
    • Apache Flink
    • Starburst Galaxy
  • Concepts
    • Why Ibis?
    • Composable data ecosystem
    • Datatypes and Datashapes
    • Internals
    • User testimonials
    • Versioning policy
    • Who supports Ibis?
  • Backends
    • Amazon Athena
    • BigQuery
    • ClickHouse
    • Dask
    • DataFusion
    • Druid
    • DuckDB
    • Exasol
    • Flink
    • Impala
    • MSSQL
    • MySQL
    • Oracle
    • pandas
    • Polars
    • PostgreSQL
    • PySpark
    • RisingWave
    • Snowflake
    • SQLite
    • Trino

    • Support
    • Cloud backend support policy
    • Operation support matrix
    • Operations
  • How-to
    • Configure
    • Basic configuration

    • Input Output
    • Basic input/output
    • Read parquet files with Ibis
    • Loading Google Cloud Storage files with DuckDB
    • Work with multiple backends

    • Analytics
    • Basic analytics
    • Chaining expressions
    • Analyze IMDB data using Ibis

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

    • Extending
    • Reference built-in functions
    • Using SQL strings with Ibis
    • Ibis for streaming
    • Write and execute unbound expressions
  • Reference
    • Expression API
    • Table expressions
    • Column selectors
    • Generic expressions
    • Numeric and Boolean expressions
    • String expressions
    • Temporal expressions
    • Collection expressions
    • JSON expressions
    • Geospatial expressions

    • Type system
    • Data types
    • Schemas

    • UDFs
    • Scalar UDFs
    • Aggregate UDFs (experimental)

    • Connection APIs
    • Top-level connection APIs

    • Configuration
    • Interactive
    • Options
    • Repr
    • SQL

    • Cursed Knowledge
    • Cursed Knowledge
  • Posts
  • Presentations
  • 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

19

Backend athena bigquery clickhouse databricks datafusion druid duckdb exasol flink impala mssql mysql oracle polars postgres pyspark risingwave snowflake sqlite trino
API coverage 254 (77%) 288 (88%) 250 (76%) 254 (77%) 227 (69%) 177 (54%) 293 (89%) 180 (55%) 220 (67%) 205 (62%) 187 (57%) 200 (61%) 195 (59%) 201 (61%) 299 (91%) 246 (75%) 248 (75%) 259 (79%) 204 (62%) 259 (79%)
Category Operation
Loading ITables v2.3.0 from the internet... (need help?)
 
 
  • Edit this page
  • Report an issue