DuckDB Destination PluginLatest: v1.0.2
This destination plugin lets you sync data from a CloudQuery source to a DuckDB (opens in a new tab) database.
This is a basic configuration that will save all your sync resources to
kind: destination spec: name: duckdb path: cloudquery/duckdb version: "v1.0.2" write_mode: "overwrite-delete-stale" spec: connection_string: /path/to/example.db
cloudquery sync, you can explore the data locally with the DuckDB CLI:
overwrite-delete-stale, but the plugin also supports
append. Note that
overwrite-delete-stale modes do not support atomic updates: to update a resource, it is first deleted and then re-inserted. This is due to a current lack of support in DuckDB for upserting list-type columns. If this is an issue for you, consider using the
append mode instead. You may then perform a manual cleanup of stale resources after the sync completes.
Note that this plugin does currently not support Windows. See this issue (opens in a new tab) for more details.
This is the top level spec used by the DuckDB destination Plugin.
Absolute or relative path to a file, such as