Using Drivers¶

All of the drivers listed under Available Drivers (and more) can be installed with dbc , Columnar’s CLI for installing and managing ADBC drivers. When drivers are released from the Foundry, they are automatically made available on Columnar’s fast, reliable, and globally-available CDN which dbc pulls from.

Using dbc¶

dbc has its own documentation that covers its installation and usage: https://docs.columnar.tech/dbc/ . We recommended checking that out.

To give you a sense of how simple it is to use dbc, the following steps should work for most users to get started:

Install dbc¶

curl -LsSf https://dbc.columnar.tech/install.sh | sh

Find Drivers¶

$ dbc search
bigquery           An ADBC driver for Google BigQuery developed by the ADBC Driver Foundry
databricks         An ADBC Driver for Databricks developed by the ADBC Driver Foundry
duckdb             An ADBC driver for DuckDB developed by the DuckDB Foundation
exasol             An ADBC driver for Exasol developed by Exasol Labs
flightsql          An ADBC driver for Apache Arrow Flight SQL developed under the Apache Software Foundation
mssql              An ADBC driver for Microsoft SQL Server developed by Columnar
mysql              An ADBC Driver for MySQL developed by the ADBC Driver Foundry

Install a Driver¶

dbc install sqlite

Run a Query¶

$ uv run --with "adbc_driver_manager,pyarrow" python -c "from adbc_driver_manager import dbapi; con = dbapi.connect(uri=\"sqlite://\"); cur = con.cursor(); tbl = cur.execute(\"select 1\").fetch_arrow_table(); print(tbl)"
pyarrow.Table
1: int64
----
1: [[1]]

Using Drivers¶

To find the documentation for any driver dbc lists, run dbc doc <driver>. For example,

$ dbc docs mysql
# your browser should open to https://docs.adbc-drivers.org/drivers/mysql/

Another great resource for getting started with ADBC is Columnar’s adbc-quickstarts repo.