extension-driver-duckdb
Duckdb driver for Vulcan SQL
Install
-
Install package
npm i @vulcan-sql/extension-driver-duckdb
-
Update vulcan.yaml
, enable the extension.
extensions:
duckdb: '@vulcan-sql/extension-driver-duckdb'
-
Create a new profile in profiles.yaml
or in your profiles' paths.
- name: duck
type: duckdb
connection:
persistent-path: 'path-to-a-folder'
log-queries: false
log-parameters: false
configuration-parameters:
region?: string
accessKeyId?: string
secretAccessKey?: string
sessionToken?: string
endpoint?: string
url_style?: string
use_ssl?: boolean
-
Environment Variables
- DUCKDB_EXECUTE_CHUNK_SIZE: Optional, dafult 2000. The data chunk size, we will acquire this size of data using conn.all() at once and get the rest of data using conn.stream to prevent from OOM, this parameter will affect the API performance and server memory usage.
- DUCKDB_THREADS: Optional, if not been set, use used duckdb default thread value.