C++ on Windows
Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
BigQuery
To use ADBC with BigQuery in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "bigquery", &error)
→ See a full example showing how to use the BigQuery ADBC driver with C++
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "cassandra", &error)
→ See a full example showing how to use the Apache Cassandra ADBC driver with C++
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "clickhouse", &error)
→ See a full example showing how to use the ClickHouse ADBC driver with C++
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "databricks", &error)
→ See a full example showing how to use the Databricks ADBC driver with C++
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "datafusion", &error)
→ See a full example showing how to use the Apache DataFusion ADBC driver with C++
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "druid", &error)
→ See a full example showing how to use the Apache Druid ADBC driver with C++
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "duckdb", &error)
→ See a full example showing how to use the DuckDB ADBC driver with C++
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "exasol", &error)
→ See a full example showing how to use the Exasol ADBC driver with C++
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "flightsql", &error)
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with C++
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "mssql", &error)
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with C++
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "mysql", &error)
→ See a full example showing how to use the MySQL ADBC driver with C++
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "oracle", &error)
→ See a full example showing how to use the Oracle Database ADBC driver with C++
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "postgresql", &error)
→ See a full example showing how to use the PostgreSQL ADBC driver with C++
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "presto", &error)
→ See a full example showing how to use the Presto ADBC driver with C++
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "quack", &error)
→ See a full example showing how to use the Quack ADBC driver with C++
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "redshift", &error)
→ See a full example showing how to use the Amazon Redshift ADBC driver with C++
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "singlestore", &error)
→ See a full example showing how to use the SingleStore ADBC driver with C++
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "snowflake", &error)
→ See a full example showing how to use the Snowflake ADBC driver with C++
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "spark", &error)
→ See a full example showing how to use the Apache Spark ADBC driver with C++
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "sqlite", &error)
→ See a full example showing how to use the SQLite ADBC driver with C++
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "teradata", &error)
→ See a full example showing how to use the Teradata ADBC driver with C++
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in C++ on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install the libadbc-driver-manager and libarrow C++ libraries
conda install -c conda-forge libadbc-driver-manager libarrow
- Use the driver in your C++ code:
#include <arrow-adbc/adbc.h>
AdbcDatabaseSetOption(&database, "driver", "trino", &error)
→ See a full example showing how to use the Trino ADBC driver with C++
→ Read the Trino ADBC driver documentation
C# on Windows
Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
BigQuery
To use ADBC with BigQuery in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("bigquery");
→ See a full example showing how to use the BigQuery ADBC driver with C#
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("cassandra");
→ See a full example showing how to use the Apache Cassandra ADBC driver with C#
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("clickhouse");
→ See a full example showing how to use the ClickHouse ADBC driver with C#
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("databricks");
→ See a full example showing how to use the Databricks ADBC driver with C#
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("datafusion");
→ See a full example showing how to use the Apache DataFusion ADBC driver with C#
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("druid");
→ See a full example showing how to use the Apache Druid ADBC driver with C#
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("duckdb");
→ See a full example showing how to use the DuckDB ADBC driver with C#
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("exasol");
→ See a full example showing how to use the Exasol ADBC driver with C#
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("flightsql");
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with C#
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("mssql");
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with C#
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("mysql");
→ See a full example showing how to use the MySQL ADBC driver with C#
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("oracle");
→ See a full example showing how to use the Oracle Database ADBC driver with C#
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("postgresql");
→ See a full example showing how to use the PostgreSQL ADBC driver with C#
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("presto");
→ See a full example showing how to use the Presto ADBC driver with C#
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("quack");
→ See a full example showing how to use the Quack ADBC driver with C#
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("redshift");
→ See a full example showing how to use the Amazon Redshift ADBC driver with C#
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("singlestore");
→ See a full example showing how to use the SingleStore ADBC driver with C#
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("snowflake");
→ See a full example showing how to use the Snowflake ADBC driver with C#
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("spark");
→ See a full example showing how to use the Apache Spark ADBC driver with C#
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("sqlite");
→ See a full example showing how to use the SQLite ADBC driver with C#
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("teradata");
→ See a full example showing how to use the Teradata ADBC driver with C#
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in C# on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add the Apache.Arrow.Adbc NuGet package to your .NET project
dotnet add package Apache.Arrow.Adbc
- Use the driver in your C# code:
using Apache.Arrow.Adbc.DriverManager;
using var driver = AdbcDriverManager.FindLoadDriver("trino");
→ See a full example showing how to use the Trino ADBC driver with C#
→ Read the Trino ADBC driver documentation
Go on Windows
Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
BigQuery
To use ADBC with BigQuery in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "bigquery", ... })
→ See a full example showing how to use the BigQuery ADBC driver with Go
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "cassandra", ... })
→ See a full example showing how to use the Apache Cassandra ADBC driver with Go
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "clickhouse", ... })
→ See a full example showing how to use the ClickHouse ADBC driver with Go
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "databricks", ... })
→ See a full example showing how to use the Databricks ADBC driver with Go
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "datafusion", ... })
→ See a full example showing how to use the Apache DataFusion ADBC driver with Go
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "druid", ... })
→ See a full example showing how to use the Apache Druid ADBC driver with Go
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "duckdb", ... })
→ See a full example showing how to use the DuckDB ADBC driver with Go
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "exasol", ... })
→ See a full example showing how to use the Exasol ADBC driver with Go
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "flightsql", ... })
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Go
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "mssql", ... })
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Go
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "mysql", ... })
→ See a full example showing how to use the MySQL ADBC driver with Go
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "oracle", ... })
→ See a full example showing how to use the Oracle Database ADBC driver with Go
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "postgresql", ... })
→ See a full example showing how to use the PostgreSQL ADBC driver with Go
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "presto", ... })
→ See a full example showing how to use the Presto ADBC driver with Go
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "quack", ... })
→ See a full example showing how to use the Quack ADBC driver with Go
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "redshift", ... })
→ See a full example showing how to use the Amazon Redshift ADBC driver with Go
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "singlestore", ... })
→ See a full example showing how to use the SingleStore ADBC driver with Go
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "snowflake", ... })
→ See a full example showing how to use the Snowflake ADBC driver with Go
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "spark", ... })
→ See a full example showing how to use the Apache Spark ADBC driver with Go
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "sqlite", ... })
→ See a full example showing how to use the SQLite ADBC driver with Go
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "teradata", ... })
→ See a full example showing how to use the Teradata ADBC driver with Go
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Go on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add the ADBC drivermgr package to your Go module
go get github.com/apache/arrow-adbc/go/adbc/drivermgr
- Use the driver in your Go code:
import . "github.com/apache/arrow-adbc/go/adbc/drivermgr"
db, _ := Driver{}.NewDatabase(map[string]string{"driver": "trino", ... })
→ See a full example showing how to use the Trino ADBC driver with Go
→ Read the Trino ADBC driver documentation
Java on Windows
Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
BigQuery
To use ADBC with BigQuery in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "bigquery");
→ See a full example showing how to use the BigQuery ADBC driver with Java
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "cassandra");
→ See a full example showing how to use the Apache Cassandra ADBC driver with Java
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "clickhouse");
→ See a full example showing how to use the ClickHouse ADBC driver with Java
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "databricks");
→ See a full example showing how to use the Databricks ADBC driver with Java
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "datafusion");
→ See a full example showing how to use the Apache DataFusion ADBC driver with Java
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "druid");
→ See a full example showing how to use the Apache Druid ADBC driver with Java
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "duckdb");
→ See a full example showing how to use the DuckDB ADBC driver with Java
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "exasol");
→ See a full example showing how to use the Exasol ADBC driver with Java
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "flightsql");
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Java
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "mssql");
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Java
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "mysql");
→ See a full example showing how to use the MySQL ADBC driver with Java
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "oracle");
→ See a full example showing how to use the Oracle Database ADBC driver with Java
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "postgresql");
→ See a full example showing how to use the PostgreSQL ADBC driver with Java
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "presto");
→ See a full example showing how to use the Presto ADBC driver with Java
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "quack");
→ See a full example showing how to use the Quack ADBC driver with Java
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "redshift");
→ See a full example showing how to use the Amazon Redshift ADBC driver with Java
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "singlestore");
→ See a full example showing how to use the SingleStore ADBC driver with Java
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "snowflake");
→ See a full example showing how to use the Snowflake ADBC driver with Java
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "spark");
→ See a full example showing how to use the Apache Spark ADBC driver with Java
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "sqlite");
→ See a full example showing how to use the SQLite ADBC driver with Java
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "teradata");
→ See a full example showing how to use the Teradata ADBC driver with Java
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Java on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Java code:
import org.apache.arrow.adbc.driver.jni.JniDriver;
JniDriver.PARAM_DRIVER.set(params, "trino");
→ See a full example showing how to use the Trino ADBC driver with Java
→ Read the Trino ADBC driver documentation
JavaScript on Windows
Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
BigQuery
To use ADBC with BigQuery in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'bigquery', ... });
→ See a full example showing how to use the BigQuery ADBC driver with JavaScript
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'cassandra', ... });
→ See a full example showing how to use the Apache Cassandra ADBC driver with JavaScript
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'clickhouse', ... });
→ See a full example showing how to use the ClickHouse ADBC driver with JavaScript
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'databricks', ... });
→ See a full example showing how to use the Databricks ADBC driver with JavaScript
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'datafusion', ... });
→ See a full example showing how to use the Apache DataFusion ADBC driver with JavaScript
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'druid', ... });
→ See a full example showing how to use the Apache Druid ADBC driver with JavaScript
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'duckdb', ... });
→ See a full example showing how to use the DuckDB ADBC driver with JavaScript
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'exasol', ... });
→ See a full example showing how to use the Exasol ADBC driver with JavaScript
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'flightsql', ... });
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with JavaScript
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'mssql', ... });
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with JavaScript
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'mysql', ... });
→ See a full example showing how to use the MySQL ADBC driver with JavaScript
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'oracle', ... });
→ See a full example showing how to use the Oracle Database ADBC driver with JavaScript
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'postgresql', ... });
→ See a full example showing how to use the PostgreSQL ADBC driver with JavaScript
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'presto', ... });
→ See a full example showing how to use the Presto ADBC driver with JavaScript
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'quack', ... });
→ See a full example showing how to use the Quack ADBC driver with JavaScript
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'redshift', ... });
→ See a full example showing how to use the Amazon Redshift ADBC driver with JavaScript
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'singlestore', ... });
→ See a full example showing how to use the SingleStore ADBC driver with JavaScript
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'snowflake', ... });
→ See a full example showing how to use the Snowflake ADBC driver with JavaScript
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'spark', ... });
→ See a full example showing how to use the Apache Spark ADBC driver with JavaScript
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'sqlite', ... });
→ See a full example showing how to use the SQLite ADBC driver with JavaScript
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'teradata', ... });
→ See a full example showing how to use the Teradata ADBC driver with JavaScript
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in JavaScript on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install the @apache-arrow/adbc-driver-manager and apache-arrow npm packages
npm install @apache-arrow/adbc-driver-manager apache-arrow
- Use the driver in your JavaScript code:
import { AdbcDatabase } from '@apache-arrow/adbc-driver-manager';
const db = new AdbcDatabase({driver: 'trino', ... });
→ See a full example showing how to use the Trino ADBC driver with JavaScript
→ Read the Trino ADBC driver documentation
Kotlin on Windows
Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
BigQuery
To use ADBC with BigQuery in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "bigquery")
→ See a full example showing how to use the BigQuery ADBC driver with Kotlin
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "cassandra")
→ See a full example showing how to use the Apache Cassandra ADBC driver with Kotlin
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "clickhouse")
→ See a full example showing how to use the ClickHouse ADBC driver with Kotlin
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "databricks")
→ See a full example showing how to use the Databricks ADBC driver with Kotlin
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "datafusion")
→ See a full example showing how to use the Apache DataFusion ADBC driver with Kotlin
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "druid")
→ See a full example showing how to use the Apache Druid ADBC driver with Kotlin
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "duckdb")
→ See a full example showing how to use the DuckDB ADBC driver with Kotlin
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "exasol")
→ See a full example showing how to use the Exasol ADBC driver with Kotlin
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "flightsql")
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Kotlin
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "mssql")
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Kotlin
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "mysql")
→ See a full example showing how to use the MySQL ADBC driver with Kotlin
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "oracle")
→ See a full example showing how to use the Oracle Database ADBC driver with Kotlin
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "postgresql")
→ See a full example showing how to use the PostgreSQL ADBC driver with Kotlin
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "presto")
→ See a full example showing how to use the Presto ADBC driver with Kotlin
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "quack")
→ See a full example showing how to use the Quack ADBC driver with Kotlin
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "redshift")
→ See a full example showing how to use the Amazon Redshift ADBC driver with Kotlin
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "singlestore")
→ See a full example showing how to use the SingleStore ADBC driver with Kotlin
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "snowflake")
→ See a full example showing how to use the Snowflake ADBC driver with Kotlin
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "spark")
→ See a full example showing how to use the Apache Spark ADBC driver with Kotlin
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "sqlite")
→ See a full example showing how to use the SQLite ADBC driver with Kotlin
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "teradata")
→ See a full example showing how to use the Teradata ADBC driver with Kotlin
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Kotlin on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Kotlin code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "trino")
→ See a full example showing how to use the Trino ADBC driver with Kotlin
→ Read the Trino ADBC driver documentation
Python on Windows
Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
BigQuery
To use ADBC with BigQuery in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="bigquery", ... )
→ See a full example showing how to use the BigQuery ADBC driver with Python
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="cassandra", ... )
→ See a full example showing how to use the Apache Cassandra ADBC driver with Python
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="clickhouse", ... )
→ See a full example showing how to use the ClickHouse ADBC driver with Python
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="databricks", ... )
→ See a full example showing how to use the Databricks ADBC driver with Python
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="datafusion", ... )
→ See a full example showing how to use the Apache DataFusion ADBC driver with Python
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="druid", ... )
→ See a full example showing how to use the Apache Druid ADBC driver with Python
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="duckdb", ... )
→ See a full example showing how to use the DuckDB ADBC driver with Python
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="exasol", ... )
→ See a full example showing how to use the Exasol ADBC driver with Python
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="flightsql", ... )
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Python
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="mssql", ... )
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Python
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="mysql", ... )
→ See a full example showing how to use the MySQL ADBC driver with Python
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="oracle", ... )
→ See a full example showing how to use the Oracle Database ADBC driver with Python
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="postgresql", ... )
→ See a full example showing how to use the PostgreSQL ADBC driver with Python
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="presto", ... )
→ See a full example showing how to use the Presto ADBC driver with Python
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="quack", ... )
→ See a full example showing how to use the Quack ADBC driver with Python
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="redshift", ... )
→ See a full example showing how to use the Amazon Redshift ADBC driver with Python
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="singlestore", ... )
→ See a full example showing how to use the SingleStore ADBC driver with Python
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="snowflake", ... )
→ See a full example showing how to use the Snowflake ADBC driver with Python
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="spark", ... )
→ See a full example showing how to use the Apache Spark ADBC driver with Python
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="sqlite", ... )
→ See a full example showing how to use the SQLite ADBC driver with Python
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="teradata", ... )
→ See a full example showing how to use the Teradata ADBC driver with Python
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Python on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install the ADBC driver manager and PyArrow libraries
pip install adbc_driver_manager pyarrow
- Use the driver in your Python code:
from adbc_driver_manager import dbapi
con = dbapi.connect(driver="trino", ... )
→ See a full example showing how to use the Trino ADBC driver with Python
→ Read the Trino ADBC driver documentation
R on Windows
Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
BigQuery
To use ADBC with BigQuery in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("bigquery")
→ See a full example showing how to use the BigQuery ADBC driver with R
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("cassandra")
→ See a full example showing how to use the Apache Cassandra ADBC driver with R
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("clickhouse")
→ See a full example showing how to use the ClickHouse ADBC driver with R
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("databricks")
→ See a full example showing how to use the Databricks ADBC driver with R
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("datafusion")
→ See a full example showing how to use the Apache DataFusion ADBC driver with R
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("druid")
→ See a full example showing how to use the Apache Druid ADBC driver with R
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("duckdb")
→ See a full example showing how to use the DuckDB ADBC driver with R
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("exasol")
→ See a full example showing how to use the Exasol ADBC driver with R
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("flightsql")
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with R
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("mssql")
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with R
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("mysql")
→ See a full example showing how to use the MySQL ADBC driver with R
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("oracle")
→ See a full example showing how to use the Oracle Database ADBC driver with R
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("postgresql")
→ See a full example showing how to use the PostgreSQL ADBC driver with R
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("presto")
→ See a full example showing how to use the Presto ADBC driver with R
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("quack")
→ See a full example showing how to use the Quack ADBC driver with R
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("redshift")
→ See a full example showing how to use the Amazon Redshift ADBC driver with R
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("singlestore")
→ See a full example showing how to use the SingleStore ADBC driver with R
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("snowflake")
→ See a full example showing how to use the Snowflake ADBC driver with R
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("spark")
→ See a full example showing how to use the Apache Spark ADBC driver with R
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("sqlite")
→ See a full example showing how to use the SQLite ADBC driver with R
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("teradata")
→ See a full example showing how to use the Teradata ADBC driver with R
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in R on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install the adbcdrivermanager R package
install.packages("adbcdrivermanager")
- Use the driver in your R code:
library(adbcdrivermanager)
drv <- adbc_driver("trino")
→ See a full example showing how to use the Trino ADBC driver with R
→ Read the Trino ADBC driver documentation
Ruby on Windows
Install the red-adbc gem
gem install red-adbc
BigQuery
To use ADBC with BigQuery in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "bigquery")
→ See a full example showing how to use the BigQuery ADBC driver with Ruby
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "cassandra")
→ See a full example showing how to use the Apache Cassandra ADBC driver with Ruby
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "clickhouse")
→ See a full example showing how to use the ClickHouse ADBC driver with Ruby
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "databricks")
→ See a full example showing how to use the Databricks ADBC driver with Ruby
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "datafusion")
→ See a full example showing how to use the Apache DataFusion ADBC driver with Ruby
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "druid")
→ See a full example showing how to use the Apache Druid ADBC driver with Ruby
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "duckdb")
→ See a full example showing how to use the DuckDB ADBC driver with Ruby
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "exasol")
→ See a full example showing how to use the Exasol ADBC driver with Ruby
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "flightsql")
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Ruby
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "mssql")
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Ruby
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "mysql")
→ See a full example showing how to use the MySQL ADBC driver with Ruby
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "oracle")
→ See a full example showing how to use the Oracle Database ADBC driver with Ruby
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "postgresql")
→ See a full example showing how to use the PostgreSQL ADBC driver with Ruby
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "presto")
→ See a full example showing how to use the Presto ADBC driver with Ruby
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "quack")
→ See a full example showing how to use the Quack ADBC driver with Ruby
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "redshift")
→ See a full example showing how to use the Amazon Redshift ADBC driver with Ruby
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "singlestore")
→ See a full example showing how to use the SingleStore ADBC driver with Ruby
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "snowflake")
→ See a full example showing how to use the Snowflake ADBC driver with Ruby
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "spark")
→ See a full example showing how to use the Apache Spark ADBC driver with Ruby
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "sqlite")
→ See a full example showing how to use the SQLite ADBC driver with Ruby
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "teradata")
→ See a full example showing how to use the Teradata ADBC driver with Ruby
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Ruby on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install the red-adbc gem
gem install red-adbc
- Use the driver in your Ruby code:
require "adbc"
database = ADBC::Database.new
database.set_option("driver", "trino")
→ See a full example showing how to use the Trino ADBC driver with Ruby
→ Read the Trino ADBC driver documentation
Rust on Windows
Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
BigQuery
To use ADBC with BigQuery in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("bigquery", ... )
→ See a full example showing how to use the BigQuery ADBC driver with Rust
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("cassandra", ... )
→ See a full example showing how to use the Apache Cassandra ADBC driver with Rust
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("clickhouse", ... )
→ See a full example showing how to use the ClickHouse ADBC driver with Rust
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("databricks", ... )
→ See a full example showing how to use the Databricks ADBC driver with Rust
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("datafusion", ... )
→ See a full example showing how to use the Apache DataFusion ADBC driver with Rust
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("druid", ... )
→ See a full example showing how to use the Apache Druid ADBC driver with Rust
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("duckdb", ... )
→ See a full example showing how to use the DuckDB ADBC driver with Rust
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("exasol", ... )
→ See a full example showing how to use the Exasol ADBC driver with Rust
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("flightsql", ... )
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Rust
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("mssql", ... )
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Rust
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("mysql", ... )
→ See a full example showing how to use the MySQL ADBC driver with Rust
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("oracle", ... )
→ See a full example showing how to use the Oracle Database ADBC driver with Rust
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("postgresql", ... )
→ See a full example showing how to use the PostgreSQL ADBC driver with Rust
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("presto", ... )
→ See a full example showing how to use the Presto ADBC driver with Rust
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("quack", ... )
→ See a full example showing how to use the Quack ADBC driver with Rust
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("redshift", ... )
→ See a full example showing how to use the Amazon Redshift ADBC driver with Rust
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("singlestore", ... )
→ See a full example showing how to use the SingleStore ADBC driver with Rust
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("snowflake", ... )
→ See a full example showing how to use the Snowflake ADBC driver with Rust
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("spark", ... )
→ See a full example showing how to use the Apache Spark ADBC driver with Rust
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("sqlite", ... )
→ See a full example showing how to use the SQLite ADBC driver with Rust
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("teradata", ... )
→ See a full example showing how to use the Teradata ADBC driver with Rust
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Rust on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add the adbc_core and adbc_driver_manager crates to your Rust project
cargo add adbc_core adbc_driver_manager
- Use the driver in your Rust code:
use adbc_driver_manager::ManagedDriver;
let mut driver = ManagedDriver::load_from_name("trino", ... )
→ See a full example showing how to use the Trino ADBC driver with Rust
→ Read the Trino ADBC driver documentation
Scala on Windows
Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
BigQuery
To use ADBC with BigQuery in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "bigquery")
→ See a full example showing how to use the BigQuery ADBC driver with Scala
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "cassandra")
→ See a full example showing how to use the Apache Cassandra ADBC driver with Scala
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "clickhouse")
→ See a full example showing how to use the ClickHouse ADBC driver with Scala
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "databricks")
→ See a full example showing how to use the Databricks ADBC driver with Scala
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "datafusion")
→ See a full example showing how to use the Apache DataFusion ADBC driver with Scala
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "druid")
→ See a full example showing how to use the Apache Druid ADBC driver with Scala
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "duckdb")
→ See a full example showing how to use the DuckDB ADBC driver with Scala
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "exasol")
→ See a full example showing how to use the Exasol ADBC driver with Scala
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "flightsql")
→ See a full example showing how to use the Arrow Flight SQL ADBC driver with Scala
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "mssql")
→ See a full example showing how to use the Microsoft SQL Server ADBC driver with Scala
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "mysql")
→ See a full example showing how to use the MySQL ADBC driver with Scala
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "oracle")
→ See a full example showing how to use the Oracle Database ADBC driver with Scala
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "postgresql")
→ See a full example showing how to use the PostgreSQL ADBC driver with Scala
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "presto")
→ See a full example showing how to use the Presto ADBC driver with Scala
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "quack")
→ See a full example showing how to use the Quack ADBC driver with Scala
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "redshift")
→ See a full example showing how to use the Amazon Redshift ADBC driver with Scala
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "singlestore")
→ See a full example showing how to use the SingleStore ADBC driver with Scala
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "snowflake")
→ See a full example showing how to use the Snowflake ADBC driver with Scala
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "spark")
→ See a full example showing how to use the Apache Spark ADBC driver with Scala
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "sqlite")
→ See a full example showing how to use the SQLite ADBC driver with Scala
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "teradata")
→ See a full example showing how to use the Teradata ADBC driver with Scala
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Scala on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Add adbc-core, adbc-driver-manager, and adbc-driver-jni as dependencies in your project
- Use the driver in your Scala code:
import org.apache.arrow.adbc.driver.jni.JniDriver
JniDriver.PARAM_DRIVER.set(params, "trino")
→ See a full example showing how to use the Trino ADBC driver with Scala
→ Read the Trino ADBC driver documentation
Shell on Windows
Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
BigQuery
To use ADBC with BigQuery in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the BigQuery driver:
dbc install bigquery
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying BigQuery with databow:
databow --driver bigquery
→ Read the databow documentation to learn more about querying BigQuery from your terminal
→ Read the BigQuery ADBC driver documentation
Apache Cassandra
To use ADBC with Apache Cassandra in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Cassandra driver:
dbc install --pre cassandra
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Apache Cassandra with databow:
databow --driver cassandra
→ Read the databow documentation to learn more about querying Apache Cassandra from your terminal
→ Read the Apache Cassandra ADBC driver documentation
chDB
chDB is not supported natively on Windows. The chDB ADBC driver is built for Linux and macOS only, so dbc cannot install it on Windows. To use chDB from a Windows machine, install dbc and the driver inside Windows Subsystem for Linux (WSL) and follow the Linux instructions.
→ Read the chDB ADBC driver documentation
ClickHouse
To use ADBC with ClickHouse in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the ClickHouse driver:
dbc install clickhouse
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying ClickHouse with databow:
databow --driver clickhouse
→ Read the databow documentation to learn more about querying ClickHouse from your terminal
→ Read the ClickHouse ADBC driver documentation
Databricks
To use ADBC with Databricks in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Databricks driver:
dbc install databricks
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Databricks with databow:
databow --driver databricks
→ Read the databow documentation to learn more about querying Databricks from your terminal
→ Read the Databricks ADBC driver documentation
Apache DataFusion
To use ADBC with Apache DataFusion in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache DataFusion driver:
dbc install datafusion
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Apache DataFusion with databow:
databow --driver datafusion
→ Read the databow documentation to learn more about querying Apache DataFusion from your terminal
→ Read the Apache DataFusion ADBC driver documentation
Apache Druid
To use ADBC with Apache Druid in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Druid driver:
dbc install --pre druid
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Apache Druid with databow:
databow --driver druid
→ Read the databow documentation to learn more about querying Apache Druid from your terminal
→ Read the Apache Druid ADBC driver documentation
DuckDB
To use ADBC with DuckDB in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the DuckDB driver:
dbc install duckdb
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying DuckDB with databow:
databow --driver duckdb
→ Read the databow documentation to learn more about querying DuckDB from your terminal
→ Read the DuckDB ADBC driver documentation
Exasol
To use ADBC with Exasol in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Exasol driver:
dbc install exasol
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Exasol with databow:
databow --driver exasol
→ Read the databow documentation to learn more about querying Exasol from your terminal
→ Read the Exasol ADBC driver documentation
Arrow Flight SQL
To use ADBC with Arrow Flight SQL in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Arrow Flight SQL driver:
dbc install flightsql
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Arrow Flight SQL with databow:
databow --driver flightsql
→ Read the databow documentation to learn more about querying Arrow Flight SQL from your terminal
→ Read the Arrow Flight SQL ADBC driver documentation
Microsoft SQL Server
To use ADBC with Microsoft SQL Server in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Microsoft SQL Server driver:
dbc install mssql
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Microsoft SQL Server with databow:
databow --driver mssql
→ Read the databow documentation to learn more about querying Microsoft SQL Server from your terminal
→ Read the Microsoft SQL Server ADBC driver documentation
MySQL
To use ADBC with MySQL in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the MySQL driver:
dbc install mysql
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying MySQL with databow:
databow --driver mysql
→ Read the databow documentation to learn more about querying MySQL from your terminal
→ Read the MySQL ADBC driver documentation
Oracle Database
To use ADBC with Oracle Database in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Oracle Database driver:
dbc install oracle
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Oracle Database with databow:
databow --driver oracle
→ Read the databow documentation to learn more about querying Oracle Database from your terminal
→ Read the Oracle Database ADBC driver documentation
PostgreSQL
To use ADBC with PostgreSQL in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the PostgreSQL driver:
dbc install postgresql
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying PostgreSQL with databow:
databow --driver postgresql
→ Read the databow documentation to learn more about querying PostgreSQL from your terminal
→ Read the PostgreSQL ADBC driver documentation
Presto
To use ADBC with Presto in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Presto driver:
dbc install --pre presto
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Presto with databow:
databow --driver presto
→ Read the databow documentation to learn more about querying Presto from your terminal
→ Read the Presto ADBC driver documentation
Quack
To use ADBC with Quack in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Quack driver:
dbc install --pre quack
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Quack with databow:
databow --driver quack
→ Read the databow documentation to learn more about querying Quack from your terminal
→ Read the Quack ADBC driver documentation
Amazon Redshift
To use ADBC with Amazon Redshift in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Amazon Redshift driver:
dbc install redshift
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Amazon Redshift with databow:
databow --driver redshift
→ Read the databow documentation to learn more about querying Amazon Redshift from your terminal
→ Read the Amazon Redshift ADBC driver documentation
SingleStore
To use ADBC with SingleStore in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SingleStore driver:
dbc install --pre singlestore
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying SingleStore with databow:
databow --driver singlestore
→ Read the databow documentation to learn more about querying SingleStore from your terminal
→ Read the SingleStore ADBC driver documentation
Snowflake
To use ADBC with Snowflake in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Snowflake driver:
dbc install snowflake
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Snowflake with databow:
databow --driver snowflake
→ Read the databow documentation to learn more about querying Snowflake from your terminal
→ Read the Snowflake ADBC driver documentation
Apache Spark
To use ADBC with Apache Spark in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Apache Spark driver:
dbc install spark
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Apache Spark with databow:
databow --driver spark
→ Read the databow documentation to learn more about querying Apache Spark from your terminal
→ Read the Apache Spark ADBC driver documentation
SQLite
To use ADBC with SQLite in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the SQLite driver:
dbc install sqlite
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying SQLite with databow:
databow --driver sqlite
→ Read the databow documentation to learn more about querying SQLite from your terminal
→ Read the SQLite ADBC driver documentation
Teradata
To use ADBC with Teradata in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Authenticate with the private driver registry:
dbc auth login
- Install the Teradata driver:
dbc install teradata
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Teradata with databow:
databow --driver teradata
→ Read the databow documentation to learn more about querying Teradata from your terminal
→ Read the Teradata ADBC driver documentation
Trino
To use ADBC with Trino in Shell on Windows:
- Install dbc:
powershell -c "irm https://dbc.columnar.tech/install.ps1 | iex"
- Install the Trino driver:
dbc install trino
- Install databow, the command-line tool for querying databases with ADBC
uv tool install databow
- Start querying Trino with databow:
databow --driver trino
→ Read the databow documentation to learn more about querying Trino from your terminal
→ Read the Trino ADBC driver documentation