Updated ADBC drivers for Apache Cassandra, Apache Spark, Amazon Redshift, BigQuery, Databricks, Microsoft SQL Server, MySQL/MariaDB, Presto, Snowflake, and Trino¶

Updated Drivers¶

ADBC Driver for Apache Cassandra version 0.1.0-alpha.3

• Update dependencies to pick up CVE fixes

ADBC Driver for Apache Spark version 0.2.2

• Map Spark Connect gRPC errors to the correct ADBC status codes

• Update dependencies to pick up CVE fixes

ADBC Driver for Amazon Redshift version 1.8.0

• Include temporary tables in GetObjects results

• Support fetching a new IdP access token for each connection using a configurable token endpoint

• Fix IdP token authentication failing with a “failed to authenticate” error

• Update dependencies to pick up CVE fixes

BigQuery ADBC driver version 1.14.0

• Add the bigquery.user_agent option to customize the user agent

• Add experimental support for optional job creation with Arrow result format

• Return additional BigQuery table metadata

• Map REST API 403 access denials to the UNAUTHORIZED status code

• Correct Arrow extension metadata for ARRAY<GEOGRAPHY> results

• Refresh impersonated credentials automatically when bigquery.impersonate.lifetime is unset

• Skip tables that return 404 errors in GetObjects

• Update dependencies to pick up CVE fixes

ADBC Driver for Databricks version 0.2.0

• Support named query parameters

• Support decimal data types

• Update dependencies to pick up CVE fixes

ADBC Driver for Microsoft SQL Server version 1.7.0

• Add the mssql.query.datetimeoffset_type option to return DATETIMEOFFSET as arrow.timestamp_with_offset, preserving the original UTC offset

• Add the mssql.query.datetimeoffset_precision option to choose between preserving the full date range and fractional-second precision

• Support binding and ingesting arrow.timestamp_with_offset as DATETIMEOFFSET (Fabric Data Warehouse does not support DATETIMEOFFSET columns)

• Restore support for querying DATETIMEOFFSET as timestamp[us, tz=UTC] by default

• Correct UUID byte order when reading, binding, and ingesting UNIQUEIDENTIFIER values

• Fix GetObjects metadata queries for other catalogs and avoid errors for inaccessible catalogs

• Honor mssql.ingest.method when set on a connection

• Update dependencies to pick up CVE fixes

ADBC Driver for MySQL/MariaDB version 0.7.0

• Support reading BIGINT UNSIGNED values above the signed 64-bit maximum through prepared statements

• Accept the target database via the catalog option for bulk ingestion

• Update dependencies to pick up CVE fixes

ADBC Driver for Presto version 0.1.0-alpha.3

• Default presto:// connections to TLS

• Update dependencies to pick up CVE fixes

ADBC Driver for Snowflake version 1.15.0

• Add the adbc.connection.get_objects.match_exactly option to disable wildcard matching in GetObjects filters

• Add the adbc.snowflake.sql.client_option.max_retry_count option to control the maximum number of retries per HTTP request

• Handle backslashes correctly in GetObjects filters

• Limit prefetching based on the number of unconsumed result streams

• Update dependencies to pick up CVE fixes

ADBC Driver for Trino versions 0.6.0 and 0.6.1

• Support transactions

• Update dependencies to pick up CVE fixes

• Bundle timezone data in shared libraries

To learn more about any of these drivers, check out the documentation and quickstarts .

Bug reports and feature requests are welcome at the repositories linked above. You can also start a Discussion on GitHub or join the Columnar Community Slack .