Create a Zero-Copy Federated Consortium Connection — create_federated

Attaches multiple site DuckDB databases in read-only mode and generates unified v_* views (e.g. v_person, v_visit_occurrence) with site_id and site_anon provenance columns. Optionally attaches a central Athena vocabulary.

Usage

create_federated_consortium(
  site_dbs,
  central_vocab_db = NULL,
  output_con = NULL
)

Arguments

site_dbs: Named character vector or list mapping site labels/pseudonyms (e.g. c("Site A" = "site1.duckdb", "Site B" = "site2.duckdb")) to DuckDB database paths.
central_vocab_db: Optional path to an Athena vocabulary DuckDB database.
output_con: Optional DuckDB connection. If NULL, creates a new in-memory connection.

Value

DuckDB connection with attached site databases and unified v_* views.