DuckdbSource

DuckdbSources hold the connection information to DuckDB data sources.

Example

Simple

    sources:
      - name: duckdb_source
        type: duckdb
        database: local/file/database.db
        connection_pool_size: 2

Note

Recommended environment variable use is covered in the sources overview.

Attributes

Field	Type	Default	Description
path	string	None	A unique path to this object
name	string	None	The unique name of the object across the entire project.
host	string	None	The host url of the database.
port	integer	None	The port of the database.
database	string	None	The database that the Visivo project will use in queries.
username	string	None	Username for the database.
password	string	None	Password corresponding to the username.
db_schema	string	None	The schema that the Visivo project will use in queries.
type	string	None
connection_pool_size	integer	1	The pool size that is used for this connection.
attach	Any of: DuckdbAttachment, array	None	List of other local Duckdb database sources to attach in the connection that will be available in the base SQL query.