---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: keboola
excerpt: |
  DuckDB Community Extensions
  DuckDB extension for Keboola Storage — query and write Keboola tables using standard SQL

extension:
  name: keboola
  description: "DuckDB extension for Keboola Storage — query and write Keboola tables using standard SQL"
  version: "0.1.7"
  language: C++
  build: cmake
  license: MIT
  excluded_platforms: wasm_mvp;wasm_eh;wasm_threads
  maintainers:
    - keboola

repo:
  github: keboola/duckdb-extension
  ref: 7c2afb8ea0136b52be3128fbb25bc9519f39f4a3

docs:
  hello_world: |
    -- Install and load the extension
    INSTALL keboola FROM community;
    LOAD keboola;

    -- Connect to Keboola Storage
    ATTACH 'https://connection.keboola.com' AS kbc (
        TYPE keboola,
        TOKEN 'my-storage-api-token'
    );

    -- Read data
    SELECT * FROM kbc."in.c-crm".contacts WHERE status = 'active';

    -- Write data
    INSERT INTO kbc."in.c-crm".contacts VALUES ('42', 'Alice', 'alice@acme.com');

    -- Use secrets for credential management
    CREATE SECRET my_kbc (
        TYPE keboola,
        TOKEN 'my-storage-api-token',
        URL 'https://connection.keboola.com'
    );
    ATTACH '' AS kbc2 (TYPE keboola, SECRET my_kbc);
  extended_description: |
    The Keboola extension exposes Keboola Storage as a native DuckDB database.
    Once attached, you can use standard SQL to read from and write to Keboola
    tables, join Keboola data with local DuckDB tables, and manage schemas.

    **Features:**
    - SELECT with filter and projection pushdown to Keboola Query Service
    - INSERT, UPDATE, DELETE via Keboola Storage Importer API
    - CREATE TABLE, CREATE SCHEMA, DROP TABLE, DROP SCHEMA DDL support
    - SNAPSHOT mode: pull all data locally for offline/low-latency queries
    - Secret management for secure credential storage
    - Native Keboola type mapping (Snowflake types → DuckDB types)
    - Table and column descriptions from KBC metadata

extension_star_count: 1
extension_star_count_pretty: 1
extension_download_count: 3380
extension_download_count_pretty: 3.4k
image: '/images/community_extensions/social_preview/preview_community_extension_keboola.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 |
|-------------------------|---------------|-------------|---------|----------|
| keboola_pull            | table         | NULL        | NULL    |          |
| keboola_refresh_catalog | scalar        | NULL        | NULL    |          |
| keboola_tables          | table         | NULL        | NULL    |          |
| keboola_version         | scalar        | 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>

This extension does not add any settings.