---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: duck_lk
excerpt: |
  DuckDB Community Extensions
  Query LabKey Server tables with automatic local Parquet caching

extension:
  name: duck_lk
  description: Query LabKey Server tables with automatic local Parquet caching
  version: 0.1.3
  language: Rust
  build: cmake
  license: MIT OR Apache-2.0
  requires_toolchains: "rust"
  excluded_platforms: "wasm_mvp;wasm_eh;wasm_threads;linux_amd64_musl;windows_amd64_mingw;windows_amd64_rtools"
  maintainers:
    - nrminor

repo:
  github: nrminor/duck-lk
  ref: 5c89b0a15c8294849bb3f7cbec82bf7c54a8495a

docs:
  hello_world: |
    -- Set LABKEY_BASE_URL, LABKEY_CONTAINER, and LABKEY_API_KEY env vars, then:
    CALL labkey_sync('lists', 'People');
    FROM People LIMIT 10;
  extended_description: |
    Query LabKey Server tables directly from DuckDB with automatic local
    Parquet caching and staleness detection. Provides `labkey_query()` for
    one-shot access, `labkey_sync()` for explicit cache warming, and helper
    functions like `labkey_cache_info()` and `labkey_cache_clear()` for cache
    inspection and management. For best performance on repeated analysis,
    sync the table first and then query the synced table directly so DuckDB
    can read the cached Parquet natively.

    For full documentation, see the [GitHub repository](https://github.com/nrminor/duck-lk).

extension_star_count: 1
extension_star_count_pretty: 1
extension_download_count: 615
extension_download_count_pretty: 615
image: '/images/community_extensions/social_preview/preview_community_extension_duck_lk.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ |
| Linux ARM64 | ❌ | ❌ | ❌ | ❌ | ✅ |
| macOS AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ |
| macOS ARM64 | ❌ | ❌ | ❌ | ❌ | ✅ |
| Windows AMD64 | ❌ | ❌ | ❌ | ❌ | ✅ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

|    function_name    | function_type | description | comment | examples |
|---------------------|---------------|-------------|---------|----------|
| labkey_cache_clear  | table         | NULL        | NULL    |          |
| labkey_cache_info   | table         | NULL        | NULL    |          |
| labkey_is_stale     | scalar        | NULL        | NULL    |          |
| labkey_parquet_path | scalar        | NULL        | NULL    |          |
| labkey_query        | table         | NULL        | NULL    |          |
| labkey_sync         | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|      name      |                       description                       | input_type | scope  | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR    | GLOBAL | []      | post.db.tmp |