Skip to content
DuckDB Extensions All extensions ADBC Scanner

Connection functions in the ADBC Scanner DuckDB extension

Function category

Connection

3 functions

Inspect attached ADBC databases, list connection profiles, and refresh attached catalog metadata. Connect with ATTACH … (TYPE adbc) and disconnect with DETACH.

adbc_clear_cache

Table function Connection
Signature
adbc_clear_cache() → TABLE
Returns

A table with the following columns:

Column cleared Type BOOLEAN Description Whether attached ADBC catalog metadata was cleared.
Description

Use CALL to invalidate schema and table metadata for attached ADBC catalogs after remote DDL. Returns cleared BOOLEAN (false if none are attached). Does not reload drivers or flush connection pools; ordinary data changes need no cache clear.

1 SQLite example 
CALL adbc_clear_cache();

adbc_info

Table function Connection
Signature
adbc_info(database: VARCHAR) → TABLE
Arguments (Positional)
Argument database Type VARCHAR Mode Positional Description Alias of an ATTACH … (TYPE adbc) database. Unknown or non-ADBC names fail at bind.
Description

Return driver and server metadata for an attached ADBC database — vendor name, version strings, supported features.

1 SQLite example 
ATTACH ':memory:' AS db (TYPE adbc, driver 'sqlite');
SELECT * FROM adbc_info('db');
DETACH db;
Related functions

adbc_profiles

Table function Connection
Signature
adbc_profiles(search_paths := VARCHAR) → TABLE
Arguments (Named)
Argument search_paths Type VARCHAR Mode Named Description Additional profile search paths.
Description

List locally discoverable ADBC connection profiles. Optionally supply additional profile search paths.

1 List configured profiles 
SELECT * FROM adbc_profiles();
Related functions