claims_db: Connect to the Synthetic Claims Database

In jfangmeier/claimsdb: Relational Data from the CMS Data Entrepreneurs Synthetic PUF for Learning and Teaching

Description

Provides a connection to a DuckDB database of the CMS synthetic claims data. Alternatively, you can use claims_db() to manually connect to the database using DBI::dbConnect() and duckdb::duckdb().

Usage

claims_connect(dbdir = ":memory:", ...)

claims_disconnect(con)

claims_db()

Arguments

dbdir	Location for database files. Should be a path to an existing directory in the file system. With the default, all data is kept in RAM
...	Additional parameters passed to DBI::dbConnect()
con	A connection to the Star Wars database

Value

A connection to the synthetic claims database, or the path to the database.

Functions

• claims_connect: Connect to the DuckDB database

• claims_disconnect: Disconnect from the DuckDB database

• claims_db: Returns the path to the claimsdb database

Examples

# Manually connect using {duckdb} and {DBI}
con <- DBI::dbConnect(
  duckdb::duckdb(),
  dbdir = claims_db(),
  read_only = TRUE
)

if (requireNamespace("dplyr", quietly = TRUE)) {
  dplyr::tbl(con, "bene")
}

# Disconnect from that database (shutdown is specific to duckdb)
DBI::dbDisconnect(con, shutdown = TRUE)

# Or connect without worrying about connection details
con <- claims_connect()

if (requireNamespace("dplyr", quietly = TRUE)) {
  dplyr::tbl(con, "bene")
}

# Similarly, disconnect quickly without worrying about duckdb arguments
claims_disconnect(con)

jfangmeier/claimsdb documentation built on Feb. 14, 2022, 6:01 a.m.