Establish a read-only connection to the OmicIDX DuckDB database.

The omicidx DuckDB database is hosted remotely and accessed via the httpfs extension. This function sets up a connection to the database for querying. The connection is a normal DuckDB connection, but the database file is read-only.

Usage

omicidx_duckdb_connection()

Value

A DBI connection object to the OmicIDX DuckDB database.

Examples

if (FALSE) { # \dontrun{
con <- omicidx_duckdb_connection()
DBI::dbListTables(con)
# Example query
res <- DBI::dbGetQuery(con, "SELECT * FROM sra_runs LIMIT 10")
print(res)
} # }