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
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.