ADBC Driver for Firebolt¶
Driver Version 0.2.0 Release Date 2026-10-12 Tested With Firebolt 5.0.0
This driver provides ADBC access to Firebolt’s HTTP query interface.
Feature & Type Support¶
| Feature | Firebolt | |
|---|---|---|
| Bind Parameters | ✅ | |
| Bulk Ingestion | Create | ✅ |
| Append | ✅ | |
| Create/Append | ✅ | |
| Replace | ✅ | |
| Temporary Table | ❌ | |
| Target Catalog | ✅ | |
| Target Schema | ✅ | |
| Non-nullable fields are marked NOT NULL | ❌ | |
| Catalog (GetObjects) | depth=catalogs | ✅ |
| depth=db_schemas | ✅ | |
| depth=tables | ✅ | |
| depth=columns (all) | ✅ | |
| Get Parameter Schema | ✅ | |
| Get Table Schema | ✅ | |
| Prepared Statements | ✅ | |
| Transactions | ✅ | |
Types¶
Database to Arrow¶
| Database Type | Firebolt |
|---|---|
|
BIGINT |
int64 |
|
BOOLEAN |
bool |
|
BYTEA |
binary |
|
DATE |
date32[day] |
|
DOUBLE PRECISION |
double |
|
INT |
int32 |
|
NUMERIC |
decimal128 |
|
REAL |
float |
|
TIMESTAMP |
timestamp[us] |
|
TIMESTAMP WITH TIME ZONE |
timestamp[us] (with time zone) |
|
TIMESTAMP(p) (4 <= p <= 6) |
timestamp[us] |
|
TIMESTAMP(p) (4 <= p <= 6) WITH TIME ZONE |
timestamp[us] (with time zone) |
|
VARCHAR |
string |
Arrow to Database¶
| Arrow Type | Firebolt Type | |
|---|---|---|
| Bind | Ingest | |
|
binary |
❌ |
VARBINARY |
|
binary_view |
❌ |
|
|
bool |
BOOLEAN |
|
|
date32[day] |
DATE |
|
|
decimal128 |
NUMERIC |
|
|
double |
DOUBLE PRECISION |
|
|
fixed_size_binary |
❌ |
VARBINARY |
|
float |
REAL |
|
|
halffloat |
REAL |
(NA/not tested) |
|
int16 |
(NA/not tested) |
SMALLINT |
|
int32 |
INT |
|
|
int64 |
BIGINT |
|
|
large_binary |
❌ |
VARBINARY |
|
large_string |
VARCHAR |
|
|
string |
VARCHAR |
|
|
string_view |
VARCHAR |
❌ |
|
timestamp[ms] |
TIMESTAMP(6) |
TIMESTAMP(3) |
|
timestamp[ms] (with time zone) |
TIMESTAMP(6) WITH TIME ZONE |
TIMESTAMP(3) WITH TIME ZONE |
|
timestamp[ns] |
TIMESTAMP(6) |
TIMESTAMP(9) |
|
timestamp[ns] (with time zone) |
TIMESTAMP(6) WITH TIME ZONE |
TIMESTAMP(9) WITH TIME ZONE |
|
timestamp[s] |
TIMESTAMP(6) |
TIMESTAMP(0) |
|
timestamp[s] (with time zone) |
TIMESTAMP(6) WITH TIME ZONE |
TIMESTAMP(0) WITH TIME ZONE |
|
timestamp[us] |
TIMESTAMP(6) |
|
|
timestamp[us] (with time zone) |
TIMESTAMP(6) WITH TIME ZONE |
|
Compatibility¶
This driver was tested on:
Firebolt
5.0.0-pre.0.20260927210425.e91cd5bd17f8