Query LabKey Server tables with automatic local Parquet caching
Maintainer(s):
nrminor
Installing and Loading
INSTALL duck_lk FROM community;
LOAD duck_lk;
Example
-- Set LABKEY_BASE_URL, LABKEY_CONTAINER_PATH, and LABKEY_API_KEY env vars, then:
SELECT * FROM labkey_query('lists', 'People');
About duck_lk
Query LabKey Server tables directly from DuckDB with automatic local
Parquet caching and staleness detection. Provides labkey_query() for
data access, labkey_cache_info() for cache inspection, and
labkey_cache_clear() for cache management. Read-only access with
transparent staleness detection.
For full documentation, see the GitHub repository.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| labkey_cache_clear | table | NULL | NULL | |
| labkey_cache_info | table | NULL | NULL | |
| labkey_query | table | NULL | NULL |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases | |——|————-|————|——-|———|