Skip to main content

DuckDB Engine Configuration

DuckDB is a vectorized database query engine that excels at analytical queries and can read Iceberg tables efficiently.

Configuration Options​

KeyTypeDefaultDescription
urlstring"jdbc:duckdb:"Full JDBC URL for the database connection
use-disk-cachebooleanfalseInstall and load cache_httpfs extension
use-version-guessingbooleanfalseSets unsafe_enable_version_guessing flag to be able to read uncommitted data

Example Configuration​

{
  "engines": {
    "duckdb": {
      "url": "jdbc:duckdb:",
      "use-disk-cache": true,
      "use-version-guessing": true
    }
  }
}

Usage Notes​

  • Ideal for local development and testing of analytical workloads
  • Excellent performance on analytical queries with vectorized execution
  • Can read Iceberg tables directly without additional infrastructure
  • Supports both in-memory and persistent database modes
  • Perfect for prototyping before deploying to cloud query engines like Snowflake
  • Lightweight alternative to larger analytical databases