dbc

dbc is a command-line tool for installing and managing ADBC drivers.

Start by installing a driver:

BigQueryDuckDBFlight SQLSQL ServerMySQLPostgreSQLRedshiftSnowflakeSQLite

$ dbc install bigquery

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "bigquery", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="bigquery", ... )

library(adbcdrivermanager)

drv <- adbc_driver("bigquery")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("bigquery", ... )

$ dbc install duckdb

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "duckdb", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="duckdb", ... )

library(adbcdrivermanager)

drv <- adbc_driver("duckdb")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("duckdb", ... )

$ dbc install flightsql

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "flightsql", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="flightsql", ... )

library(adbcdrivermanager)

drv <- adbc_driver("flightsql")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("flightsql", ... )

$ dbc install mssql

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "mssql", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="mssql", ... )

library(adbcdrivermanager)

drv <- adbc_driver("mssql")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("mssql", ... )

$ dbc install mysql

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "mysql", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="mysql", ... )

library(adbcdrivermanager)

drv <- adbc_driver("mysql")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("mysql", ... )

$ dbc install postgresql

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "postgresql", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="postgresql", ... )

library(adbcdrivermanager)

drv <- adbc_driver("postgresql")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("postgresql", ... )

$ dbc install redshift

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "redshift", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="redshift", ... )

library(adbcdrivermanager)

drv <- adbc_driver("redshift")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("redshift", ... )

$ dbc install snowflake

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "snowflake", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="snowflake", ... )

library(adbcdrivermanager)

drv <- adbc_driver("snowflake")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("snowflake", ... )

$ dbc install sqlite

Then load it in any supported language:

GoPythonRRust

import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"

db, _ := Driver{}.NewDatabase(map[string]string{"driver": "sqlite", ... })

from adbc_driver_manager import dbapi

con = dbapi.connect(driver="sqlite", ... )

library(adbcdrivermanager)

drv <- adbc_driver("sqlite")

use adbc_driver_manager::ManagedDriver;

let mut driver = ManagedDriver::load_from_name("sqlite", ... )

Features

• Install pre-built ADBC drivers with a single command
• Manage numerous drivers without conflicts
• Install drivers just for your user or system-wide
• Create reproducible environments with driver list files
• Cross-platform: Runs on macOS, Linux, and Windows
• Installable with pip, Docker, and more (See Installation)
• Works great in CI/CD environments

Installation

Install dbc with our automated installer:

macOS and LinuxWindows

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

$ powershell -ExecutionPolicy ByPass -c "irm https://dbc.columnar.tech/install.ps1 | iex

Then, take your first steps to get started using dbc.

Note

See our Installation page for more ways to get dbc.